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.

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.