3 ways to display rows in Excel

3 ways to display rows in Excel
3 ways to display rows in Excel
Anonim

For one reason or another, sometimes rows are missing in an Excel document: they are hidden. It is very easy to make them reappear.

Steps

Method 1 of 3: Show a particular row in Excel

Unhide Rows in Excel Step 1

Step 1. Open the Excel document

Double-click on the Excel document that will be the object of the modifications. It must contain hidden lines.

Step 2. Find the hidden row

Take a look at the numbered references in the lines on the left side of the sheet. Any missing reference (in the illustration, the line

Step 7. is under the line

Step 1.) proves that the lines between the two references are hidden. You also notice that there is a double line, which does not exist when all lines are displayed.

Step 3. Right click on the small space between the two references

A contextual menu appears.

  • Suppose the line

    Step 24. be hidden, right-click on the space between

    Step 23. e

    Step 25..

  • In macOS, hold down the Control key, then click on the same space, a drop-down menu appears.

Step 4. Click Show

So the last hidden line appears. In our example, this would be line 6.

To save the changes, use the keyboard to type Control + S (on Windows) or Command + S (on macOS)

Step 5. Show multiple hidden rows

If, as in our example, several lines are hidden, operate slightly differently.

  • Hold down the Control key (in Windows) or Command (in macOS), click the number reference of the line above the hidden lines, then click the reference of the line below the same lines.
  • Right click on one of the selected references, the one you want.
  • Just click on Display and your lines appear.

Method 2 of 3: Show hidden rows in Excel

Unhide Rows in Excel Step 7

Step 1. Open the Excel document

Double-click on the Excel document that will be the object of the modifications. It must contain hidden lines.

Step 2. Click the Select All button

This triangular button is in the upper left corner of the worksheet, just above the row

Step 1. and to the left of the column title TO. In doing so, you will select the entire Excel document.

To select the entire document, simply click in any cell in the document, then press Control + A (on Windows) or Command + A (on macOS)

Unhide Rows in Excel Step 3

Step 3. Click on the Home tab

This tab is the second from the left, at the top of the Excel window.

  • If the tab Home is already activated, go to the next step.
Unhide Rows 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.

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.

Step 6. Click Show Rows

By carrying out this action, you reveal all the hidden rows of the worksheet.

To save the changes, use the keyboard to type Control + S (on Windows) or Command + S (on macOS)

Method 3 of 3: Adjust the height of a row in Excel

Unhide Rows in Excel Step 12

Step 1. Understand when to use this display method

The lines are sometimes hidden because their heights are close to 0: they exist, but are not visible. To make them appear, you have to give them the default height, i.e. 14.4 points.

Unhide Rows in Excel Step 13

Step 2. Open the Excel document

Double-click on the Excel document that will be the object of the modifications. It must contain rows that have been reduced in height.

Step 3. Click the Select All button

This triangular button is in the upper left corner of the worksheet, just above the row

Step 1. and to the left of the column title TO. In doing so, you will select the entire Excel document.

To select the entire document, simply click in any cell in the document, then press Control + A (on Windows) or Command + A (on macOS)

Step 4. Click on the Home tab

This tab is the second from the left, at the top of the Excel window.

  • If the tab Home is already activated, go to the next step.
Unhide Rows in Excel Step 16

Step 5. 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 Rows in Excel Step 17

Step 6. Click Row Height

You will find this possibility at the top of the menu and in the section Cell size. A pop-up window with a blank text field appears.

Unhide Rows in Excel Step 18

Step 7. Enter the height you want

In the all-white field, type, for example, 14, 4.

Unhide Rows in Excel Step 19

Step 8. Click OK

In doing so, all the rows and therefore the cells will have the height you designated as their height, this only works if the rows had been hidden due to a reduction in their heights.

Popular by topic