WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Maximum Number of Rows in Excel

Maximum Number of Rows in Excel

By Jeevan A YJeevan A Y | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

How to Find the Maximum Number of Rows in Excel?

For example, look at the below worksheet preview.

Maximum number of rows 1

As of now, the active cell is A1 cell; to go to the last row of this column, we need to simply press the shortcut key “Ctrl + Down Arrow” this will take you to the last row in the selected cell column.

ctrl and down arrow

Maximum number of rows (last)

But one thing you need to know about this shortcut is it will take you to the last used cell without a cell break.

For example, look at the below data preview.

Example 1

In this case, we have some sort of data in the first 6 rows of column 1, and the active cell is the A1 cell. If you press Ctrl + Down Arrow, it will take you to the last used cell, not to the last row of the worksheet.

Example 1-1

This shortcut key will go to the last used cell without any cell breaks. For example, look at the below data preview.

Maximum number of rows Example 1-2

After the first 6 rows, we have a line break of one row, and after that cell break, we have data in another 6 rows. First, I will press the shortcut key Ctrl + Down Arrow, and it will take me to the last used row before the cell break, i.e., 6th row.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Example 1-3

Now again, I will press the shortcut key Ctrl + Down Arrow and see where it will go.

Maximum number of rows Example 1-4

Upon pressing the shortcut key one more time, it has jumped to the next used cell, not to the end of the last used cell. Now press Ctrl + Down Arrow, and it will take you to another last used row, i.e., 13th row.

Maximum number of rows Example 1-5

Now, if you press Ctrl + Down arrow, it will take you to the last row of the worksheet. Like this going to the maximum number of rows with excel works.

Limit User Action to Specific Number of Rows in Excel

Often time, we don’t want users to use all the rows; rather, we want them to work with a specific range of cells or rows. This can be done by using multiple methods; below are the methods to restrict user action to specific rows.

Using Hide Method

For example, if you want to allow a user to work with the first ten rows of the data, then we can hide the remaining rows except for the first 10 rows.

  • To hide from the 11th row onwards, select all the rows till the 10,48,576 row.

Maximum number of rows Example 2

  • Now right-click on the row header and choose the option of “Hide.”

Maximum number of rows Example 2-1

  • This will hide all the selected rows, and the user can see only 10 rows.

Maximum number of rows Example 2-2

If you don’t want to follow the manual method of right-clicking and hide, then you can use shortcut keys to hide rows.

After selecting a number of rows to be hidden, simply press the shortcut key “Ctrl + 9”. (Number 9 should be from the keyboard number, not from the number pad of the keyboard). It will simply hide the rows.

Like this, we can limit the action of users with specific worksheets.

Things to Remember

  • Excel 2003 version has only 65536 rows only.
  • From Excel 2007 version onwards, we have more than 1 million rows.
  • If you are going to use all the rows, then your computer should be equipped with a well-versed processor, and RAM capacity should be not less than 8 GB.

Recommended Articles

This has been a guide to the Maximum Number of Rows in Excel. Here we discuss how to find the last row and restrict user action to specific rows in excel and a downloadable template. You may learn more about excel from the following articles –

  • Max Formula in Excel
  • Count Number of Excel Rows & Columns
  • MINVERSE in Excel
  • Rows Function in Excel
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

Special Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More