Excel shortcuts

25 Excel Shortcuts for Selecting Cells and Ranges

If you work with Excel on a daily basis, you know how important it is to be able to select cells and ranges quickly and efficiently. While you can always use your mouse to select cells and ranges, doing so can be time-consuming and frustrating, especially if you're working with a large worksheet. Fortunately, there are a number of keyboard shortcuts that you can use to quickly select cells and ranges in Excel.

In this article, we'll share 25 of the best Excel shortcuts for selecting cells and ranges. By memorizing just a few of these shortcuts, you can save yourself a lot of time and frustration when working with your Excel spreadsheets.

1. Select the Entire Worksheet

If you want to select the entire worksheet, simply press Ctrl+A on your keyboard. This shortcut will select all cells in the worksheet, including cells that don't contain data. If you only want to select cells that contain data, use the Ctrl+Shift+End shortcut instead.

2. Select the Entire Column

To quickly select an entire column, simply click on the column header. For example, if you want to select column A, simply click on the "A" column header. You can also use the Ctrl+Spacebar shortcut to select an entire column.

3. Select the Entire Row

To quickly select an entire row, simply click on the row header. For example, if you want to select row 1, simply click on the "1" row header. You can also use the Shift+Spacebar shortcut to select an entire row.

4. Select a Cell

To select a single cell, simply click on the cell. You can also use the Shift+Arrow keys to select a cell. For example, if you want to select cell B2, you can press Shift+Down arrow twice and then press Shift+Right arrow once.

5. Select a Range of Cells

To select a range of cells, simply click on the first cell in the range and then drag your mouse to the last cell in the range. You can also use the Shift+Arrow keys to select a range of cells. For example, if you want to select cells B2:B5, you can press Shift+Down arrow three times and then press Shift+Right arrow once.

6. Select a Column or Row

To quickly select an entire column or row, simply click on the column or row header and then drag your mouse to the last column or row in the range. You can also use the Shift+Arrow keys to select a column or row. For example, if you want to select columns B:D, you can press Shift+Right arrow twice.

7. Select Non-Adjacent Cells or Ranges

To select non-adjacent cells or ranges, simply hold down the Ctrl key while you click on the cells or ranges that you want to select. For example, if you want to select cells B2, D4, and F6, you would hold down the Ctrl key and click on each of those cells.

8. Select the Current Region

The "current region" is the range of cells that surround the active cell. To select the current region, simply press Ctrl+A. For example, if the active cell is B2, the current region would be the range B2:D5.

9. Select the Entire Table

If your worksheet contains data in an Excel table, you can use the Ctrl+A shortcut to select the entire table. This shortcut will select all cells in the table, including the header row and any empty cells.

10. Select Visible Cells Only

If you've filtered your data, you can use the Ctrl+Shift+A shortcut to select only the visible cells. This shortcut is especially useful if you want to copy or delete only the visible cells.

11. Extend the Selection

If you want to extend the selection to the next cell, simply press the F8 key. For example, if you have cells B2:B5 selected and you press the F8 key, the selection will be extended to cell B6. You can keep pressing the F8 key to extend the selection to the next cell.

12. Shrink the Selection

If you want to shrink the selection to the previous cell, simply press the Shift+F8 key. For example, if you have cells B2:B6 selected and you press the Shift+F8 key, the selection will be shrunk to cell B5. You can keep pressing the Shift+F8 key to shrink the selection to the previous cell.

13. Select the Entire Column Containing the Active Cell

If you want to quickly select the entire column containing the active cell, simply press the Ctrl+Spacebar shortcut. For example, if the active cell is B2, this shortcut will select column B.

14. Select the Entire Row Containing the Active Cell

If you want to quickly select the entire row containing the active cell, simply press the Shift+Spacebar shortcut. For example, if the active cell is B2, this shortcut will select row 2.

15. Select the First Cell in the Worksheet

To quickly select the first cell in the worksheet, simply press the Ctrl+Home shortcut. This shortcut will select cell A1, even if the worksheet is scrolled down or to the right.

16. Select the Last Cell in the Worksheet

To quickly select the last cell in the worksheet, simply press the Ctrl+End shortcut. This shortcut will select the last cell in the worksheet that contains data, even if the worksheet is scrolled down or to the right.

17. Select the First Cell in the Row

To quickly select the first cell in the row, simply press the Shift+Home shortcut. This shortcut will select the first cell in the row, even if the row is scrolled to the right.

18. Select the Last Cell in the Row

To quickly select the last cell in the row, simply press the Shift+End shortcut. This shortcut will select the last cell in the row that contains data, even if the row is scrolled to the right.

19. Select the First Cell in the Column

To quickly select the first cell in the column, simply press the Ctrl+Shift+Home shortcut. This shortcut will select the first cell in the column, even if the column is scrolled down.

20. Select the Last Cell in the Column

To quickly select the last cell in the column, simply press the Ctrl+Shift+End shortcut. This shortcut will select the last cell in the column that contains data, even if the column is scrolled down.

21. Select the Next Cell

To quickly select the next cell, simply press the Tab key. This shortcut will select the cell to the right of the active cell. You can also use the Ctrl+Tab shortcut to select the next cell.

22. Select the Previous Cell

To quickly select the previous cell, simply press the Shift+Tab shortcut. This shortcut will select the cell to the left of the active cell.

23. Select the Next Column

To quickly select the next column, simply press the Ctrl+Shift+Right arrow shortcut. This shortcut will select the column to the right of the active column.

24. Select the Previous Column

To quickly select the previous column, simply press the Ctrl+Shift+Left arrow shortcut. This shortcut will select the column to the left of the active column.

25. Select the Next Row

To quickly select the next

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.