Helpdesk Baruch College

How to Easily Select a Block of Cells in Excel

There are numerous various techniques for selecting a block of cells in Excel, or extending an existing choice with more cells. Let’s have a look at them.

Select a Range of Cells By Clicking and Dragging

One of the most convenient ways to choose a variety of cells is by clicking and dragging across the workbook.

Click the first cell you want to choose and continue holding down your mouse button.

Drag your guideline over all the cells you want in the choice, and after that release your mouse button.

You ought to now have a group of cells selected.

Select a Large Range of Cells With the Shift Key

In some cases, clicking and dragging isn’t hassle-free because the series of cells you want to select extends off your screen. You can select a range of cells using your Shift secret, much the same method you ‘d select a group of files in a file folder.

Click the first cell in the variety you want to pick.

Scroll your sheet till you find the last cell in the variety you want to pick. Hold down your Shift secret, and after that click that cell.

All the cells in the variety are now picked.

Select (or Deselect) Independent Cells Outside a Range With the Ctrl Key

You can also pick numerous cells that are not linked to one another by using your Ctrl secret.

Click the very first cell you wish to pick.

Now, hold down the Ctrl secret and click to choose additional cells. In the image listed below, we’ve selected five different cells.

You can also use your Ctrl secret to deselect a currently picked cell– even from a choice variety. In the image below, we deselected several cells from a series of cells we ‘d currently picked just by holding down the Ctrl secret while clicking the cells.

Select a Range of Cells Using the Name Box

If you know the precise range of cells you wish to pick, using the name box is a beneficial method to make the selection with no clicking or dragging.

Click the name box in the top left of the workbook.

Enter the range of cells you want to choose using the following format:

Here, we’re picking all the cells from cell B2 (our top left cell) to F50 (our bottom best cell).

Struck Enter (or Return on Mac), and the cells you input are picked.

Select an Entire Row of Cells

You might need to select an entire row of cells at one time– perhaps to use format a header row. It’s simple to do this.

Simply click the row number at the left hand side of the row.

The whole row is now chosen.

Select Multiple Entire Rows of Cells.

In some cases, you may wish to choose multiple entire rows cells. Much like with selecting specific cells, you’ll utilize the Shift secret if the rows are contiguous (or you can click and drag) and the Ctrl key if the rows are noncontiguous.

To pick a contiguous set of rows, click the row number of the very first row.

Continuing to hold down your mouse button, drag your cursor throughout all the rows you want to choose. Or, if you prefer, you can hold down your Shift key and click the bottom-most row you wish to choose. In either case, you’ll pick a range of rows.

To pick noncontiguous rows, click the row number of a row you wish to select.

Then hold down your Ctrl secret while clicking the row varieties of extra rows you want to contribute to the choice. In the image below, we’ve chosen several rows that are noncontiguous.

And, just like with private cells, you can also use the Ctrl key to deselect rows from a selected range. In the image below, we’ve deselected 2 rows from a selected variety by holding down the Ctrl secret while clicking the row varieties of the rows we didn’t want in the choice.

Select One or More Entire Columns of Cells

In some cases, you may want to choose an entire column of cells. It’s easy to do this, too. In fact, it works precisely like picking rows.

Click a column letter to choose the column.

You can also select several columns by clicking and dragging or by utilizing the Shift key, similar to with rows. The Ctrl key likewise works for selecting noncontiguous columns or for deselecting columns from a selected range.

Exit mobile version
Skip to toolbar