EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Excel Tips Excel Row Limit
 

Excel Row Limit

Jeevan A Y
Article byJeevan A Y
Madhuri Thakur
Reviewed byMadhuri Thakur

Updated August 16, 2023

Row Limit in Excel

 

 

Row Limit in Excel (Table of Contents)

Row Limit in Excel

Although we have a sufficient number of rows and count in Excel to handle ample data, we still have some limitations in the number of rows in Excel, which is limited to 1048576 rows in Excel 2019 Office 365. Every workbook has limited memory, allowing Excel to function properly without any crashes. We can insert multiple sheets if we still have data exceeding the 1048576-row count.

Hide Rows Which You Don’t Want to Show

This is not strange for you if you are old enough to excel in hiding and unhiding. A similar technique can apply here as well. We rarely use more than 1 lakh rows of data sets. I often don’t want to show unnecessary rows to the users. We can hide both rows and columns in Excel. Follow the below steps to learn this technique.

You can download this Row Limit Excel Template here – Row Limit Excel Template

Step 1: Select the row below where you want to display the number of rows. For example, if I want to display 1 lakh rows, I will select the row after 1 lakh. Reaching after the row of 1 lakh is not that easy. Scrolling till the 1 lakh row is not that easy. Place a cursor on the Name Box.

row excel limit 2

Now type A100001in the Name Box and Hit Enter; it will take you to the row after 1 lakh row.

row excel limit 3

Select this entire row by pressing the shortcut key Shift Space.

row excel limit 4

Step 2: Hold the Keys Shift & Ctrl > Press down Arrow; it will take you to the end of the last row.

row excel limit step 1

Step 3: Right-click on the column header and select the hide option.

row excel limit step 2

Pro Tip: We can press Ctrl + 9, the shortcut key, to hide selected rows.

press Ctrl + 9 step 3.1

Step 4: It will hide all the selected rows and display only 1 lakh rows.

row excel limit step 4

Limit the Scrolling Area

The user can move around in a general spreadsheet anywhere in the worksheet. However, sometimes we need to restrict the user’s access to specific areas.

We can do this by using the VBA coding technique

Step 1: Open the Workbook you want to restrict.

Step 2: Press ALT + F11, the shortcut key, to open the VBA editor. It will show the VBA Editor window.

row excel limit step 4

Step 3: Right-click on the worksheet where you want to restrict the user access. In my case, I am selecting Sheet 1. Right-click and select View Code; it will enable the VBA code space.

View Code step 5

Step 4: Select Sheet 1 and press F4 to open the Sheet Properties window.

row excel limit step 6

Step 5: Find the ScrollArea in this toolbox.

ScrollArea step 7

Type the area (range) in the worksheet to which you want to give them access. I have mentioned A1 to G20 in the below image.

row excel limit step 8

Step 6: Close the VBA Editor window and Save the workbook. Now the user cannot move beyond the selected cells. We have limited the access of rows to the users.

VBA Editor Window

Now test your worksheet. You cannot place your cursor other than the yellow-colored area.

row excel limit step 9

Things to Remember about Row Limit in Excel

  • The shortcut key to hide rows is Ctrl + 9. Use a horizontal number keypad.
  • We can specify any range in the scroll area to limit access.
  • Once the rows are hidden, we can unhide them at any time.
  • In the latest version of Excel, a maximum of 1,048,576 rows by 16,384 columns are available.

Recommended Articles

This has been a guide to Row Limits in Excel. Here we discuss the Row Limit in Excel and how to use Row Limit in Excel, along with practical examples and a downloadable Excel template. You can also go through our other suggested articles –

  1. Add Rows in Excel Shortcut
  2. Autofit Row Height in Excel
  3. ROWS Function in Excel
  4. Excel Freeze Rows

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

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

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

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

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

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

EDUCBA

Download Row Limit Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download Row Limit Excel Template

EDUCBA

डाउनलोड Row Limit Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW