Excel4Business - Our Blog

Excel Tips and Tricks from our Experts

Excel Help - How to Select Cells in Excel 2013

This video provides a brief overview of different ways to select cells and cell ranges in Excel.

To select a single cell, click on it. You can also find the cell by pressing the arrow keys.

To select a range of cells, click the first cell in the range and then drag the cursor to the last cell. You can also press and hold the Shift key while you move with the arrow keys to select more cells.

If you’re dealing with a long range of cells, click on the first cell in the range, then press and hold down the Shift key while you find and click on the last cell in the range.

To select all the cells in a worksheet, press Ctrl+A or click the Select All button (the triangle at the top left-hand corner of the worksheet).

If the cells you want to select are not next to each other, select the first cell or cell range, press and hold the Ctrl key and select the next cell or cell range.

To select an entire row or column, click on the column or row heading. For columns, this is the letter at the top, and for rows, it’s the number on the left.