How to Hide and Unhide Columns in Excel | Scribe

    How to Hide and Unhide Columns in Excel

      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"