Excel shortcuts

19 Excel Shortcuts to Highlight Cells Faster

If you work with Excel on a daily basis, then you know how important it is to be able to highlight cells quickly and efficiently. There are a number of different ways to do this, but some methods are faster than others. In this article, we'll share 19 Excel shortcuts that will help you highlight cells faster and make your work easier overall.

1. To highlight a single cell, simply click on it with your mouse.

2. To highlight a range of cells, click on the first cell in the range and then drag your mouse over the rest of the cells you want to highlight.

3. To highlight all cells in a column, click on the column header.

4. To highlight all cells in a row, click on the row header.

5. To highlight all cells in a worksheet, click on the upper-left corner of the worksheet.

6. To quickly highlight all cells that contain a specific value, type the value into the cell and then press Ctrl + Shift + Enter.

7. To quickly highlight all cells that contain a specific text string, type the text string into the cell and then press Ctrl + Shift + Enter.

8. To quickly highlight all cells that are greater than a specific value, type the value into the cell and then press Ctrl + Shift + >.

9. To quickly highlight all cells that are less than a specific value, type the value into the cell and then press Ctrl + Shift + <.

10. To quickly highlight all cells that are equal to a specific value, type the value into the cell and then press Ctrl + Shift + =.

11. To quickly highlight all cells that are not equal to a specific value, type the value into the cell and then press Ctrl + Shift + !=.

12. To quickly highlight all cells that are blank, press Ctrl + Shift + Space.

13. To quickly highlight all cells that are not blank, press Ctrl + Shift + Space.

14. To quickly highlight all cells that are error values, press Ctrl + Shift + #.

15. To quickly highlight all cells that are not error values, press Ctrl + Shift + ~.

16. To quickly highlight all cells that are formulas, press Ctrl + Shift + ' (apostrophe).

17. To quickly highlight all cells that are not formulas, press Ctrl + Shift + " (quotation mark).

18. To quickly highlight all cells that are locked, press Ctrl + Shift + !.

19. To quickly highlight all cells that are not locked, press Ctrl + Shift + @.

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.