I can't insert a new column in a sheet

G

Guest

I want to insert a new column between col B & C in a sheet. I highlight the
whole col C, right click and select insert, I get the following message.
"To prevent possible loss of data, MS Excel cannot shift nonblank cells off
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 the data to a new location and try again."
I have tried clearing the cells to the right and below and I still can't get
a column to insert.
Any suggestions are appreciated.
 
G

Guest

You may have stuff in column IV. If so, Excel won't allow any column
insertion:

1. select column IV and delete it.
2. save the file, close the file, and then re-open it
3. re-try the insertion
 

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

Cannot Insert Column 1
Unable to Insert Columns 5
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
Can't insert new columns into worksheet 1
Excel Error Help 1
Can't insert row in Excel 6
Error message "cannot shift nonblank cells off the worksheet" 2
inserting a column 2

Top