Plus, how to unhide column A when it's not visible
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.
Steps
-
Select the columns on both sides of the hidden columns. 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] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
- 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.
- For example, if you want to unhide column D, hold down ⇧
Shift
as you click the column C
and column E
headers.
-
Right-click or control-click either of the selected column labels. This will open the dialog menu.Advertisement
-
Select Unhide in the menu. Any columns that were hidden between the two selected columns are now unhidden.
- For more helpful Excel tricks, check out our intro guide to Excel .
Advertisement
-
Hover your cursor directly to the right of the hidden columns. 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.
-
Click and drag to the right. This will unhide the hidden columns between the adjacent columns.
- Alternatively, you can double-click to unhide the hidden column immediately.
-
Release the mouse button. 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.
Advertisement
-
Click the Name Box. 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] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
- 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] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
-
Type A1 in the Name Box and press ↵ Enter or ⏎ Return . 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.
-
Click the Home tab. It's in the upper-left corner of the Excel window.
-
Click Find & Select . This is in the "Editing" group in the Home tab. A drop down menu will open. [4] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
- If you don't see this option, click the Editing drop-down menu tile, or just maximize your Excel window to display more options.
-
Select Go To . This will open the "Go To" window.
-
Type A1 in the "Reference" box and click OK . The box will disappear.
-
Click Format on the Home tab. 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] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
- 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.
-
Select the Hide & Unhide menu. This option is below the "Visibility" heading in the Format drop-down menu. More options will appear.
-
Click Unhide Columns . It's near the bottom of the Hide & Unhide menu. Doing so will immediately unhide the column you entered into the Name Box.
Advertisement
-
Click the triangle in the top left corner of the spreadsheet. This is next to the row 1 label and column A label. Clicking the triangle will select the entire spreadsheet.
-
Click the Home tab and select Format . 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] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
- 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.
-
Select Hide & Unhide . This option is below the "Visibility" heading in the Format menu. Selecting it will open another menu. [7] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
-
Click Unhide Columns . It's near the bottom of the Hide & Unhide menu. Doing so will immediately unhide every hidden column in the sheet. [8] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
Advertisement
Community Q&A
Search
-
QuestionWhat do I do if the hidden columns are A and B?Community AnswerYou can select the whole document and do the steps above to retrieve all hidden columns.
-
QuestionWhat do I do if I've followed the instructions provided, but I still cannot unhide column A in Excel?Community AnswerTry unfreezing the column and unhiding, or freezing then unfreezing then unhiding. This process will work.
-
QuestionIf column A is hidden in excel, how do I find it?Community AnswerJust use the search bar on top and type there "A1" the hidden column should appear.
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
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.Thanks
- 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
-
Thanks
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
References
- ↑ https://support.microsoft.com/en-us/office/hide-or-show-rows-or-columns-659c2cad-802e-44ee-a614-dde8443579f8
- ↑ https://support.microsoft.com/en-us/office/unhide-the-first-column-or-row-in-a-worksheet-d6b47608-80ee-4021-9b51-6a1f57269ec9
- ↑ https://support.microsoft.com/en-us/office/unhide-the-first-column-or-row-in-a-worksheet-d6b47608-80ee-4021-9b51-6a1f57269ec9#id0ebbd=web
- ↑ https://support.microsoft.com/en-us/office/unhide-the-first-column-or-row-in-a-worksheet-d6b47608-80ee-4021-9b51-6a1f57269ec9
- ↑ https://support.microsoft.com/en-us/office/hide-or-show-rows-or-columns-659c2cad-802e-44ee-a614-dde8443579f8
- ↑ https://support.microsoft.com/en-us/office/unhide-the-first-column-or-row-in-a-worksheet-d6b47608-80ee-4021-9b51-6a1f57269ec9
- ↑ https://support.microsoft.com/en-us/office/unhide-the-first-column-or-row-in-a-worksheet-d6b47608-80ee-4021-9b51-6a1f57269ec9
- ↑ https://support.microsoft.com/en-us/office/unhide-the-first-column-or-row-in-a-worksheet-d6b47608-80ee-4021-9b51-6a1f57269ec9
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.
Advertisement