Archive of Mr Excel Message Board

Back to General Excel archive index
Back to archive home

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?

Re: 256 Max total columns

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

Re: 256 Max total columns

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.

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

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.