How to Unhide Multiple Rows in Excel

How to Unhide Multiple Rows in Excel

Excel has so many functions that are useful for data organization and analysis.

It is possible to hide rows or even columns containing a specific dataset in excel, and it is also very likely to unhide rows or columns containing a particular dataset in excel.

The idea of hiding certain parts of a dataset is instrumental in real-life situations where specific data are kept private and away from a third party.

You can conceal and expose hidden rows in excel just the same way you can hide and unhide columns.

In addition to freezing rows, you may find it helpful to hide rows that you are no longer utilizing in your spreadsheet without permanently erasing the data.

You may right-click to unhide specific rows later to see the concealed cells.

You may easily unhide all concealed rows by going to the “Format” option.

If you’ve concealed several rows throughout a huge spreadsheet, this function will come in handy.

In this piece, we shall be focusing our attention on the various ways possible by which we can successfully unhide or even hide a row in the excel package.

But before we go into that, I would like to show you some of the very salient usefulness of this function in excel.

  • In data organization and particularly in representation, some detail might not be useful to a third party or beneficial as part of the content of the data. In such a case, hiding a certain row in the dataset may be applicable.
  • As explained above, sometimes, as a third-party user of an already created dataset, you may need to unearth some hidden information in it.
  • A knowledge of this function facilitates and enables thorough data analysis.

Having seen the usefulness of knowing this function in connection to data organization, let us now go on to see the various ways it can be done.

The primary aim of this piece is to show you how to unhide multiple rows in excel, but before we talk about multiple rows, let’s first look at how to unhide individual rows, which will give us more insight in later considering how to unhide various row.

Tighten your seatbelt, and let’s dive in!

Hiding and Revealing Hidden Individual Rows in Excel

  1. On your desktop or computer, click open the excel program
  2. After opening your excel program, you have your spreadsheet being displayed on your screen. Input your data into the spreadsheet and then save it.
  3. Choose the row(s) you want to conceal. By clicking on a row’s number on the spreadsheet’s left side, you may select the entire row. By clicking on a row number, holding down the “Shift” key on your PC, then picking another, you may choose several rows.
  4. In the row you have highlighted, right-click on any part, and then a drop-down menu will show up.
  5. Then you will see “hide”, click it.


In the above steps, we saw how that we can hide an individual row, now let’s see how we can unhide a separate row in excel

  1. On each side of the row, you want to unhide, highlight the row.
  2. Right-click anywhere inside the rows you’ve chosen.
  3. A drop-down menu will appear and then click on “unhide.”
  4. You may also manually extend a hidden row by clicking or dragging it. A more extensive borderline indicates hidden rows. Move your mouse over this line until a double bar with arrows appears. Double-click to expose the concealed row or rows, or click and drag to manually expand them. (If you’ve buried numerous rows, you may need to repeat this process.)

The above-outlined steps are the pathway to both hiding and then revealing hidden individual rows in excel. Let’s now go on to see how to unhide multiple rows in excel. Please follow carefully.

  1. Move to the “Home” tab to unhide all concealed rows in Excel.
  2. Pay attention to the toolbar at the right side of the tab and there click “format”
  3. When you click on “format”, a drop-down menu will appear, and then proceed to play your cursor on “hide & unhide” under visibility.
  4. When you place your cursor on “hide & unhide”, it will bring up further prompts from where you now choose to unhide row.
  5. Choose “Unhide Rows” from the drop-down menu. This will show all hidden rows, which is very useful if you have several rows buried over a big spreadsheet.

And then we have the desired result.


All through this article, we have looked at how to both hide and unhide rows in excel; first I gave a brief introduction of this beautiful function in excel as a powerful tool in the analysis of data and then went on to outline some very important use of this function on excel.

Going on further, we delved a bit deeper to look at the various steps involved in actualizing this goal.

I like you to take note of the fact that the various steps I have explained in this material can work for excel versions from 2007 to 2016.

You can apply it to any excel version. It works just the same way for all.

Getting your desired result is inevitable if you carefully follow the steps explained in this tutorial.

The only limitation that can cause problems in executing this function is the idea of human errors, if we do not highlight properly the row we want to work with, we may likely not get the result.

Excel is software; thus, the chances of it making a mistake or not successfully executing a command are slim.

As a result, in most situations, the restriction of Excel is due to the user’s fault or mistake.

It’s worth noting, however, that Excel is not case sensitive and, as a result, produces results that are directly proportional to the user’s input.

If you run into any difficulties along the way, double-check your work to see if you’ve overlooked anything.

I genuinely hope you found this article informative and instructive!

Avatar photo
Ovo is a highly specialized Computer and Networking Expert with experience in Windows, Cisco, Microsoft Office (Excel, Word, etc) and Networking engineering. Ovo is a creative, team player that loves sharing his experience with technology with readers to follow along. He has great attention to detail when discussing various technologies, tutorials and guides.