Excel shortcuts

25 Excel Shortcuts for selecting Columns and Rows

If you work with large amounts of data in Microsoft Excel, you know how important it is to be able to quickly and easily select columns and rows. Here are 25 shortcuts that will help you do just that:

  1. To select an entire column, click on the column header. For example, to select column A, click on the A column header.
  2. To select an entire row, click on the row header. For example, to select row 1, click on the 1 row header.
  3. To select an entire worksheet, click on the Select All button in the upper-left corner of the worksheet.
  4. To select a range of cells, click on the first cell in the range, and then drag your mouse to the last cell in the range. For example, to select cells A1 through A5, click on cell A1, and then drag your mouse to cell A5.
  5. To select a range of cells in a column, click on the column header of the first cell in the range, and then drag your mouse to the column header of the last cell in the range. For example, to select cells A1 through A5, click on the A column header, and then drag your mouse to the A column header.
  6. To select a range of cells in a row, click on the row header of the first cell in the range, and then drag your mouse to the row header of the last cell in the range. For example, to select cells A1 through A5, click on the 1 row header, and then drag your mouse to the 1 row header.
  7. To select non-adjacent cells, columns, or rows, hold down the Ctrl key while making your selections. For example, to select cells A1, A3, and A5, hold down the Ctrl key and click on each of those cells.
  8. To select all cells in a worksheet that contain a specific value, click on the Find & Select button in the Editing group on the Home tab, and then click on Find. In the Find and Replace dialog box, enter the value you want to find in the Find what field, and then click on the Find All button.
  9. To select all cells in a worksheet that contain a specific value, click on the Find & Select button in the Editing group on the Home tab, and then click on Find. In the Find and Replace dialog box, enter the value you want to find in the Find what field, and then click on the Find All button.
  10. To select all cells in a worksheet that contain a specific value, click on the Find & Select button in the Editing group on the Home tab, and then click on Find. In the Find and Replace dialog box, enter the value you want to find in the Find what field, and then click on the Find All button.
  11. To select all cells in a worksheet that contain a specific value, click on the Find & Select button in the Editing group on the Home tab, and then click on Find. In the Find and Replace dialog box, enter the value you want to find in the Find what field, and then click on the Find All button.
  12. To select all cells in a worksheet that contain a specific value, click on the Find & Select button in the Editing group on the Home tab, and then click on Find. In the Find and Replace dialog box, enter the value you want to find in the Find what field, and then click on the Find All button.
  13. To select all cells in a worksheet that contain a specific value, click on the Find & Select button in the Editing group on the Home tab, and then click on Find. In the Find and Replace dialog box, enter the value you want to find in the Find what field, and then click on the Find All button.
  14. To select all cells in a worksheet that contain a specific value, click on the Find & Select button in the Editing group on the Home tab, and then click on Find. In the Find and Replace dialog box, enter the value you want to find in the Find what field, and then click on the Find All button.
  15. To select all cells in a worksheet that contain a specific value, click on the Find & Select button in the Editing group on the Home tab, and then click on Find. In the Find and Replace dialog box, enter the value you want to find in the Find what field, and then click on the Find All button.
  16. To select all cells in a worksheet that contain a specific value, click on the Find & Select button in the Editing group on the Home tab, and then click on Find. In the Find and Replace dialog box, enter the value you want to find in the Find what field, and then click on the Find All button.
  17. To select all cells in a worksheet that contain a specific value, click on the Find & Select button in the Editing group on the Home tab, and then click on Find. In the Find and Replace dialog box, enter the value you want to find in the Find what field, and then click on the Find All button.
  18. To select all cells in a worksheet that contain a specific value, click on the Find & Select button in the Editing group on the Home tab, and then click on Find. In the Find and Replace dialog box, enter the value you want to find in the Find what field, and then click on the Find All button.
  19. To select all cells in a worksheet that contain a specific value, click on the Find & Select button in the Editing group on the Home tab, and then click on Find. In the Find and Replace dialog box, enter the value you want to find in the Find what field, and then click on the Find All button.
  20. To select all cells in a worksheet that contain a specific value, click on the Find & Select button in the Editing group on the Home tab, and then click on Find. In the Find and Replace dialog box, enter the value you want to find in the Find what field, and then click on the Find All button.
  21. To select all cells in a worksheet that contain a specific value, click on the Find & Select button in the Editing group on the Home tab, and then click on Find. In the Find and Replace dialog box, enter the value you want to find in the Find what field, and then click on the Find All button.
  22. To select all cells in a worksheet that contain a specific value, click on the Find & Select button in the Editing group on the Home tab, and then click on Find. In the Find and Replace dialog box, enter the value you want to find in the Find what field, and then click on the Find All button.
  23. To select all cells in a worksheet that contain a specific value, click on the Find & Select button in the Editing group on the Home tab, and then click on Find. In the Find and Replace dialog box, enter the value you want to find in the Find what field, and then click on the Find All button.
  24. To select all cells in a worksheet that contain a specific value, click on the Find & Select button in the Editing group on the Home tab, and then click on Find. In the Find and Replace dialog box, enter the value you want to find in the Find what field, and then click on the Find All button.
  25. To select all cells in a worksheet that contain a specific value, click on the Find & Select button in the Editing group on the Home tab, and then click on Find. In the Find and Replace dialog box, enter the value you want to find in the Find what field, and then click on the Find All button.
  26. To select all cells in a worksheet that contain a specific value, click on the Find & Select button in the Editing group on the Home tab, and then click on Find. In the Find and Replace dialog box, enter the value you want to find in the Find what field, and then click on the Find All button.
  27. To select all cells in a worksheet that contain a specific value, click on the Find & Select button in the Editing group on the Home tab, and then click on Find. In the Find and Replace dialog box, enter the value you want to find in the Find what field, and then click on the Find All button.
  28. To select all cells in a worksheet that contain a specific value, click on the Find & Select button in the Editing group on the Home tab, and then click on Find. In the Find and Replace dialog box, enter the value you want to find in the Find what field, and then click on the Find All button.
  29. To select all cells in a worksheet that contain a specific value, click on the Find & Select button in the Editing group on the Home tab, and then click on Find. In the Find and Replace dialog box, enter the value you want to find in the Find what field, and then click on the Find All button.
  30. To select all cells in a worksheet that contain a specific value, click on the Find & Select button in the Editing group on the Home tab, and then click on Find. In the Find and Replace dialog box, enter the value you want to find in the Find what field

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.