Solved

Excel Limitation

Posted on 2016-11-09
2
49 Views
Last Modified: 2016-11-09
Is there any one how many columns and how may rows we can have in each worksheet?
And how many worksheets allows per workbook?
0
Comment
Question by:tommym121
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 47

Expert Comment

by:Martin Liss
ID: 41880656
What version of Excel are you using? It's different by version.
0
 
LVL 35

Accepted Solution

by:
[ fanpages ] earned 500 total points
ID: 41880710
[ 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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This article describes a serious pitfall that can happen when deleting shapes using VBA.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question