Maximum columns/rows in Excel

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. .

Slack Space 1613 This topic was started by ,



data/avatar/default/avatar06.webp

31 Posts
Location -
Joined 2001-07-10
#56674
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.

Custom Resolution/Refresh Rates?

Upgraded Win98SE to Win2k

Participate on our website and join the conversation

You have already an account on our website? Use the link below to login.
Login
Create a new user account. Registration is free and takes only a few seconds.
Register
This topic is archived. New comments cannot be posted and votes cannot be cast.
Responses to this topic


data/avatar/default/avatar27.webp

1117 Posts
Location -
Joined 2000-01-23
#56675
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...
0 0



data/avatar/default/avatar33.webp

30 Posts
Location -
Joined 2000-01-29
#56676
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.
0 0

Windows

Linux

macOS

Community

  • dhamu
    Hello Phil, I have a Linux Tutorial website that curre ...
  • StephanX
    Hi friends, i am new in the Linux universe but i try to ...
  • Philipp
    I would try the XanMod kernel: https://xanmod.org  I ...