Limit to number of rows and columns in an Excel spreadsheet

5 pts.
Tags:
Microsoft Excel
What's is the limits to the number of rows and columns that an Excel spreadsheet can have?


Software/Hardware used:
Programming
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

What version of Excel? 

Excel 2003 has a 65536 row limit by 256 columns.

Excel 2007, the maximum worksheet size is 1048576 rows by 16384 columns
Excel 2010, the maximum worksheet size is 1048576 rows by 16384 columns
Excel 2013, the maximum worksheet size is 1048576 rows by 16384 columns

Discuss This Question: 8  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Subhendu Sen
    Yes, it depends on version of excel also. However, just navigate here for more info: https://support.office.com/en-nz/article/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3
    140,480 pointsBadges:
    report
  • rameshbabu73
    You said in the above answer Excel 2013 or 2010 version excel canget 1048576 rows, Could you please let me know why BPC EPM EXCEL add-on cannot accommodate 1048576 rows at a time. It is giving "no more memory error". What is the difference between EPM add on tool and normal Excel?
    10 pointsBadges:
    report
  • ToddN2000
    The "No more memory" error could mean there is not enough RAM in the PC to hold the spreadsheet if it's that large. I get that sometimes when running an data transfer. It all depends on the amount of data in the cells. If the cells had 5 or 6 chars you may get to the max but if the cells contained 30 to 50 chars that is a lot more data. In that case you may not get to the max unless you have 32g of ram. It's all conditional to the data and cell size.
    133,860 pointsBadges:
    report
  • rambo73
    Thank you for quick reply. I too believe it is purely depends on volume of data in the cells. if I need to generate the data with 500K rows data in one go with excel format, what is the best approach. Please suggest.
    60 pointsBadges:
    report
  • rambo73
    But it depends on the cell size of the data and colum numbers. Hence forth the volume of data is restricting the rows in the excel, this is what we experienced. It is not mandatory to show 1048576 rows in one work sheet.
    60 pointsBadges:
    report
  • lathasoma1996
    i need more than 1048576 can you please let me know how to increase the rows
    10 pointsBadges:
    report
  • ToddN2000
    Even with the OpenOffice spreadsheet app it has the same limit. You need to split the data between worksheets. I think over a million on one sheet is a little to hard to work with.
    133,860 pointsBadges:
    report
  • 1dsa562F
    asd
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: