| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Excel 2007 Column Maximum
How do I change Excel 2007 so I can use more than the 256 columns that are
currently displayed as default. I realise that in the 2007 version the maximum columns is controlled by memory of which I have heaps. Thanks Peter |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Excel 2007 Column Maximum
The maximum number of columns is 16,384 and is not controlled by memory as you
state. If you are opening older version workbooks directly into 2007 you will see the 256 column limit. Save the workbook as 2007 then re-open should do the trick Gord Dibben MS Excel MVP On Sat, 26 Apr 2008 17:15:00 -0700, Peter C wrote: How do I change Excel 2007 so I can use more than the 256 columns that are currently displayed as default. I realise that in the 2007 version the maximum columns is controlled by memory of which I have heaps. Thanks Peter |
|
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Excel 2007 Column Maximum
Thanks - we are sorted.
Peter "Gord Dibben" wrote: The maximum number of columns is 16,384 and is not controlled by memory as you state. If you are opening older version workbooks directly into 2007 you will see the 256 column limit. Save the workbook as 2007 then re-open should do the trick Gord Dibben MS Excel MVP On Sat, 26 Apr 2008 17:15:00 -0700, Peter C wrote: How do I change Excel 2007 so I can use more than the 256 columns that are currently displayed as default. I realise that in the 2007 version the maximum columns is controlled by memory of which I have heaps. Thanks Peter |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| maximum number of rows in Excel 2007 | Excel Discussion (Misc queries) | |||
| Maximum number of data series possible in excel 2007 | Charts and Charting in Excel | |||
| maximum memory for Excel 2007? | Excel Discussion (Misc queries) | |||
| How do I view the maximum rows in Excel 2007 (Million Rows)? | Excel Discussion (Misc queries) | |||
| excel should let me set row amd column maximum sizes | Excel Discussion (Misc queries) | |||
Linear Mode
