insert column move object

G

Guest

Hi I ma trying ot insert a column in excel and get Can not shift objects off
sheet - What do I do?
 
D

Don Guillett

use ctrl+end to see the last row/column. Then end+up arrow. Delete un-needed
rows>SAVE>try again.
 
G

Guest

there may be, or at least Excel thinks there is, something in the last column.
try selecting a bunch of columns past your data and deleting them.

A workaround for files that do not wnat to cooperate is to select all of
your columns to the right of where you want to add the column or columns and
move them to the right the number of columns you want to add.

The risk with this is that in inherited files there might be hidden data you
would be over writing. I would check with a method such as =Counta(columns
of interest), if the answer is greater than 0. there is something there.
 

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