ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   excel (https://www.excelbanter.com/excel-worksheet-functions/142296-excel.html)

seafarer

excel
 
Help - my spreadsheet is frozen on 1 sheet in the file & I can't move to
another sheet - it seems to be 'selecting' the other sheets I try and access
have tried saving as another file but still same error

oli merge

excel
 
I think you have accidently pressed control when clicking one of the tabs -
try right clicking and selecting 'ungroup all'.

btw, this grouping is useful if you want to do stuff like have the same
header on every sheet etc

"seafarer" wrote:

Help - my spreadsheet is frozen on 1 sheet in the file & I can't move to
another sheet - it seems to be 'selecting' the other sheets I try and access
have tried saving as another file but still same error


Gord Dibben

excel
 
oli

Info only...............

You can still change from sheet to sheet when in group mode.


Gord Dibben MS Excel MVP

On Thu, 10 May 2007 07:54:02 -0700, oli merge
wrote:

I think you have accidently pressed control when clicking one of the tabs -
try right clicking and selecting 'ungroup all'.

btw, this grouping is useful if you want to do stuff like have the same
header on every sheet etc

"seafarer" wrote:

Help - my spreadsheet is frozen on 1 sheet in the file & I can't move to
another sheet - it seems to be 'selecting' the other sheets I try and access
have tried saving as another file but still same error




All times are GMT +1. The time now is 07:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com