Has anyone heard of this error?

  • Thread starter Thread starter ceblaser
  • Start date Start date
C

ceblaser

I have a fairly large spreadsheet that contains information all the way
over into column EE.

I have grouped some of the related columns together. However, I keep
getting a "Can't Shift Object Off Sheet" error when ever I try to group
up a particular section of data. I have tried to ungroup and regroup
this section but keep getting the same error whenever I press the
button to hide the extra columns. I also get the error whenever I try
to manually make the width of a column smaller.

I need to correct this error so I can group data and resize columns.
If you know how to do this, I would appreciate your help.


Thanks.
 
I'm not sure if this applies to your situation, but
whenever I received that error it was because there was
data on the right-most column (maybe a space, or whatnot).
 
You may have something in a column or row that is preventing the expansion.
Delete all unneeded rows and all columns and SAVE the workbook. Try again.
 
Back
Top