Can't insert column; keep receiving error message

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I was updating a large spreadsheet and all of a sudden I was unable to insert columns. I kept getting an error message that said, "...unable to shift nonblank cells off worksheet." I tried everything from unhiding all columns and rows toreformatting all the comments to move and size with their relative cells. I also removed all the comments and I was still unable to insert a column. Does anyone have a solution

Thank you
 
-----Original Message-----
I was updating a large spreadsheet and all of a sudden I
Click to expand...
was unable to insert columns. I kept getting an error
message that said, "...unable to shift nonblank cells off
worksheet." I tried everything from unhiding all columns
and rows toreformatting all the comments to move and size
with their relative cells. I also removed all the
comments and I was still unable to insert a column. Does
anyone have a solution?
Thank you
.
I have seen this before. Try hitting ctrl-end. I think
Click to expand...
this should take you to the bottom row and right most
column with data in it. Then hit end up to find a cell in
the column that may have data in it. Erase the data and
try again. If that does not work, what is the rightmost
column with data in it?
 

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

Unable to Insert Columns 5
How to add columns to the end of a spreadsheet--(last col is IV)? 2
Can't insert column; keep receiving error message 1
Inserting a column 1
Can't insert new columns into worksheet 1
Error message when trying to insert a column 8
can't insert columns between columns 1
Error message "cannot shift nonblank cells off the worksheet" 2

Back
Top