I can't select all my worksheets in Excel
 

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?

I can't select all my worksheets in Excel
 

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).


Dan Connors wrote:

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?

--

Dave Peterson

I can't select all my worksheets in Excel
 

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

Hold down the Shift key then select the last sheet

- -Mark






"Dan Connors" wrote:

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?