shifting of nonblank cells

P

Paula Monahan

I'm trying to insert a column on a worksheet. All the
columns are unhidden and no cells are merged. When I try
to insert the column, I get this error message:
To prevent possible losss of data, Microsoft Excel cannot
shift nonblank cells off the worksheet. To to delete or
clear cells to the right or below the data......

I have been able to insert columns before on this
worksheet. I have no idea why this message is coming up
now.

Please help.
 
J

jeff

Hi,

As I recall, this message is telling you that at one
(or both) ends (horizontally or vertically) of the
spreadsheet, there's data that will be lost by inserting
a new column ( or row) (because it will be "pushed" off
the sheet by the limits of columns (or rows)). Go to
column IV (End, right arrow) and check for data.

jeff
 

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

Similar Threads


Top