top of page
  • Excel Master

What Are The Best Excel Shortcuts for Hiding Cells, Rows, and Columns

Excel offers several keyboard shortcuts for hiding cells, rows, and columns. Here are some commonly used shortcuts:

  • Hide a cell, row, or column:

    • Ctrl + 0 (zero): Hides the selected column(s).

    • Ctrl + 9: Hides the selected row(s).

    • Ctrl + Shift + 9: Unhides the selected row(s) or column(s).

  • Hide multiple contiguous columns or rows:

    • Select the columns or rows you want to hide.

    • Right-click on the selected columns or rows.

    • Choose "Hide" from the context menu.

  • Hide multiple non-contiguous columns or rows:

    • Select the first column or row you want to hide.

    • Hold down the Ctrl key and select additional columns or rows.

    • Right-click on the selected columns or rows.

    • Choose "Hide" from the context menu.

  • Hide cells, rows, or columns using the Format dialog box:

    • Select the cells, rows, or columns you want to hide.

    • Right-click on the selected cells, rows, or columns.

    • Choose "Format Cells" from the context menu.

    • In the Format Cells dialog box, go to the "Protection" tab.

    • Check the "Hidden" checkbox.

    • Click on "OK" to apply the changes.

  • Unhide hidden cells, rows, or columns:

    • Select the surrounding cells, rows, or columns of the hidden ones.

    • Right-click on the selected cells, rows, or columns.

    • Choose "Unhide" from the context menu.

Remember that hiding cells, rows, or columns does not protect or secure the data in any way. Hidden cells can still be accessed and modified by anyone with access to the worksheet. If you need to secure sensitive information, consider using Excel's protection features or password protection.

4 views0 comments

Recent Posts

See All

How to Use the Autofit Column Width Shortcut in Excel

To use the Autofit Column Width shortcut in Excel, follow these steps: Open Microsoft Excel and navigate to the worksheet containing the columns you want to autofit. Select the column or columns that

How to Add Axis Labels in Excel

To add axis labels in Excel, follow these steps: Open Microsoft Excel and open the worksheet containing the chart you want to edit. Click on the chart to select it. This will activate the Chart Tools

Comments


bottom of page