Limitations of Excel

Limitations of Excel For Beginners

In previous article we have discussed about Excel and It's features. Now in this article we will talk about Limitations of MS Excel 2010, which helps us to understand excel better.

As we know excel is a spreadsheet application consist of workbooks, worksheets, columns & Cells so while working on excel we should know how many sheets, cells, column etc. we can have in it. 

Following are limitations of excel:

S. No	Particulars	Maximum limit
1	Open workbooks	Limited by available memory
2	Columns	256 columns
3	Column width	255 characters
4	Rows	65,536 rows
5	Row height	409 points
6	Page breaks	1000 horizontal and vertical
7	Sheets in a workbook	Limited by available memory (default is 3 sheets)
8	Colors in a workbook	56
9	Cell styles in a workbook	4000
10	Names in a workbook	Limited by available memory
11	Windows in a workbook	Limited by system resources
12	Hyperlinks in a worksheet	66,530 hyperlinks
13	Zoom range	10 percent to 400 percent
14	Undo levels	16
15	Fields in a data form	32
16	Number of available worksheet functions	329
17	Earliest date allowed for calculation	January 1, 1900 (January 1, 1904, if 1904 date system is used)
18	Latest date allowed for calculation	31-Dec-99

You can share your feedback and post your excel queries in this blog.