Excel Limitation

Is there any one how many columns and how may rows we can have in each worksheet?
And how many worksheets allows per workbook?
tommym121Asked:
Who is Participating?
 
[ fanpages ]Connect With a Mentor IT Services ConsultantCommented:
[ https://support.office.com/en-gb/article/Excel-specifications-and-limits-ca36e2dc-1f09-4620-b726-67c00b05040f ]

Excel specifications and limits
Applies To: Excel 2016 Excel 2013
---
Worksheet size... 1,048,576 rows by 16,384 columns
Sheets in a workbook... Limited by available memory (default is 1 sheet)
---

[ https://support.office.com/en-us/article/Excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3 ]

Excel specifications and limits
Applies To: Excel 2010
---
Worksheet size... 1,048,576 rows by 16,384 columns
Sheets in a workbook... Limited by available memory (default is 3 sheets)
---

[ https://support.office.com/en-gb/article/Excel-specifications-and-limits-16c69c74-3d6a-4aaf-ba35-e6eb276e8eaa ]

Excel specifications and limits
Applies To: Excel 2007
---
Worksheet size... 1,048,576 rows by 16,384 columns
Sheets in a workbook... Limited by available memory (default is 3 sheets)
---


Also:

Excel specifications and limits
Applies To: Excel 2003
---
Worksheet size... 65,536 rows by 256 columns
Sheets in a workbook... Limited by available memory (default is 3 sheets)
---
0
 
Martin LissOlder than dirtCommented:
What version of Excel are you using? It's different by version.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.