Make Hidden Columns Visible in Excel: 6 Steps (with Pictures)

Table of contents:

Make Hidden Columns Visible in Excel: 6 Steps (with Pictures)
Make Hidden Columns Visible in Excel: 6 Steps (with Pictures)

Video: Make Hidden Columns Visible in Excel: 6 Steps (with Pictures)

Video: Make Hidden Columns Visible in Excel: 6 Steps (with Pictures)
Video: How to Convert Excel file to DAT file in easy way | Edcelle John Gulfan 2023, December
Anonim

This wikiHow teaches you how to show a hidden column in Microsoft Excel. You can do this in both the Windows and Mac versions of Excel.

method

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

Step 1. Open your Excel document with the hidden columns

Double-click the Excel document or the Excel icon and then select the document on the start page. This opens the document in Excel.

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

Step 2. Select the columns on either side of the hidden column

While clicking the letter above the column to the left and right of the hidden column, press ⇧ Shift. The columns are marked.

  • If z. B. Column B. is hidden, you should be up A. and then on C. while holding down ⇧ Shift.
  • If you have column A. to show it again, select it by entering "A1" in the name field to the left of the formula bar.
Unhide Columns in Excel Step 3
Unhide Columns in Excel Step 3

Step 3. Click on the Start tab at the top left, at the bottom of the green ribbon

This ensures that the "Start" toolbar is displayed under the green ribbon.

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

Step 4. Click Format

You can find this button on the start tab in the "Cells" area, on the far right in the toolbar. A drop-down menu will appear.

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

Step 5. Select Hide & Show

You can find this option under the heading "Visibility" in the drop-down menu format. A new menu will appear.

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

Step 6. Click Show Columns near the bottom of this menu

This immediately shows the column between the two selected columns again.

Tips

  • If some of the columns still don't show after trying to show them again, the width of the column may be set to "0" or some other small value. Position the cursor on the right edge of the column and drag it to the side to make the column wider.
  • If you want to show all the hidden columns in an Excel table again, click on the "Select all" button (the empty rectangle to the left of column "A" and above row "1"). Now you can continue with the rest of the steps in this article to bring these columns back up.

Recommended: