How to Show Hidden Columns in Microsoft Excel & Unhide Column A

PDF download Download Article
Quick ways to display hidden columns on an Excel spreadsheet
PDF download Download Article

Are you having trouble viewing certain columns in your Excel workbook? This wikiHow guide shows you how to display a hidden column in Microsoft Excel. You can do this on both the Windows and Mac versions of Excel. There are multiple simple methods to unhide hidden columns. You can drag the columns, use the right-click menu, or format the columns.

Easy Ways to Unhide Columns in Excel

  • Hover your cursor to the right of the hidden columns, then click and drag to the right to unhide them.
  • Alternatively, select the columns adjacent to the hidden columns. Then right-click and select Unhide .
  • To unhide column A, right-click the column B header or row label and pick Unhide Columns .
Method 1
Method 1 of 4:

Using the Column Drag Tool

PDF download Download Article
  1. When your cursor is between the column letters adjacent to the hidden columns, the cursor will change into two parallel lines with two arrows pointing horizontally.
    • You can identify hidden columns by looking for two lines between column letters.
    • Your cursor needs to be to the right of the two lines for this method. Placing the cursor to the left will increase the column size of the left adjacent column.
  2. This will unhide the hidden columns between the adjacent columns.
    • Alternatively, you can double-click to immediately unhide the hidden column.
    Advertisement
  3. This will confirm the size of the unhidden columns. You’re ready to move some columns , sort your data , and add up column values !
    4. Advertisement
Method 2
Method 2 of 4:

Using Right Click

PDF download Download Article
  1. To do this:
    • Hold down the ⇧ Shift key while you click both letters above the column
    • Click the left column next to the hidden columns.
    • Click the right column next to the hidden columns.
    • The columns will be highlighted when you successfully select them.
    • For example, if column B is hidden, you should click A and then C while holding down ⇧ Shift .
  2. This will open the right-click pop up menu.
  3. The hidden columns between the two selected columns will be unhidden.
    4. Advertisement
Method 3
Method 3 of 4:

Unhiding One Column with the Name Box

PDF download Download Article
  1. This is the drop down box to the left of the formula box. [1]
    • This method is great for unhiding the first column (A) since there isn't a column to its left that you can select to access the right-click Unhide menu option.
  2. Replace A with the letter of the column you want to unhide.
  3. It's in the upper-left corner of the Excel window.
  4. This is in the "Editing" group in the Home tab. A drop down menu will open.
  5. This will open the "Go To" window.
  7. It's in the upper-left corner of the Excel window.
  8. This button is in the "Cells" section of the Home tab; you'll find this section on the right side of the toolbar. A drop down menu will appear. [2]
  9. This option is below the "Visibility" heading in the Format drop down menu. Selecting it will open a pop up menu.
  10. It's near the bottom of the Hide & Unhide menu. Doing so will immediately unhide the column you selected in the Name Box.
    11. Advertisement
Method 4
Method 4 of 4:

Unhiding All Columns

PDF download Download Article
  1. This is next to the row 1 label and column A label. Clicking the triangle will select the entire spreadsheet.
    • Hiding columns can be useful for when you have data you don’t need at the moment, but want to keep in the spreadsheet. For example, if you’re tracking your bills in Excel , you might want to hide purchase categories when you’re only working with the sum totals.
  2. It's in the upper-left corner of the Excel window.
  3. This button is in the "Cells" section of the Home tab; you'll find this section on the right side of the toolbar. A drop down menu will appear.
  4. This option is below the "Visibility" heading in the Format drop down menu. Selecting it will open a pop up menu.
  5. It's near the bottom of the Hide & Unhide menu. Doing so will immediately unhide every hidden column in the sheet.
    6. Advertisement

Community Q&A

Search
Add New Question
  • Question
    What do I do if the hidden columns are A and B?
    Community Answer
    You can select the whole document and do the steps above to retrieve all hidden columns.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 70 Helpful 47
  • Question
    What do I do if I've followed the instructions provided, but I still cannot unhide column A in Excel?
    Community Answer
    Try unfreezing the column and unhiding, or freezing then unfreezing then unhiding. This process will work.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 11 Helpful 77
  • Question
    If column A is hidden in excel, how do I find it?
    Community Answer
    Just use the search bar on top and type there "A1" the hidden column should appear.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 24 Helpful 5
See more answers
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Video

      Tips

      • For more cool things to do in Excel, check out our guides to VLOOKUP and the IF function .
        Thanks
        Helpful 0 Not Helpful 1
      • If some columns are still not visible after you've attempted to unhide the columns, the width of the columns may be set to "0" or another small value. To widen the column, position your cursor on the right border of the column, and drag the column to increase its width.
        Thanks
        Helpful 0 Not Helpful 0
      • If you want to unhide all hidden columns on an Excel spreadsheet, click on the "Select All" button, which is the blank rectangle to the left of column "A" and above row "1." You can then proceed with the remaining steps in this article to unhide those columns.
        Thanks
        Helpful 0 Not Helpful 0
      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!
      Advertisement

      You Might Also Like

      How to
      Merge Cells in Microsoft Excel: A Quick Guide
      How to
      Unprotect an Excel Sheet
      How to
      Unhide All Rows and Columns in Microsoft Excel
      How to
      Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Create a Graph in Excel
      How to
      Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      3 Easy Ways to Freeze Panes to Lock Columns or Rows in Excel
      How to
      Change from Lowercase to Uppercase in Microsoft Excel
      How to
      Make a Spreadsheet in Excel
      New to Excel? Here's Super Easy Tricks to Get You Started
      How to
      Link Sheets in Excel
      The Best Ways to Make & Format Lists in Excel
      Advertisement

      References

      1. ↑ https://support.microsoft.com/en-us/office/unhide-the-first-column-or-row-in-a-worksheet-d6b47608-80ee-4021-9b51-6a1f57269ec9
      2. ↑ https://support.office.com/en-us/article/Hide-or-show-rows-or-columns-659c2cad-802e-44ee-a614-dde8443579f8

      About This Article

      Article Summary X

      1. Open your Excel document .
      2. Select the columns on both sides of the hidden column.
      3. Click Home
      4. Click Format
      5. Select Hide & Unhide
      6. Click Unhide Columns

      Did this summary help you?
      In other languages
      Thanks to all authors for creating a page that has been read 761,481 times.

      Is this article up to date?

      Advertisement