Problem inserting a column!!!

  • Thread starter Thread starter londonchick
  • Start date Start date
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.
 
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
 
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]...
 
Back
Top