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.
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.
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.
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.
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.
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.
Step 6. Click Show Columns near the bottom of this menu
This immediately shows the column between the two selected columns again.
- 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.