selecting multiple worksheets

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Selecting Multiple Worksheets

Selecting Multiple Worksheets

resolvedResolved · 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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Adding cells, Rows & columns

place your cursor on a cell, row number or column letter and use CTRL + SHIFT + + or CTRL + + depending on which + you prefer to use.

View all Excel hints and tips


Server loaded in 0.08 secs.