How to Select Multiple Columns & Rows in Excel | Excel Tips

One 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 option 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 most efficient ways to select the rows you want, so that you can work on all of them in one go.

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

Selecting Multiple Rows that are Contiguous
If the rows you want to select appear one below the other, then the process is quite simple. You can use one of the following methods.

Selecting Multiple Rows that are Contiguous by Dragging
The first method is quite easy and quick since you don’t need to raise your finger from the mouse button and can select multiple rows with a single swift movement of your mouse.

Here the steps to select multiple contiguous rows by dragging:

1. Press Control+G
2. Type Coloum Name And Cell Range (F100)
3. Hold Shift key And Press Enter