Problem inserting a column!!!

[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.

 

[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

 

[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]...