Excel 2007 Column Maximum

  • Thread starter Thread starter Peter C
  • Start date Start date
P

Peter C

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
 
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
 
Thanks - we are sorted.

Peter

Gord Dibben said:
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
Click to expand...
 
Back
Top