MrExcel.com - Your One Stop for Excel Tips & Solutions

Maximum number of columns

Posted by Al Lebeau on May 10, 2001 8:27 AM

Is is possible to get more than 256 columns in Excel 2000?

Thanks

Posted by Dave Hawley on May 10, 2001 9:21 AM


Hi Al Lebeau

Sorry to say the answer is no! The number is fixed at 256 Columns and 65536 Rows. Basically Excel is set up for data to be entered with Column containing headings and data in rows.

DaveOzGrid Business Applications