How to Select Large Data in Excel Without Dragging (5 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

Excel is extremely powerful for handling large datasets. Generally, we need to drag the dataset cells to select the dataset altogether. Now, it might get tiring and time-consuming to drag and select large datasets. In this article, I will show you 5 quick and easy ways to select large data in Excel without dragging.


Download Practice Workbook

You can download our practice workbook from here for free!


5 Ways to Select Large Data in Excel Without Dragging

Say, we have a dataset containing 5 employeesโ€™ names, sales, salaries, working hours, and nationality. Now, we want to select the entire dataset without dragging. You can follow any of the given ways to do this.

Sample Dataset to Select Large Data in Excel Without Dragging

In this article, we have used the Office 365 version of Microsoft Excel. But, no worries! You can use all of the ways to any version of Excel that is available to you. If you encounter any problems regarding Excel versions, please feel free to comment below.


1. Using Shift Key

The quickest way to select a large dataset without dragging is to use the Shift key of your keyboard. Follow the steps below to achieve your desired result in this way.

๐Ÿ“Œ Steps:

  • First and foremost, select the first cell of your dataset (B5 here).

Select the B5 Cell

  • Afterward, press and hold the Shift key of your keyboard.
  • Subsequently, click on the last cell of your dataset (F9 here)

Using the Shift Key to Select Your Data in Excel Without Dragging

Consequently, the whole dataset will be selected without dragging. For example, the selection would look like this.

Selected Large Data n Excel Without Dragging

Read More: How to Select Cells in Excel Without Dragging (7 Ideal Examples)


2. Combining Ctrl and Shift Key

Another easy way to select large data without dragging is to combine the Ctrl and Shift keys of your keyboard. Go through the steps below to do this.

๐Ÿ“Œ Steps:

  • At the very beginning, select the first data of your dataset (B5 here).
  • Subsequently, press and hold Ctrl + Shift.
  • Following, press the right arrow key of your keyboard to select the data to the right.

Combine Ctrl and Shift Key to Select Large Data in Excel Without Formatting

  • As a result, all the data in the first row are selected.
  • Afterward, holding Ctrl + Shift, press the down arrow key.

Combine Ctrl, Shift and Down Arrow Key

As a result, the entire dataset is selected without dragging. And, the outcome after selection would look like this.

Selected Large Data in Excel Without Dragging

Note:

  • You could also select the rows first by pressing the down arrow and then the columns by pressing the right arrow.
  • Holding only the shift key will allow you to select only the next row rather than going to the last row before a blank cell.

Read More: [Solved!] CTRL+END Shortcut Key Goes Too Far in Excel (6 Fixes)


3. Using Name Box Command

Another tricky way to select large data without dragging is to use the Name Box. Follow the steps below to accomplish this.

๐Ÿ“Œ Steps:

  • First, click on the first cell of your data (B5 here).
  • Subsequently, go to the Name Box and write your dataset range (B5:F9 here).
  • Following, hit the Enter button.

Using Name Box to Select Large Data in Excel Without Dragging

Thus, you can select all the data in Excel without dragging. And, the selection would look like this.

Selected Large Data

Read More: How to Select Cells in Excel Using Keyboard (9 Ways)


Similar Readings


4. Using Go To Command

Besides, you can also use the Go To Dialogue Box of Excel to select large data without dragging. Follow the steps below to accomplish your target using this way.

๐Ÿ“Œ Steps:

  • Initially, select the first cell of your data (B5 here).
  • Subsequently, press the F5 key on your keyboard.

Access the Go To Dialogue Box

  • As a result, the Go To window will appear.
  • Now, at the Reference: text box, write the last cell position of your dataset (F9 here).
  • Afterward, hold the Shift key and click on the OK button.

Using Go To Dialogue Box to Select Large Data in Excel Without Dragging

As a result, you can select the data without dragging and the outcome should look like the following.

Selected Large Data

Read More: How to Go to Last Non Empty Cell in Column in Excel


5. Using Ctrl Key to Select Multiple Rows/Columns

In addition to all these, you can also select multiple rows and columns using the row/column letters. Go through the steps below to achieve this.

๐Ÿ“Œ Steps:

  • First, click on any row number that you want to select (5 here).

Click on the Number 5

  • As a result, the entire 5th row is selected.
  • Afterward, for selecting multiple rows, hold the Shift key and press the down arrow.

Using Shift Key to Select Multiple Rows

  • As a result, you can select multiple rows.

Selected Multiple Rows

  • Again, if you want to select columns, select the column that you want to select (B here).

Click on Column Header Letter

  • As a result, the entire B column is selected.
  • Now, for selecting multiple columns, hold the Shift key and press the right arrow.

Using Shift Key to Select Multiple Columns

  • Consequently, you can select multiple columns.

Selected Multiple Columns

Note:

  • For selecting rows, you can also press Shift + Space rather than clicking on the row header number.
  • For selecting columns, you can also press Ctrl + Space rather than clicking on the column letter.

Read More: How to Select Multiple Columns in Excel for Graph (3 Methods)


๐Ÿ’ฌ Note

Holding the Ctrl key and selecting some cells will enable you to deselect specific cells from a selection.


Conclusion

In a nutshell, in this article, I have shown you 5 easy ways to select large data in Excel without dragging. I suggest you read the full article carefully and practice accordingly. I hope you find this article helpful and informative. You are very welcome to comment here if you have any further questions or recommendations.

And, visit ExcelDemy to learn about many more Excel problem solutions, tips, and tricks. Thank you!


Related Articles

Tanjim Reza

Tanjim Reza

Hello! I am Md. Tanjim Reza Tanim. I have just completed my B.Sc from Naval Architecture & Marine Engineering Department, BUET. Currently, I am working as an Excel & VBA content developer. I always had a great fascination with Microsoft Excel and its cool functions and formulas. Here, I am learning every day about new functions and formulas and working on applying MS Excel to the analysis of our real-life problems. I have great enthusiasm for learning any kind of new things, writing articles, and solving real-life problems.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo