The Maximum Number of Rows in a Microsoft Excel Sheet

Have you tried to find the exact number of rows in a Microsoft Excel sheet but found it difficult to scroll down since it appeared to you it was an infinite process?

There is a quick way to know the exact number of rows in a new Microsoft Excel sheet:

1. Open Microsoft Excel.

2. Select all the cells in the sheet by either using the shortcut (Ctrl + A) or by clicking on the small rectangle between Column A and Row 1:

Microsoft Excel 2003: Selecting All Cells

3. Right-click on that rectangle and you should see the following menu:

Microsoft Excel 2003: Finding The Maximum Number Of Rows 1

4. Click on Create List…:

Microsoft Excel 2003: Finding The Maximum Number Of Rows 2

You will see the following command window:

Microsoft Excel 2003: Finding The Maximum Number Of Rows 3

Can you see what is written in the text box? It is written “=$1:65536”. It means “Select the range from Row 1 to Row 65536”.

5. Click OK.

6. Go to the end of the sheet using the vertical scroll bar. Easy now, is not it? What is the number of the last row you see?

Microsoft Excel 2003: Finding The Maximum Number Of Rows 4

7. Try to insert a new row by clicking on Row 65536, right-clicking on it, and then click on Insert:

Microsoft Excel 2003: Finding The Maximum Number Of Rows 5

You cannot! Insert is dimmed which means it is impossible to add another row.

There is a quicker way to go to the last row! Hold the scroll bar and move down swiftly:

Microsoft Excel 2003: Scrolling Down

So, the maximum number of rows in a Microsoft Excel sheet is 65536. Why this particular number of rows? I have no idea.

Advertisements

Tags: , , ,


%d bloggers like this: