Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel automatically goes into 'Group' mode while toggling between worksheets
Hi,
I have observed this peculiar problem while using Excel 2007: When a user toggles between different worksheets, by using Ctrl+Shift+PgUp (or Ctrl+Shift+PgDn), the excel file automatically goes into 'Group' mode. Effectively, all changes made in the target worksheet are overwritten from the source worksheet, wasting hours of work done earlier. Is there any workaround for this? Or should we avoid using these shortcut keys? Thanks in advance, Rangin. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel automatically goes into 'Group' mode while toggling between worksheets
Do not use the Shift key.
CTRL + pgup or pgdn is the shortcut to cycle through sheets. Gord On Mon, 19 Mar 2012 17:21:07 +0000, Rangin wrote: Hi, I have observed this peculiar problem while using Excel 2007: When a user toggles between different worksheets, by using Ctrl+Shift+PgUp (or Ctrl+Shift+PgDn), the excel file automatically goes into 'Group' mode. Effectively, all changes made in the target worksheet are overwritten from the source worksheet, wasting hours of work done earlier. Is there any workaround for this? Or should we avoid using these shortcut keys? Thanks in advance, Rangin. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Toggling through Excell Worksheets | Excel Discussion (Misc queries) | |||
XL2003: Toggling "Extend" Mode with VBA | Excel Programming | |||
I want to update an excel 2007 file automatically in batch mode. | Excel Programming | |||
Tab Colors in Group Mode | New Users to Excel | |||
Using Group Mode in Excel...Cursor behavior. | Excel Discussion (Misc queries) |