98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Selecting Multiple Worksheets
Selecting Multiple Worksheets
Resolved · Medium Priority · Version 2010
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
Wed 15 May 2013: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Adding cells, Rows & columnsplace your cursor on a cell, row number or column letter and use CTRL + SHIFT + + or CTRL + + depending on which + you prefer to use. |