Greta has attended:
Excel Advanced course
Selecting Multiple Worksheets
To whom it may concern,
I have been trying to select multiple worksheets, unsuccessfully. I was told I had to select the first worksheet, then go to the last one and select it whilst also pressing SHIFT. However, it does not work. I tried even selecting multiple ones by using CTRL but still I can only select one at the time.
Is there another way to select multiple worksheet other than doing 'select all', which would not help since I do not need to select all worksheets?
Your help is very much appreciated!
Thansk in advance,
Greta
RE: Selecting Multiple Worksheets
Hi Greta
Thanks for getting in touch. It sounds like you are doing everything correctly.
Hold SHIFT to select sheets in a range, or CTRL to select individual sheets.
The only reason I can think of this not working is by restrictions placed by the creator of the worksheet?
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Selecting Multiple Worksheets
Hi Gary,
Thanks for your quick response. I am the creator of the workbook and I am pretty sure I did not place any restrictions. Just to make sure, how could I remove this particular restriction if this was the case?
Thanks in advance!
Greta
RE: Selecting Multiple Worksheets
Hi Greta
It's very deliberate, the options are in Review > Protect Sheet. So it's unlikely you've accidentally turned these on.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector