How to Hide and Unhide Columns in Excel | Scribe

    How to Hide and Unhide Columns in Excel

    • |
    • 5 steps |
    • 30 seconds
      1

      To begin, open your workbook in Excel.

      Hiding Columns

      2

      Click the Column Header you want to hide.

      3

      In the Home tab, click "Format" to open a drop down menu.\ Under "Visibility," hover over "Hide & Unhide" then click "Hide Columns."

      In the Home tab, click "Format" to open a drop down menu.\
Under "Visibility," hover over "Hide & Unhide" then click "Hide Columns."

      Unhiding Columns

      4

      Click the Select All cell in the top left of the spreadsheet.

      5

      In the Home tab, click "Format" to open a drop down menu. Under "Visibility," hover over "Hide & Unhide" then click "Unhide Columns"

      In the Home tab, click "Format" to open a drop down menu.

Under "Visibility," hover over "Hide & Unhide" then click "Unhide Columns"