MrExcel Publishing
Your One Stop for Excel Tips & Solutions

256 Max total columns


Posted by Ramon on February 11, 2002 3:45 AM

What I have to do to use more than 256 column in an Excel sheet?


Posted by DK on February 11, 2002 4:24 AM

You can't. The maximum number of columns in 256 and the maximum number of rows is 65536. The Microsoft Office spreadsheet control allows up to 676 columns but it's only a very simple version of Excel.

Regards,
D

Posted by Mark O'Brien on February 11, 2002 7:09 AM

If you've got less than 256 columns, transpose your table. i.e. change the columns to rows and vice versa.

Posted by Jack in the UK on February 11, 2002 11:25 AM

Thabnks D i have been struggling where i saw that, copy from anywhere to try.. JACK [NT]