Excel will not let me group columns

[Guest]

I have 84 columns of data (7 years) I use the group command to hide the
monthly data.

Excel will let me group 6 of the years and always leave one open. Excel
responds with "Cannot Shift Object off Sheet."

What am I doing wrong?

 

[George Nicholson]

Check out
http://support.microsoft.com/default.aspx?scid=kb;en-us;211769

the problem is with cell comments (or other objects) inserted into cells
within the range you are trying to hide.

--
HTH,

George Nicholson
(Please post responses to newsgroup but remove "Junk" from return address if
used)

 

[Guest]

Will try, It makes sense now.

Thank you

Mike Fairbourne