How to Show Hidden Columns Back in Excel: 6 Steps

Table of contents:

How to Show Hidden Columns Back in Excel: 6 Steps
How to Show Hidden Columns Back in Excel: 6 Steps

Video: How to Show Hidden Columns Back in Excel: 6 Steps

Video: How to Show Hidden Columns Back in Excel: 6 Steps
Video: Buttercream Icing Recipe / How to Make Perfect Buttercream Frosting 2024, November
Anonim

This wikiHow teaches you how to show hidden columns in Microsoft Excel. This method can be used on both Windows and Mac versions of Microsoft Excel.

Step

Unhide Columns in Excel Step 1
Unhide Columns in Excel Step 1

Step 1. Open the Excel document

Double-click the Excel document, or double-click on the Excel icon and select a document name from the home page. This will open the document that has hidden fields in it.

Unhide Columns in Excel Step 2
Unhide Columns in Excel Step 2

Step 2. Select the columns that surround the hidden column

Hold down Shift as you click the letter above the left column and then the right column of the hidden column. These fields will be marked if you successfully select them.

  • For example, if the column B hidden, click A then C while holding down the Shift key.
  • If you want to display the column A, select the column by typing "A1" in the "Name Box" box located to the left of the formula box.
Unhide Columns in Excel Step 3
Unhide Columns in Excel Step 3

Step 3. Click the Home tab

It's in the upper left of the Excel window. This step will display the toolbar Home.

Unhide Columns in Excel Step 4
Unhide Columns in Excel Step 4

Step 4. Click Format

This button is in the "Cells" section of the. tab Home; This section is on the right side of the toolbar. A drop-down menu will appear.

Unhide Columns in Excel Step 5
Unhide Columns in Excel Step 5

Step 5. Select Hide & Unhide

This option is under the "Visibility" heading in the menu Format. After selecting this, a pop-out menu will appear.

Unhide Columns in Excel Step 6
Unhide Columns in Excel Step 6

Step 6. Click Unhide Columns

It's located under the menu Hide & Unhide. This will immediately reveal the hidden column between the two selected columns.

Tips

  • If some of the columns are still not visible after this step, the column width may have been set to "0" or some other small number. To expand a column, place the cursor on the right side of the column, and drag the column to expand it.
  • If you want to show all hidden columns in an Excel spreadsheet, click the "Select All" button, which is an empty square box to the left of column "A" and above row "1". Next, do the steps as written in this article to display these columns.

Sources and Citation

  1. https://support.office.com/en-us/article/Hide-or-show-rows-or-columns-659c2cad-802e-44ee-a614-dde8443579f8

Recommended: