How Do I Quickly Select Thousands of Rows in Excel (2 Ways)

When making our Excel spreadsheets, sometimes we may be working with multiple rows to create different sorts of data sets for various calculations. Sometimes, we need to select all the rows for copying our data set to transfer it to another worksheet. Now, doing this manually is very easy when you have small sets of data. In this article, we will show you how to quickly select thousands of rows in Excel.


Download Practice Workbook

You may download the following Excel workbook for better understanding and practice it by yourself.


2 Handy Approaches to Quickly Select Thousands of Rows in Excel

It’s possible that you’ll be working with an excessively large quantity of data when creating your Excel spreadsheets. I encounter this quite frequently, but if you’re experiencing it too, you should be able to navigate and choose among a sizable amount of data without resorting to extremely difficult methods. Here, you will learn to quickly select thousands of rows with very fast techniques by using Name Box and applying VBA code. Let’s suppose we have a sample data set.

Handy Approaches to How Do I Quickly Select Thousands of Rows in Excel


1. Using Name Box to Quickly Select Thousands of Rows

The spreadsheet cell that is presently chosen in Microsoft Excel is shown in the Name Box. The formula bar’s left side is where you can find it. The Name Box displays the name of the selected cell if a name has been defined for it. Here, I will show you how to quickly select thousands of rows in Excel.

Step 1:

  • Here, you can see the Name Box at the left of the Formula bar.
  • First, write down the desired range of cells you would like to select.
  • Now, I will select the cell range from B4 to E1000.
  • Then, click ENTER.

 Using Name Box to Quickly Select Thousands of Rows in Excel

Step 2:

  • Finally, you will observe the below image of thousands of rows selected.
  • Here, I will show some of the rows below.

Step 3:

  • Here you will show all the thousands of rows selected.

Read More: How to Select All Rows in Excel (6 Easy Ways)


Similar Readings


2. Applying VBA Code to Quickly Select Thousands of Rows

VBA is a programming language that may be used for a variety of tasks, and different types of users can use it for those tasks. Using the Alt + F11 keyboard shortcut, you can launch the VBA editor. In the last section, we will generate a VBA code that makes it very easy to quickly select thousands of rows in Excel.

Step 1:

  • Firstly, we will open the Developer tab.
  • Then, we will select the Visual Basic command.

Applying VBA Code to Quickly Select Thousands of Rows in Excel

Step 2:

  • Here, the Visual Basic window will open.
  • After that, from the Insert option, we will choose the new Module to write a VBA code.

Step 3:

  • Now, paste the following VBA code into the Module.
  • To run the program, click the “Run” button or press F5.
Sub Select_Thousands_Rows()
'Selecting the range
Range(Range("B4"), Range("E1000").Offset(1000, 0)).Select
End Sub

VBA Code Breakdown 

  • Firstly, we specify a name for the subject as
Select_Thousands_Rows()
  • Secondly, I select the range of cells using this statement as
Range(Range("B4"), Range("E1000").Offset(1000, 0)).Select
  • Finally, we end the function procedure of the VBA program as
End Sub

Step 4:

  • Last but not least, you will see the image below with thousands of rows selected.
  • Now, I’ll display a few of the rows below here.

Step 5:

  • Lastly, you may see all the thousands of rows that have been selected here.

Read More: Excel VBA to Protect Sheet but Allow to Select Locked Cells (2 Examples)


Conclusion

In this article, we’ve covered 2 handy methods of how I quickly select thousands of rows in Excel. I sincerely hope you enjoyed and learned a lot from this article. Additionally, if you want to read more articles on Excel, you may visit our website, Exceldemy. If you have any questions, comments, or recommendations, kindly leave them in the comment section below.


Related Articles

Bishawajit Chakraborty

Bishawajit Chakraborty

I'm Bishawajit Chakraborty. Hello. I graduated from Rajshahi University of Engineering & Technology (RUET) with a degree in Mechanical Engineering. I'm working with ExcelDemy as a Content Developer for Excel & VBA. You can visit our website, Exceldemy if you'd like to read my published articles on MS Excel and VBA.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo