Problem inserting a column!!!

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.


--
londonchick
------------------------------------------------------------------------
londonchick's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24529
View this thread: http://www.excelforum.com/showthread.php?threadid=401890

Don
Mon Sep 05 07:55:30 CDT 2005

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
donaldb@281.com
"londonchick" <londonchick.1uvuia_1125918303.4801@excelforum-nospam.com>
wrote in message
news:londonchick.1uvuia_1125918303.4801@excelforum-nospam.com...
>
> 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.
>
>
> --
> londonchick
> ------------------------------------------------------------------------
> londonchick's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=24529
> View this thread: http://www.excelforum.com/showthread.php?threadid=401890
>

dominicb
Mon Sep 05 07:17:14 CDT 2005


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


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=18932
View this thread: http://www.excelforum.com/showthread.php?threadid=401890