I can't select all my worksheets in Excel

D

Dan Connors

I am unable to select all of my worksheets in my workbook. I know of all the
different ways to do it, but is there a setting somewhere that would prevent
me from selecting my sheet tabs...other than a protected worksheet?
 
D

Dave Peterson

Not that I can think of.

And even if the worksheet were protected, you should be able to select any sheet
(or group any sheets).
 
E

exceluserforeman

Hold down the Control key then select the sheets one at a time

Hold down the Shift key then select the last sheet

- -Mark
 
Top