Microsoft Office Tutorials and References
In Depth Information
Why Are There Only 65,536 Rows in My Excel 2013 Spreadsheet?
As of Excel 2007, the new grid size is 1,048,576 rows by 16,384
columns. This means 17.1 billion cells, which is a 102,300% increase
over the previous limit.
Why Are There Only 65,536 Rows in My Excel 2013 Spreadsheet?
When you initially install Excel 2013 and open one of your large workbooks,
you might be disappointed to find only 65,536 rows in the worksheet (see Figure
7.1 ) . When this occurs, it means you are in Compatibility mode. Any time that
you open an .xls format file, you are limited to the 65,536 rows that were
available in legacy versions of Excel. If you see 65,536 rows, look in the
title bar and you will see that you are in Compatibility mode.
Figure 7.1.
Figure 7.1. What is all the hype? There are still only 65,536 rows.
What is all the hype? There are still only 65,536 rows.
To leave Compatibility mode, select File and then select Convert, as shown
in Figure 7.2 . Excel tells you that the old file will be deleted and replaced by
a new file. After the file conversion is done, Excel offers to close and reopen
the file so that you are no longer in Compatibility mode.
Search JabSto ::




Custom Search