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

You are watching: Which is the correct process for selecting consecutive worksheets

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.


Table of Contents


Selecting Multiple Rows that are Contiguous

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:

Select the row header of the first row in your selected range.
*
*
*
*
*
*

In this tutorial, we showed you three ways in which you can select multiple rows in Excel that are contiguous and one way to select multiple rows that are non-contiguous.

See more: What Is A Substitute For Alum Substitutes? (Answered) What Can Be Used Instead Of Alum

All methods demonstrated are simple and quick, so we hope you found the tutorial easy to follow.