Excel 2007 - Insert Columns

[mman493]

When I try to insert a column on my spread sheet, I get the following error
message:

"Cannot shift objects off sheet."

What does that mean?

Thanks

 

[Duke Carey]

Somehow you have an "object" (a chart or a text box, for instance) on the
sheet, way off to the right, presumably. Sometimes you can't see them

Press the F5 function key, click on the Special button, and choose objects.
Every object on the sheet will be selected. You can press the Tab key to
move from one to the next. Find one way out right and delete it.

 

[mman493]

Thanks, but that did not work. All I got was "no objects found". Any other
suggestiions?

 

[Duke Carey]

OK, that's outside my experience.

The other thing to try (guessing here) -
press Ctrl-End.
Select the next column to the right
Hold down the Shift key and press Ctrl right arrow (selects all the
remaining cols)
Let go of the shift key
Press Ctrl-Spacebar (selects all the remaining cols)
Press Ctrl minus sign.

See if you can then insert columns

 

[pshepard]

Hi All,

I have had this problem when a worksheet was copied from cell a1 through the
last row and the last column - including the blank cells into another
worksheet. Excel looks at copied blank cells as having content.

If this is the case, then Ctrl+end will take you to the last column in the
worksheet.

The only way to have it recognize that the content is blank is to delete the
blank columns and save the file. The deleted columns will not be recognized
until after the file is saved.

Go to any row in the first column after that is after the last column with
data.
Hold the shift button then press the end button then the right arrow button
to highlight the row of cells in the empty columns.

From the Edit menu, select Delete, Entire column.

Save your file.

Let me know if this works for you.

Peggy

 

[mman493]

Sorry for the late reply. Thanks for the help. I followed your instructions
and it did select columns to the right of the last data. I deleted those
columns and saved, but when I called the spreadsheet back up, I got the same
message.

 

[pshepard]

Can you send me the file to see what it has?

(e-mail address removed)

 

[mman493]

Ok. The original file has confidential data, but I deleted all the worksheets
with data and it STILL won't insert a column. I will send you that file from
(e-mail address removed). It's called Excel 2007 problem file.

Thanks again.