unable to hide columns -"can not shift objects off sheet" shows

G

Guest

I am not able to hide few columns of my spread sheet, the screen shows "can
not shift objects off sheet" anybody can help me out?
 
G

Guest

Press the F5 key, click on the Special button, then click on Objects& OK.
This will select all the objects, allowing you to see what is in the
spreadsheet.

If you have objects (charts, text boxes, etc) that you don't intend to have,
you can delete them. Otherwise, move them to where they don't cause you
problems.
 
M

Marc

Google is your friend... a search for that phrase will get lots of hits, and
support.microsoft.com has a good knowledgebase for this stuff...

From microsoft:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q170081

CAUSE
This problem occurs if both of the following conditions are true: . You
create a cell comment in any cell in a column.

-and-
. You try to hide the column to the left of the column with the cell
comment, the column with the cell comment, and all the columns to the right
of the column with the cell comment.
For example, this problem occurs if you place a cell comment in cell IR1,
and then try to hide columns IQ:IV (at one time).

NOTE: Depending on the location of the column that contains the cell
comment, you receive the error if you try to hide the column with the cell
comment and all the columns to the right of the column with the cell
comment.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top