If you work with Excel on a regular basis, you know how frustrating it can be to constantly check and uncheck cells. To save yourself some time and aggravation, memorize a few of these shortcuts for checking and unchecking cells in Excel.

1. To check a cell, press Ctrl + Spacebar. To uncheck a cell, press Ctrl + Shift + Spacebar.
2. To check a range of cells, press Shift + Spacebar. To uncheck a range of cells, press Ctrl + Shift + Spacebar.
3. To check all cells on a worksheet, press Ctrl + A. To uncheck all cells on a worksheet, press Ctrl + Shift + A.
4. To check all cells in a selected range, press Ctrl + Shift + Spacebar. To uncheck all cells in a selected range, press Ctrl + Shift + A.
5. To check all cells on a protected worksheet, press Ctrl + A. To uncheck all cells on a protected worksheet, press Ctrl + Shift + A.
6. To check all cells in a selected range on a protected worksheet, press Ctrl + Shift + Spacebar. To uncheck all cells in a selected range on a protected worksheet, press Ctrl + Shift + A.
7. To check all cells on a worksheet, including hidden cells, press Ctrl + A. To uncheck all cells on a worksheet, including hidden cells, press Ctrl + Shift + A.
8. To check all cells in a selected range, including hidden cells, press Ctrl + Shift + Spacebar. To uncheck all cells in a selected range, including hidden cells, press Ctrl + Shift + A.
9. To check all cells on a worksheet, excluding hidden cells, press Ctrl + A. To uncheck all cells on a worksheet, excluding hidden cells, press Ctrl + Shift + A.
10. To check all cells in a selected range, excluding hidden cells, press Ctrl + Shift + Spacebar. To uncheck all cells in a selected range, excluding hidden cells, press Ctrl + Shift + A.
11. To check all cells on a worksheet, including locked cells, press Ctrl + A. To uncheck all cells on a worksheet, including locked cells, press Ctrl + Shift + A.
12. To check all cells in a selected range, including locked cells, press Ctrl + Shift + Spacebar. To uncheck all cells in a selected range, including locked cells, press Ctrl + Shift + A.
13. To check all cells on a worksheet, excluding locked cells, press Ctrl + A. To uncheck all cells on a worksheet, excluding locked cells, press Ctrl + Shift + A.
14. To check all cells in a selected range, excluding locked cells, press Ctrl + Shift + Spacebar. To uncheck all cells in a selected range, excluding locked cells, press Ctrl + Shift + A.
15. To check all cells on a worksheet, including cells that are not visible, press Ctrl + A. To uncheck all cells on a worksheet, including cells that are not visible, press Ctrl + Shift + A.
16. To check all cells in a selected range, including cells that are not visible, press Ctrl + Shift + Spacebar. To uncheck all cells in a selected range, including cells that are not visible, press Ctrl + Shift + A.
17. To check all cells on a worksheet, excluding cells that are not visible, press Ctrl + A. To uncheck all cells on a worksheet, excluding cells that are not visible, press Ctrl + Shift + A.
18. To check all cells in a selected range, excluding cells that are not visible, press Ctrl + Shift + Spacebar. To uncheck all cells in a selected range, excluding cells that are not visible, press Ctrl + Shift + A.
19. To check all cells on a worksheet, including cells that are not visible and locked cells, press Ctrl + A. To uncheck all cells on a worksheet, including cells that are not visible and locked cells, press Ctrl + Shift + A.
20. To check all cells in a selected range, including cells that are not visible and locked cells, press Ctrl + Shift + Spacebar. To uncheck all cells in a selected range, including cells that are not visible and locked cells, press Ctrl + Shift + A.
21. To check all cells on a worksheet, excluding cells that are not visible and locked cells, press Ctrl + A. To uncheck all cells on a worksheet, excluding cells that are not visible and locked cells, press Ctrl + Shift + A.
22. To check all cells in a selected range, excluding cells that are not visible and locked cells, press Ctrl + Shift + Spacebar. To uncheck all cells in a selected range, excluding cells that are not visible and locked cells, press Ctrl + Shift + A.

Now that you know a few shortcuts for checking and unchecking cells in Excel, put them to use and see how much time you can save!