<ASK How to add columm more than the default columm IV
 

Dear all.

the problem is in excel the default columm is from columm A to colum IV. and
i want to add more columm that mean it will be have the columm IW,IX,IY,IZ
and so on till unlimited or till columm ZZ. how can i add the colum from IW
to ZZ??? please help me to solve the problem. cause i really need use that
much columm. or can i switch it's columm be row and the row be columm??? how
can i do it?

<ASK How to add columm more than the default columm IV
 

You can't unless you upgrade to Excel2007!

Regards,
Stefi

€žjohannes€� ezt Ã*rta:

Dear all.

the problem is in excel the default columm is from columm A to colum IV. and
i want to add more columm that mean it will be have the columm IW,IX,IY,IZ
and so on till unlimited or till columm ZZ. how can i add the colum from IW
to ZZ??? please help me to solve the problem. cause i really need use that
much columm. or can i switch it's columm be row and the row be columm??? how
can i do it?

<ASK How to add columm more than the default columm IV
 

You'll need to transpose your arrangement of data & formulas from a columnar
approach to a row-oriented approach. Or, as stefi mentioned, switch to Excel
2007 which offers 10,000 columns instead of 256.

"Stefi" wrote:

You can't unless you upgrade to Excel2007!

Regards,
Stefi

€žjohannes€� ezt Ã*rta:

Dear all.

the problem is in excel the default columm is from columm A to colum IV. and
i want to add more columm that mean it will be have the columm IW,IX,IY,IZ
and so on till unlimited or till columm ZZ. how can i add the colum from IW
to ZZ??? please help me to solve the problem. cause i really need use that
much columm. or can i switch it's columm be row and the row be columm??? how
can i do it?

<ASK How to add columm more than the default columm IV
 

Info only.

Excel 2007 has 16,384 columns.


Gord Dibben MS Excel MVP

On Tue, 16 Sep 2008 04:08:01 -0700, Duke Carey
wrote:

You'll need to transpose your arrangement of data & formulas from a columnar
approach to a row-oriented approach. Or, as stefi mentioned, switch to Excel
2007 which offers 10,000 columns instead of 256.