Contributed by:
Less Known facts about Microsoft Excel which every user must know.
1.
Microsoft Excel Limitations
2.
Worksheet and workbook specifications and
E4A
Feature Maximum Limit
Open workbooks Limited by available memory and system
resources
Total number of rows and columns on a 1,048,576 rows by 16,384 columns
worksheet
Column width 255 characters
Row height 409 points
Page breaks 1,026 horizontal and vertical
Total number of characters that a cell can contain 32,767 characters
Characters in a header or footer 255
Maximum number of line feeds per cell 253
Sheets in a workbook Limited by available memory (default is 1 sheet)
Colors in a workbook 16 million colors (32 bit with full access to 24 bit
color spectrum)
3.
Worksheet and workbook specifications and
E4A
Feature Maximum Limit
Named views in a workbook Limited by available memory
Unique cell formats/cell styles 65,490
Fill styles 256
Line weight and styles 256
Unique font types 1,024 global fonts available for use; 512 per
workbook
Number formats in a workbook Between 200 and 250, depending on the
language version of Excel that you have installed
Workbook parameters 255 parameters per workbook
Items displayed in filter drop-down lists 10,000
Hyperlinks in a worksheet 65,530
Panes in a window 4
4.
Worksheet and workbook specifications and
E4A
Feature Maximum Limit
Linked sheets Limited by available memory
Scenarios Limited by available memory; a summary report
shows only the first 251 scenarios
Changing cells in a scenario 32
Adjustable cells in Solver 200
Custom functions Limited by available memory
Zoom range 10 percent to 400 percent
Reports Limited by available memory
Sort references 64 in a single sort; unlimited when using
sequential sorts
Undo levels 100
Fields in a data form 32
5.
Calculation Specifications & Limits E4A
Feature Maximum Limit
Number precision 15 digits
Length of formula contents 8,192 characters
Internal length of formula 16,384 bytes
Iterations 32,767
Earliest date allowed for calculation January 1, 1900 (January 1, 1904, if 1904 date
system is used)
Latest date allowed for calculation December 31, 9999
Arguments in a function 255
Nested levels of functions 64
User defined function categories 255
Number of available worksheet functions 341
Cross-worksheet dependency 64,000 worksheets that can refer to other sheets
6.
Pivot Table and Pivot Chart Specifications &
E4A
Feature Maximum Limit
Unique items per field 1,048,576
Report filters in a PivotTable report 256 (may be limited by available memory)
Value fields in a PivotTable report 256
Value fields in a PivotChart report 256
Length of the MDX name for a PivotTable item 32,767
Length for a relational PivotTable string 32,767
Items displayed in filter drop-down lists 10,000
7.
To receive more details, Please follow For Business Inquiries:
us. 8329489690
7875726961
[email protected]
E4A
For Technical Discussions:
9962166117
7020050265
[email protected]
Thank You
For any other Queries:
9049824030
[email protected]
www.Excel4all.in
+1-315-636-4485
+91 98151-74050 
