Limitations and Boundaries of MS Excel
1. Worksheet size: 65,536 rows by 256 columns
2. Column width: 0 to 255 charcter
3. Row height: 0 to 409 points
4. Length of cell contents: 32,767 characters, only 1024 display in a cell, all 32767 display in formula bar
5. Sheets in a workbook: limited by available memory (default sheets 3)
6. Color in a workbook: 56
7. Cell styles in a workbook: 4000
8. Pane in a window: 4
9. Scenarios: limited by available memory, summary report shows only the first 251 scenarios
10. Changing cells in scenario: 32
11. Adjustable cells in Solver: 200
12. Zoom range: 10% to 400%
13. Sort references 3 in a single sort, unlimited when using sequential sorts
14. Undo level: 16
15. Fields in a data form: 32
Calculation specification features:
16. Number precision: 15 digits
17. Length of formula contents: 1024 characters
18. Iterations: 32767
19. Selected ranges: 2048
20. Arguments in a function: 30
21. Number of available worksheet: 329
22. Function
23. Latest data allowed for calculation: Dec 31, 9999
24. Largest amount of time that can be entered: 9999:99:99
7 Responses to “Limitations and Boundaries of MS Excel”
portable gas grills on September 23, 2010
These are great articles. Keep up the good work.
John Avina, Energy Consultant on September 23, 2010
65,526 is such an odd (even) number. Where does that come from?
Suresh Khanal
Twitter: icttrends
on September 28, 2010
Sorry guys! brain slip, it is 65,536. Thanks for pointing out silly mistake.
Phil@Excel Tutorial Online on January 12, 2011
well, 65,536 is the 16th power to the number 2. I assume that has something to do with the programming of excel and the capabilities of of processors the time Excel 2003 was released.
by the way, cool post, Suresh
jonathan on September 27, 2010
Hi! Some great and funny facts there, but wasn't the 65526 row maximum rule increased by a lot in office 2007?
Suresh Khanal
Twitter: icttrends
on September 28, 2010
yes, but the limitations here is mentioned for computer operator exam preparation. The course syllabus is still following 2003 in our part of world!
hellofareed786@gmail.com on July 16, 2011
Please keep it in Pdf files Because it is good for printing