| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Max # of Columns
Hello
What is the max # of columns in excel by default? Is there a way to increase the # of columns Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Max # of Columns
You cannot increase the number of columns. It is fixed at 256 (XL2003
and earlier) or about 18K (XL2007 and later). Cordially, Chip Pearson Microsoft MVP 1998 - 2010 Pearson Software Consulting, LLC www.cpearson.com [email on web site] On Thu, 10 Dec 2009 14:50:01 -0800, Sancho wrote: Hello What is the max # of columns in excel by default? Is there a way to increase the # of columns Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Max # of Columns
In Excel 2003, the maximum is 256 columns. In Excel 2007, the maximum is
16,384 columns. AFAIK there is no way to go beyond these limits. Hope this helps, Hutch "Sancho" wrote: Hello What is the max # of columns in excel by default? Is there a way to increase the # of columns Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| putting 2 long columns into multiple columns in excel page and sor | Excel Discussion (Misc queries) | |||
| to convert columns to rows having mulit independent group columns | Excel Worksheet Functions | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) | |||
Hybrid Mode
