troubleshoot inserting columns in a spreadsheet
 

Cannot insert columns in a worksheet - gives an error message:
To prevent possible loss of data, Microsoft Office Excel cannot shift
nonblank cells off the worksheet.
Try to locate the last nonblank cell by pressing Ctrl + End, and delete or
clear all in cells between the last cell and the end of your data. The
select cell A1 and save your workbook to reset the last cell used.
Or, you can move the data to a new location and try again.

I have followed the instructions, but no help.
any thoughts???

troubleshoot inserting columns in a spreadsheet
 

Hi Quinn,

Using the scroll bar at the bottom of your screen, scroll to the right as
far right as you can (to the very last column - IV)
Check the entire column for any stray data that you may have entered.
Once you find the cell with data in it (probably stray data) delete the
contents.
Then try to insert your column and you should be good.

Good luck!

Pamela :)

"quinn111" wrote:

Cannot insert columns in a worksheet - gives an error message:
To prevent possible loss of data, Microsoft Office Excel cannot shift
nonblank cells off the worksheet.
Try to locate the last nonblank cell by pressing Ctrl + End, and delete or
clear all in cells between the last cell and the end of your data. The
select cell A1 and save your workbook to reset the last cell used.
Or, you can move the data to a new location and try again.

I have followed the instructions, but no help.
any thoughts???

troubleshoot inserting columns in a spreadsheet
 

Pameluh - I deleted everything but the data before I posted, that didn't
work, so that is why I posted this question. What I ended up doing was
copying just the data and not the headings over to another worksheet and
saved it, then tried adding a column and that worked, so I copied the
headings over and then the inserting a column didn't work, so I ended up
typing in the headings again. Oh well, at least I can add a column now. I
never seen anything like this.
Thanks for trying.

"pameluh" wrote:

Hi Quinn,

Using the scroll bar at the bottom of your screen, scroll to the right as
far right as you can (to the very last column - IV)
Check the entire column for any stray data that you may have entered.
Once you find the cell with data in it (probably stray data) delete the
contents.
Then try to insert your column and you should be good.

Good luck!

Pamela :)

"quinn111" wrote:

Cannot insert columns in a worksheet - gives an error message:
To prevent possible loss of data, Microsoft Office Excel cannot shift
nonblank cells off the worksheet.
Try to locate the last nonblank cell by pressing Ctrl + End, and delete or
clear all in cells between the last cell and the end of your data. The
select cell A1 and save your workbook to reset the last cell used.
Or, you can move the data to a new location and try again.

I have followed the instructions, but no help.
any thoughts???