How To Select Multiple Ranges In Excel

I of the advantages of using spreadsheet software like Excel is that you get to perform operations in bulk.

Instead of working on one cell or one row at a time, you get the choice to work with multiple rows (or columns) all at once.

To be able to take advantage of this facility, you should know the right and virtually efficient ways to select the rows you lot desire, and then that you tin work on all of them in one go.

In this tutorial, we will evidence you how you can select multiple rows that are contiguous and those that are not-contiguous too.

• Selecting Multiple Rows that are Face-to-face
  • Selecting Multiple Rows that are Face-to-face past Dragging
  • Selecting Multiple Rows that are Contiguous using the SHIFT Primal
  • Selecting Multiple Rows that are Face-to-face using the Excel Proper name Box
• Selecting Multiple Rows that are Not Contiguous

Selecting Multiple Rows that are Contiguous

If the rows you want to select announced one below the other, then the procedure is quite simple. Y'all can use one of the following methods.

Selecting Multiple Rows that are Face-to-face by Dragging

The offset method is quite easy and quick since yous don't need to enhance your finger from the mouse button and can select multiple rows with a single swift motility of your mouse.

Hither the steps to select multiple contiguous rows by dragging:

1. Select the row header of the kickoff row in your selected range.
2. With the left mouse button nonetheless pressed, drag downward the row headers till you reach the concluding row in your selected range.
3. Release your left mouse button.

All the rows in your selection range should now get selected.

Selecting Multiple Rows that are Contiguous using the SHIFT Central

The start method, though easy, tin exist a little inconvenient if yous want to select rows that span over multiple screen scrolls.

In such cases, the 2d method can be useful. Here the steps to select multiple face-to-face rows using the SHIFT fundamental:

1. Select the row header of the first row in your selected range.
2. Press downwardly the SHIFT key on your keyboard (if you're on a Mac, and so printing downwards on the CMD primal).
3. While the SHIFT key is pressed, select the last row of the range that you want to select.
4. Release the SHIFT cardinal.

All the rows in your selection range should now go selected.

Note: Any subconscious rows in your selected range do non get selected by this method.

Selecting Multiple Rows that are Face-to-face using the Excel Name Box

Excel provides a convenient Proper noun Box to help you quickly select cells using their cell references.

The Name Box appears in the grade of an input box located at the top left of the Excel window, straight below the menu ribbon.

In general, the Proper name box typically displays the address of the active cell or cells in the worksheet.

However, you can also apply information technology for many other purposes. For example, you can utilise it to name a cell or range of cells or navigate to a cell or range of cells.

To select multiple face-to-face rows using the Name box, you tin follow the steps beneath:

1. Click inside the Proper name Box.
2. Type a reference to the range of cells you want to select, for case, ii:half dozen if you want to select the row numbers 2 to 6.
3. Printing the return cardinal.

This will select all the rows in the range that you typed in.

Selecting Multiple Rows that are Not Contiguous

If the rows you desire to select practise non appear i below the other or are not-face-to-face, you tin can employ the CTRL cardinal of your keyboard. Here's how you lot can select your required non-contiguous rows using the CTRL key:

1. Select the row header of the first row that you lot want to select.
2. Printing down the CTRL cardinal of your keyboard.
3. While the CTRL key is pressed, select row headers of subsequent rows that you want to select one by ane.
4. Once y'all're done selecting all your required rows, yous can release the CTRL-key.

In this tutorial, we showed yous iii means in which you tin can select multiple rows in Excel that are contiguous and one fashion to select multiple rows that are non-contiguous.

All methods demonstrated are simple and quick, and so we hope you found the tutorial like shooting fish in a barrel to follow.

Other Excel tutorials you lot may also like:

• How to Select Alternate Columns in Excel (or every Nth Column)
• How to Select Every Other Cell in Excel (Or Every Nth Prison cell)
• How to Hibernate Rows based on Cell Value in Excel
• How to Select Rows with Specific Text in Excel

Source: https://spreadsheetplanet.com/select-multiple-rows-excel/

Posted by: ballardmationsills.blogspot.com

Share this post