iSumsoft » Resources » Office » How to Select Cells Range/Rows/Columns in Excel

How to Select Cells Range/Rows/Columns in Worksheet

Roy Ulerio
Roy Ulerio

Updated:

This is a guide on how to quickly select cells range, rows or columns in Excel worksheet.

This tutorial describes how to select a large range of cells using Shift key, how to select all cells on a worksheet using Select All button, and select entire row or column by using the Name box. These hidden tricks will help you a lot when you edit or modify the data in a worksheet.

How to Select Cells Range, Rows or Columns in a Worksheet

1. Quickly select a large range of cells with Shift key

In a worksheet, click the first cell in the range, and then hold down Shift while you click the last cell in the range.

Select a large range of cells with Shift

2. Quickly select a large range of cells with Name box

Click the first cell in the range to select it, and then click the Name box, type the cell reference of the last cell in the range that you want to be selected. In our example, I'll type B1:H6 into the Name box.

Then press Enter key, and your specified cell range is selected at once.

Select a large range of cells with Name box

3. Select nonadjacent row, columns, cells or cell ranges

Select the first row, cell or range of cells, and then hold down Ctrl while you select the other cells or ranges.

Select nonadjacent cells with Ctrl

4. Quickly select all cells on a worksheet

Way 1: To select the entire worksheet, click the Select All button.

Select all cells on a worksheet

Way 2: Type A:XFD in the Name Box. Hit Enter key, you'll see all cells are selected.

Select entire workbook using Name box

5. Select Entire Rows or Columns in Excel

Option 1: To select entire rows or columns, click on the row or column heading.

Select entire rows or columns in Worksheet

Option 2: To select entire rows, type row number into the Name box, and hit Enter.

Such as, type in 3:3 to select entire row 3, 3:6 to select rows range from 3 to 6.

Select entire rows and rows range

Option 3: To select entire columns, type column alphabets into the Name box.

Such as, type in C:C to select entire column C, when type in C:E, it'll select columns range from C to E.

Select entire columns using Name box

Excel marks selected cells or ranges by highlighting them.