Forum Discussion

Brass Contributor

Jan 15, 2020

Solved

Selection of Multiple Sheets by one click

Hi 🙂 How to select multiple sheets by one click on arranged shape. Eg I have following sheets. Sheet1 Sheet2 Sheet3 Sheet4 I need to seelct Sheet1, Sheet2 and Sheet3 by clicking ...

excel

PascalKTeam
Jan 17, 2020
Hi Sameer_Kuppanath_Sultan

I hope attached video explains how to do it
2020-01-17_10h28_53.mp41.6 MB

PascalKTeam

Iron Contributor

Jan 15, 2020

Hi Sameer_Kuppanath_Sultan

Please see attached file. Click the image and all sheets are selected. Is that what you need?

select all sheets.xlsm33 KB

Sameer_Kuppanath_Sultan
Brass Contributor
Jan 15, 2020
Hi

PascalKTeam

I dont want to use VBA !

Also, please note, i need to select 3 sheets out of 4 sheets.
- Sameer_Kuppanath_Sultan
  Brass Contributor
  Jan 15, 2020
  my intention is to report to management with some specified sheets to show, from 100s of sheets in the work book.
  
  I cannot select one by one to hide and unhide.
  - PascalKTeam
    Iron Contributor
    Jan 15, 2020
    Without VBA there is no "1" click solution.
    
    You could select the first sheet, hold down the shift key and then select the last sheet