Insert Comment is disabled

[Guest]

Using Excel 2003, I chose the menu option Insert -> Comment. The comment
field opened, with my user name. I attempted to select all text in the
comment with the key combination Ctrl-Shift-Home, and somehow hit other keys,
because I ended up on the previous worksheet. So, I must have at least hit
Ctrl-PageUp. However, now the Insert -> Comment option is disabled
(greyed-out) for that workbook. So are Insert -> Hyperlink, -> Chart, ->
Diagram, -> Symbol, and -> Object. These options are disabled everywhere in
the workbook. However, I can start an entirely new workbook, and these
options are not disabled. Wha' happen?

 

[Debra Dalgleish]

You probably hit Ctrl+Shift+PageUp (or PageDown) and now two or more
sheets are grouped. If so, the title bar will show [Group] at the end of
the file name.
Anything you type or format, may happen to all the grouped sheets.
To ungroup, right-click on one of the selected sheet tabs, and choose
Ungroup Sheets.

 

[invincibleruler]

thanks

I have been looking for a solution to the problem for a long time and here it is.
Thanks a lot.

You probably hit Ctrl+Shift+PageUp (or PageDown) and now two or more
sheets are grouped. If so, the title bar will show [Group] at the end of
the file name.
Anything you type or format, may happen to all the grouped sheets.
To ungroup, right-click on one of the selected sheet tabs, and choose
Ungroup Sheets.

grids7 wrote:
> Using Excel 2003, I chose the menu option Insert -> Comment. The comment
> field opened, with my user name. I attempted to select all text in the
> comment with the key combination Ctrl-Shift-Home, and somehow hit other keys,
> because I ended up on the previous worksheet. So, I must have at least hit
> Ctrl-PageUp. However, now the Insert -> Comment option is disabled
> (greyed-out) for that workbook. So are Insert -> Hyperlink, -> Chart, ->
> Diagram, -> Symbol, and -> Object. These options are disabled everywhere in
> the workbook. However, I can start an entirely new workbook, and these
> options are not disabled. Wha' happen?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html