close

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

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

--
Kind regards,

Niek Otten

quot;arcticalequot; gt; wrote in message ...
| 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
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!!!

quot;arcticalequot; wrote:

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()