Want more 256 column in 2007

  • Thread starter Thread starter Bachadega
  • Start date Start date
B

Bachadega

Hi
I have Excel 2007, how can I get more than 256 column in one spreadsheet. I
know that the 2007 version allows up to 16000 columns, so please help.... I
need to insert the data one by one.
 
If you have an .xls file you need to save as a .xlsx or .xlsm and then close
the file. When you re-open you will have full xl2007 functionality.
 
Don Guillett said:
If you have an .xls file you need to save as a .xlsx or .xlsm and then close
the file. When you re-open you will have full xl2007 functionality.
Click to expand...
....

Not as an .xlsb file?
 
Hi Bachadega,

You can only get more than 256 columns if you're working in Excel 2007's native mode - not in the 97-2003 compatability mode.
 
Back
Top