how do i remove the limit set on the worskheet i am working on

A

arcticale

The worksheet I working on is only up to column AK.I want to use columns in
my worksheet. How do I remove the limit that was set in the worksheet so that
I have more columns? The worksheet is not allowing me to insert columns.

thanks a lot,
del
 
N

Niek Otten

All versions of Excel of the last decade have columns A thru IV. Columns may be hidden. Press CTRL+A, Format>Columns>Unhide,
hopefully there was no password set.

--
Kind regards,

Niek Otten

| The worksheet I working on is only up to column AK.I want to use columns in
| my worksheet. How do I remove the limit that was set in the worksheet so that
| I have more columns? The worksheet is not allowing me to insert columns.
|
| thanks a lot,
| del
 
M

Manoj

The sheet could have been protected or there is a cell used in the column IV

Hit control+end and see if it takes you to column IV. If it does then hit
the Del key to clear the contents of that cell. it couuld also happen that
the used cell in any of the rows. so highlight the entire column IV and hit
the del key to clear the contents. then try inserting columns. sometimes
accidently some character or even space is entered in the last column and
this prevents the insertion of columns.

See if this works!!!
 
Top