Grouping Worksheets

K

Karen

Using Excel XP
I have a spreadsheet that was created on Excel 2000 - Now
I'm opening it in XP (I don't know if knowing thast
matters - I'll mention it anyway) - It consists of 4
sheets. Let's say that currently Sheet 1 is active -
When I click on Sheet 2, Sheet 1 & 2 are grouped and I
have to ungroup them and so on with the following
sheets. How do I stop this?

Thank you
 
N

nilizandr

i'm not sure what you mean by grouped? do you mean that all o
worksheets are active (i.e. all tabs are highlighted)? if so, is i
possible that your control or shift ket is stuck? if so, you'd notic
other strange things happening with your computer. if not, try righ
clicking on the tabs of one of the grouped worksheets, and choos
insert new worksheet. this should break up the group. the number o
inserted worksheets will be equal to the number of worksheet
highlighted when you choose 'insert', so don't be alarmed. you ca
delete unwanted sheets afterwards.
this is just a temporary fix. not sure what, other than pressing dow
control or shift, would cause this to happen regularly
 
G

Gord Dibben

Karen

Tap gently on both of your CRTL keys. Sounds like one is stuck.

Gord Dibben Excel MVP
 
Top