Excel shortcuts

15 essential Excel shortcuts for selecting columns of data

If you work with data in Excel, you know how important it is to be able to quickly and easily select the columns you need. Here are 15 essential shortcuts for selecting columns of data in Excel.

1. To select a single column, click on the column header. For example, to select column A, click on the A column header.

2. To select multiple adjacent columns, click on the first column header and then drag your mouse to the last column header. For example, to select columns A through C, click on the A column header and then drag your mouse to the C column header.

3. To select multiple non-adjacent columns, click on the first column header, then hold down the Ctrl key (Windows) or Command key (Mac), and then click on each of the other column headers you want to select. For example, to select columns A, C, and E, click on the A column header, then hold down the Ctrl key (Windows) or Command key (Mac), and then click on the C and E column headers.

4. To select the entire worksheet, click on the Select All button in the upper-left corner of the worksheet.

5. To select all cells in a column, click on the column header. For example, to select all cells in column A, click on the A column header.

6. To select all cells in a row, click on the row header. For example, to select all cells in row 1, click on the 1 row header.

7. To select all cells in a range, click on the first cell in the range, then hold down the Shift key and click on the last cell in the range. For example, to select all cells in the range A1:C3, click on cell A1, then hold down the Shift key and click on cell C3.

8. To select all cells in a worksheet, click on the Select All button in the upper-left corner of the worksheet.

9. To select all cells in a column, click on the column header. For example, to select all cells in column A, click on the A column header.

10. To select all cells in a row, click on the row header. For example, to select all cells in row 1, click on the 1 row header.

11. To select all cells in a range, click on the first cell in the range, then hold down the Shift key and click on the last cell in the range. For example, to select all cells in the range A1:C3, click on cell A1, then hold down the Shift key and click on cell C3.

12. To select all cells in a worksheet, click on the Select All button in the upper-left corner of the worksheet.

13. To select all cells in a column, click on the column header. For example, to select all cells in column A, click on the A column header.

14. To select all cells in a row, click on the row header. For example, to select all cells in row 1, click on the 1 row header.

15. To select all cells in a range, click on the first cell in the range, then hold down the Shift key and click on the last cell in the range. For example, to select all cells in the range A1:C3, click on cell A1, then hold down the Shift key and click on cell C3.

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.