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.
- To check a cell, press Ctrl + Spacebar. To uncheck a cell, press Ctrl + Shift + Spacebar.
- To check a range of cells, press Shift + Spacebar. To uncheck a range of cells, press Ctrl + Shift + Spacebar.
- To check all cells on a worksheet, press Ctrl + A. To uncheck all cells on a worksheet, press Ctrl + Shift + A.
- To check all cells in a selected range, press Ctrl + Shift + Spacebar. To uncheck all cells in a selected range, press Ctrl + Shift + A.
- To check all cells on a protected worksheet, press Ctrl + A. To uncheck all cells on a protected worksheet, press Ctrl + Shift + A.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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!