PDF download Download Article
Plus, how to unhide column A when it's not visible
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, as well as on Excel on the web. There are multiple simple methods to unhide hidden columns. You can drag the columns, use the right-click menu, or format the columns. Read on to learn how to show hidden columns in Excel, including the first column (column A).

Easy Ways to Unhide Columns in Excel

  • To unhide a column, select the column headers of the columns on either side of the one you want to show, right-click the selection, and choose Unhide .
  • To unhide column A, or just one column that's in a group of many hidden columns, you can use the name box .
  • You can also unhide columns by hovering your cursor to the right of the hidden columns, then clicking and dragging to the right to unhide them.
Method 1
Method 1 of 4:

Right-click to Unhide

PDF download Download Article
  1. To do this, hold down the Shift key as you click the letter of the column to the left of the hidden column, and then the column to its right. [1]
    • For example, if you want to unhide column D, hold down Shift as you click the column C and column E headers.
      • Don't hold down Ctrl . This won't work.
    • Note: If the column you want to unhide is column A (the first column), or you only want to unhide one column that's in the middle of a bunch of other hidden columns, jump down to Unhiding One Column with the Name Box to learn how to unhide it.
  2. This will open the dialog menu.
    Advertisement
  3. Any columns that were hidden between the two selected columns are now unhidden.
  4. Advertisement
Method 2
Method 2 of 4:

Dragging to Show Hidden Columns

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 unhide the hidden column immediately.
  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 !
    • If multiple columns are hidden between the selected columns, drag slowly to only show the hidden columns you want to see without unhiding all columns at once.
  4. Advertisement
Method 3
Method 3 of 4:

Unhiding One Column with the Name Box

PDF download Download Article
  1. If only the first column (column A) is hidden, it's difficult to unhide since you can't select the column to its left. You can use this method to unhide column A, or any individual column, without unhiding multiple columns at once. [2]
    • The Name Box is to the left of the formula field.
    • If you are using Excel in your web browser, not in the desktop application, you can easily unhide column A by right-clicking the column B header and selecting Unhide Columns . [3]
  2. If you're unhiding column A, that's the cell address you'll need to type. To unhide a different column, enter that cell address now.
    • For example, if you want to unhide column Y without unhiding a bunch of hidden columns on either side of it, enter Y1 into the Name Box.
  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. [4]
    • If you don't see this option, click the Editing drop-down menu tile, or just maximize your Excel window to display more options.
  5. This will open the "Go To" window.
  6. The box will disappear.
  7. 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. [5]
    • If you don't see this option, click the Cells menu at the top of the window, or maximize your window to show all options.
  8. This option is below the "Visibility" heading in the Format drop-down menu. More options will appear.
  9. It's near the bottom of the Hide & Unhide menu. Doing so will immediately unhide the column you entered into the Name Box.
  10. 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.
  2. 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. [6]
    • If you don't see this option, click the Cells menu at the top of the window, or maximize your window to show all options.
  3. This option is below the "Visibility" heading in the Format menu. Selecting it will open another menu. [7]
  4. It's near the bottom of the Hide & Unhide menu. Doing so will immediately unhide every hidden column in the sheet. [8]
  5. 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.
  • 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.
  • 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.
See more answers
Ask a Question
      Advertisement

      Video

      Tips

      • Hiding columns can be useful 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.
      • 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.
      • For more cool things to do in Excel, check out our guides to VLOOKUP and the IF function .
      Show More Tips
      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Thanks for submitting a tip for review!
      Advertisement

      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?
      Thanks to all authors for creating a page that has been read 785,349 times.

      Is this article up to date?

      Advertisement