| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
<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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
<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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
<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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
<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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to insert a row of consective numbers in a columm (1tru 5 | Excel Worksheet Functions | |||
| Values on 'y' axis - columm chart type | Charts and Charting in Excel | |||
| What is the formula for adding up *values! in a columm in exell | Charts and Charting in Excel | |||
| Columm sums | Excel Discussion (Misc queries) | |||
| (macro, formula,...) To Copy columm in various sheet's | Excel Discussion (Misc queries) | |||
Hybrid Mode
