3 ways to display rows in Excel

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

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

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)

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.

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

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.

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.

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.

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.

Step 7. Enter the height you want

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

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.

4 ways to prepare for coronavirus

The news about the coronavirus (COVID-19) has probably not escaped you and it is normal for you to be worried. With the virus being confirmed in more and more places around the world, you may be wondering what will happen to your community. Even though a pandemic is frightening, keep in mind that you probably don't have to worry if your area has no confirmed cases.

3 ways to get rid of mucus without medication

It can be very irritating to have your throat covered with mucus. Fortunately, there are a lot of home remedies that are quite effective. If you have mucus in your throat, you can try home treatments like gargling with salt water or inhaling steam to make the mucus more watery.

4 ways to clean your bedroom

Cleaning your room might seem like an overwhelming task, but you'll probably get it done faster and easier than you imagine! Listen to music, make a list, treat yourself to rewards, and turn your toil into a game to stay motivated. Take care of the most important tasks first before moving on to the deep cleaning by dusting, wiping all surfaces and vacuuming all over the place.

3 ways to stop automatic subscriptions on Instagram

Have you ever noticed that you've suddenly subscribed to a whole bunch of weird Instagram accounts? This happens when spammers take control of your account. To prevent your Instagram account from automatically subscribing to other accounts, you'll need to make sure that no one other than you can access it.

3 ways to type the euro symbol

In France, it is common to have to insert the euro symbol (€) in a document. Typing is simple, although it varies depending on the device you are using: desktop computer, smartphone or tablet. This symbol, like others, can be obtained by a combination of keys or by selecting it from an array of secondary characters.