Type to search

How to Unhide Rows in Excel – Here is the Ways

How to Tips

How to Unhide Rows in Excel – Here is the Ways

Share

Queries to know how to unhide rows in Excel? If you are ongoing with a data-heavy spreadsheet, seldom it is important to hide or unhide rows and columns to entirely understand the data you require to analyze, instead of removing the row. Luckily, the software of Microsoft Excel does it simply to do this.

If you need to stop users from walking into parts of a worksheet you do not need them to see, then guard such rows from their appearance. This method is often used to conceal sensible information or formulas, but you may also want to hide fresh or unimportant areas to hold your users focused on related information.

On the other side, when renewing your own sheets or exploring received workbooks, you would surely need to unhide all rows and columns to see all information and understand the dependencies. These words will guide you with both choices.

Hide Rows in Excel

As is the case with almost all general tasks in Excel, there is numerous way to hide rows like by doing the ribbon button, right-click menu, and keyboard shortcut.

Nevertheless, you start with picking the rows you would want to hide:

  • To pick 1 row, press on its heading.
  • To pick many contiguous rows, drag over the row headings using the mouse. Or pick the 1st row and hold down the Shift key while picking the last row.
  • To pick non-contiguous rows, press the heading of the 1st row and keep down the Ctrl key while pressing the headings of different rows that you need to select.

With the rows chosen, continue with a method that is listed below.

Hide rows using the ribbon

If you like going with the ribbon, you follow this:

  • Navigate to the Home tab > Cells group, and press the Format button.
  • Under Visibility, look for the hiding & Unhide option, and then choose Hide Rows.

Alternatively, you can press on the Home tab >Format > Row Height, and enter 0 in the Row Height box. Both way, the chosen rows will be hidden from view straight away.

Hide rows using the right-click Menu

In a situation you do not need to trouble to memorize the location of the Hide command on the ribbon, you can reach it from the context menu by following right-click the chosen rows and then press Hide.

Shortcut to hide row

If you don’t want to take your hands off the keyboard, you can instantly hide the picked row(s) by clicking this shortcut: Ctrl + 9.

Unhiding rows in Excel

As including hiding rows, the software of Microsoft Excel gives some ways to unhide them. Which one to use is a choice of your own favorite. What creates the variation in the field you choose to instruct Excel to unhide all hidden rows, only particular rows, or the first row in a sheet.

Unhide rows by using the ribbon

On the page Home tab, in the Cells group, press the Format button, look for hiding & Unhide following Visibility, and then press Unhide Rows.

Unhide rows using the context menu

You pick a collection of rows including the row above and below the row(s) you need to unhide, right-click the collection, and pick Unhide in the pop-up menu. This process works wonderfully for unhiding a singular hidden row as well as various rows.

For instance, to display all hidden rows within rows 1 and 8, pick this group of rows then right-click, and press Unhide.

Unhide rows with a keyboard shortcut

Here you can see the Excel Unhide Rows shortcut- Ctrl + Shift + 9. Clicking this key combination (three keys together) show any hidden rows that join the collection.

Show hidden rows by double-clicking

In various circumstances, the quickest method to unhide rows in Excel is to double click them. The advantage of this process is that you do not require to choose anything. Just hover your mouse above the hidden row headings, and when the mouse pointer changes into a split 2-headed arrow, double click. That is all you need to do.

Unhide all rows in Excel

In sequence to unhide every row on a sheet, you require to choose all rows. For this, you can either:

  • Press the Select All key (a small triangle at the upper left corner of an Excel sheet, in the crossing of the row and column headings).
  • Click the Select All shortcut: Ctrl + A

Please record that in Microsoft Excel, this shortcut performs uniquely in various situations. If the cursor is in a blank cell, the entire worksheet is chosen. But if the cursor is in one of the adjacent cells with data, only that group of cells is chosen, to choose every cell, click Ctrl+A one more time.

Once the whole sheet is chosen, you can unhide every row by doing one of the following:

  • Push Ctrl + Shift + 9 (the quickest way).
  • Choose Unhide from the right-click menu (the simplest way that does not need memorizing anything).
  • On the Home tab, press Format > Unhide Rows (the conventional way).

Unhide every cell in Excel

To unhide each row and column, pick the whole sheet, and then click Ctrl + Shift + 9 to display hidden rows and Ctrl + Shift + 0 to display hidden columns.

FAQs

Q: Why can't I unhide all rows in Excel?
A; Attempt the following: Enter the first cell reference A1 in the Name Box and click enter. On the Home page, press on the Format icon select Hide & Unhide from the appeared menu then choose Unhide Rows. You should be capable to unhide every row in between after that.
Q: How do I turn off hide and unhide in Excel?
A; Choose the sheet you need to hide and then click F4, in the Properties Window that displays, use the visible drop-down choice to select – xlSheetVeryHidden (yes very hidden!). Done – copy for other sheets.
Q: What is the shortcut key of the auto column?
A: Click one of the following keyboard shortcuts: for AutoFit column width: To AutoFit row height: Alt + H, then O, and then A. Alt + H, then O, and then I.

Conclusion

If you need to Hide Unhide Worksheet in a workbook then you may use any of the above methods rather than doing it manually. These are the very simple steps to follow.

Tags: