Inserting Columns

G

Guest

I have inherited a spreadsheet that I did not create. I am trying to insert
columns, but when I attempt to do this, I get an error statement saying
"To prevent possible loss of data, Microsoft Excel cannot shift nonblank
cells of the worksheet. Try to delete or clear the cells to the right and
below your data. then select cell A1, and save your workbook to reset the
last cell used. Or, you can move your data to a new location and try again.
I have done everything I think I can do, including clearing out the entire
spreadsheet un-merging cells. I still get the same error statement. Can
anyone please help put me on the right track.

Thanks.
 

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

Having Trouble Inserting a Column 1
I can't insert column in Excell file! Help please 2
How Can I Insert A Column in A Spreadsheet With This Error Message 1
I am having trouble adding a row in Excel. What am i doing wrong? 1
Can't insert a simple row 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Error when trying to insert columns: "Nonblanc cells" 1
Cannot insert a row in Excel spreadsheet 3

Top