Solved

Excel Limitation

Posted on 2016-11-09
2
44 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
2 Comments
 
LVL 46

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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

830 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