Problem inserting a column!!!

L

londonchick

Hello all.

I just accessed a worksheet which Im trying to add a column to...
I highlight the column which i want the new column inserted ...and when
i try to insert a column it doesnt work! A warning message comes up
stating that a column cannot be inserted until blank cells are removed
from the right side of the sheet or something to that effect!?
Whats going on???

Thank you.
 
D

dominicb

Good afternoon Londonchick

A worksheet can only contain 256 columns. If all your cells in column
256 (IV) are not blank how can Excel insert a new column? Answer - it
gives an error.

Just go to cell IV1 and press the End button and then the down arrow -
this will take you to the first (or only) offending cell. Delete the
contents and you should be able to insert your column again.

HTH

DominicB
 
D

Don Guillett

You have data in all the cells to the right of what is actually used. use
ctrl+end to see. Delete the unneeded and SAVE. Try again.

--
Don Guillett
SalesAid Software
(e-mail address removed)
"londonchick" <[email protected]>
wrote in message
news:[email protected]...
 

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

Two columns followed by single page-width column on same page 0
Single column to multiple columns 5
Insert Index into a Table 1
Referring to columns in the text of a cell 2
How to do an IF statement that copy data based on a partial match 0
Inserting a column to the Gantt view 0
Why no "insert copied cells"? 1
Getting Radio Buttons to work, that are inserted via AutoText 0

Top