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
 
Top