Compatible Support Forums: Maximum columns/rows in Excel

Page 1 of 1

You cannot start a new topic
You cannot reply to this topic

Maximum columns/rows in Excel

#1 JohnnyChangs

newbie

Group: Members
Posts: 31
Joined: 10-July 01

Posted 30 July 2001 - 06:00 PM

Does anyone know the maximum amount of rows and columns you can have in a Microsoft Excel spreadsheet?

I think its unlimited, but not exactly sure.

#2 CUViper

old hand

Group: Members
Posts: 1120
Joined: 23-January 00

Posted 30 July 2001 - 08:41 PM

open a new spreadsheet, press ctrl-down, then ctrl-right. That will put you at the absolute botton right of the sheet. It's not unlimited, but it's pretty big...

#3 Sweevo

newbie

Group: Members
Posts: 29
Joined: 29-January 00

Posted 31 July 2001 - 10:14 AM

It depends on which version of Excel but if it's Excel 97 or above then you'll get 65,536 rows and 256 columns per worksheet with a maximum of 255 worksheets in a workbook.

If it's an earlier version(e.g. Excel 95) then you'll only get 16,384 rows but the other stats remain unchanged.