Inside The Web
    Facebook Twitter Instagram
    Inside The Web
    • Office
      • Excel
      • Ms Word
      • Gmail
    • Productivity
      • Time Management
      • Task Automation
    Inside The Web
    Home»Excel»How to Hide or Unhide a Column in Excel

    How to Hide or Unhide a Column in Excel

    AsmiBy AsmiFebruary 7, 2023 Excel 2 Mins Read

    Microsoft Excel allows you to put certain columns away from view through the Hide option. If a column looks redundant but has active cell references, you can hide the column from your worksheet. As hiding a column isn’t equivalent to deleting a column, you can always bring it back to display using the Unhide option.

    As easy as it is to hide a column, easier it is to unhide. Your data will remain intact when you unhide it from the grid.

    How to Hide a Column in Excel?

    You can hide an existing column from the sheet itself. Open your workbook on Excel and refer to the following:

    1. Select the letter of the column you wish to hide. If you have multiple, hold Ctrl and select the remaining column letters.
    2. Right-click on the column header.
    3. Choose Hide.
      How to hide column Excel

    How to Unhide a Column in Excel?

    You can identify hidden columns in a grid by inspecting the column headers. If you see that a letter is missing, or there is an unusual double line between two column headers, there is a hidden column.

    1. Launch Excel to open your workbook.
    2. Select the columns that have a hidden column between them.
    3. Right-click on the headers, then, choose Unhide.
      Unhide column Excel

    You might face a slight issue in following these steps if you’ve hidden the first column in your sheet. This is because there is technically no column preceding Column A to sandwich it. However, you can always double-click between the two lines that appear before Column B to unhide Column A.

    How to Unhide all Columns at the Same Time?

    If you’re dealing with a bigger workbook and don’t have the time to individually select columns to reveal the hidden range, you can unhide all columns at the same time.

    1. Open your Excel document.
    2. Use Select All (Ctrl + A)
    3. Right-click on the header and choose Unhide.
      Unhide all hidden columns Excel

    How do I Prevent Other Users from Unhiding Hidden Columns?

    If you’re trying to hide a column to prevent other users from viewing the hidden columns, simply following the methods mentioned above won’t work. This is because anybody can notice the presence of a hidden column and unhide it.

    You can, however, protect the worksheet from the Review tab before sharing it with your peers. This will prevent them from using the Unhide feature, protecting your hidden column.

    Excel Basics
    Asmi

      Asmi is a content writer specializing in MS Office. She loves writing Excel-related content to assist other users to learn their way around the program. She started using Excel when she first entered the industry as a marketing intern. Soon, she realized that learning the often-overlooked spreadsheet program was no piece of cake. In her articles, she attempts to brief out complex topics to help beginner to intermediate-level Excel users. Asmi uses Excel for everything, including creating a grocery list to managing her personal finance. She’s a bit dramatic when it comes to the Flash Fill feature; so much so that could write a eulogy out of it. When she’s not working, you’ll find her learning a new recipe, or cleaning up her mess (out of the failed recipe).

      Add A Comment
      Table of Contents
      • How to Hide a Column in Excel?
      • How to Unhide a Column in Excel?
      • How to Unhide all Columns at the Same Time?
      • How do I Prevent Other Users from Unhiding Hidden Columns?
      Recent Posts
      • How to Calculate Discount Percentage in Excel
      • How to Create a Progress Bar in Excel
      • What is VSTACK in Excel
      • How to Separate Dates in Excel
      • How to Lock a Cell in Excel Formula
      • Home
      • Privacy Policy
      © 2023 Inside The Web

      Type above and press Enter to search. Press Esc to cancel.