How to display columns in Excel: 6 steps (with pictures)

How to display columns in Excel: 6 steps (with pictures)
How to display columns in Excel: 6 steps (with pictures)
Anonim

You may come across an Excel spreadsheet with hidden columns. It is very easy to make them appear, regardless of the version of Excel (Windows or macOS).

Steps

Unhide Columns in Excel Step 1

Step 1. Open your Excel document

There are two possibilities: either you double-click directly on the document which contains hidden columns or you run Excel first, then you open the document in question from the home page or from the general menu bar.

Unhide Columns in Excel Step 2

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

Hold down the Shift key, then click the column header to the left of the hidden column, then click the column header to the right. The two columns are then highlighted.

  • Suppose the columns B and VS are hidden (illustration), hold down the Shift key, click TO, then on D.
  • Special case: if it is the column TO which is hidden, in the white field (formula bar) above the header B, type A1.
Unhide Columns in Excel Step 3

Step 3. Click on the Home tab

In the green ribbon, this tab is the second from the left, at the top of the Excel window. In doing so, you bring up the toolbar of the section Home.

Unhide Columns in Excel Step 4

Step 4. Click Format

This option is in third position in the group Cells, rather to the right of all groups. A drop-down menu will then appear.

Unhide Columns in Excel Step 5

Step 5. Select Hide & Show

You will find this possibility in the menu and in the section Visibility. By clicking on it, a context menu will appear on the right.

Unhide Columns in Excel Step 6

Step 6. Click Show Columns

In the menu Hide & show, this option is in fifth position. From then on, the hidden columns of your document are displayed on the screen again.

Advice

  • If the columns remained hidden after this operation, it is because the width of the columns in question is set to 0. To widen them, bring the mouse cursor over one of the small lines close to the header row, wait for your cursor becomes a double horizontal arrow and by clicking on the mouse, drag the cursor to the right of the desired width.
  • If you want to display all the hidden columns (dispersed or not) of an Excel spreadsheet, click on the button (black and triangular) Select all which is to the left of the column TO and above the line

    Step 1.. Then all you have to do is operate as explained above.

Popular by topic