Xóa Unhide Trong Excel / TOP 9 # Xem Nhiều Nhất & Mới Nhất 2/2023 # Top View

Download Article

Download Article

Unhiding a Specific Row

Find the hidden row. Look at the row numbers on the left side of the document as you scroll down; if you see a skip in numbers (e.g., row 23 is directly above row 25), the row in between the numbers is hidden (in 23 and 25 example, row 24 would be hidden). You should also see a double line between the two row numbers.

It’s in the drop-down menu. Doing so will prompt the hidden row to appear.

Unhide a range of rows. If you notice that several rows are missing, you can unhide all of the rows by doing the following:

This tab is just below the green ribbon at the top of the Excel window.

If you’re already on the Home tab, skip this step.

This option is in the “Cells” section of the toolbar near the top-right of the Excel window. A drop-down menu will appear.

You’ll find this option in the Format drop-down menu. Selecting it prompts a pop-out menu to appear.

Adjusting Row Height

This tab is just below the green ribbon at the top of the Excel window.

If you’re already on the Home tab, skip this step.

This option is in the “Cells” section of the toolbar near the top-right of the Excel window. A drop-down menu will appear.

It’s in the drop-down menu. This will open a pop-up window with a blank text field in it.

Enter the default row height. Type 14.4 into the pop-up window’s text field.

Community Q&A

Add New Question

The top 7 rows of my Excel worksheet have disappeared. I’ve tried to “unhide” from the Format menu, but nothing happens. What do I do?

You’ll have to unlock the cells (via the format pop-up), then hide them all before unhiding them.

There is a possibility you did not hide the rows but reduced your rows’ height to minimum. Select all rows above and below of your 7 rows and increase rows height from format menu. It will re-adjust the height of rows and your rows will be visible.

This article was written by Jack Lloyd. Jack Lloyd is a Technology Writer and Editor for wikiHow. He has over two years of experience writing and editing technology-related articles. He is technology enthusiast and an English teacher. This article has been viewed 309,392 times.

How helpful is this?

Updated: November 17, 2020

Thanks to all authors for creating a page that has been read 309,392 times.

Robert Theriault

“I had some rows hidden and couldn’t figure out how to unhide the rows. The article solved that problem for me. Thanks” …” more

What to Know

This article explains how to hide and unhide worksheets using the contextual menu and the ribbon in Excel for Microsoft 365, Excel 2019, 2016, 2013, and 2010. 

Data Use in Hidden Worksheets

By default, all open Excel workbooks display worksheet tabs on the taskbar at the bottom of the screen, but you can hide or display them as needed. At least one worksheet must be visible at all times.

Hiding worksheets doesn’t mean you’re deleting them, and you can still reference them in formulas and charts located on other worksheets or other workbooks.

Hide Worksheets Using the Contextual Menu

If the Hide option is inactive or grayed out, most likely, the current workbook has only one worksheet. Excel deactivates the Hide option for single-sheet workbooks because there must always be at least one visible sheet.

How to Hide a Single Worksheet

How to Hide Multiple Worksheets

Press and hold down the Ctrl key on the keyboard.

Hide Worksheets Using the Ribbon

Excel has no keyboard shortcut for hiding worksheets, but you can use the ribbon bar to accomplish the same task.

Select one or more worksheet tabs at the bottom of an Excel file.

Select Format in the Cells group.

Select Hide Sheet.

Unhide Worksheets Using the Contextual Menu

You can unhide tabs using the contextual menu, just as you can hide them.

Unhide Worksheets Using the Ribbon

As with hiding worksheets, Excel has no keyboard shortcut for unhiding a sheet, but you can still use the ribbon.

Select one or more worksheet tabs at the bottom of the Excel file.

Select Format.

Select Unhide Sheet.

How to unhide all worksheets & sheets in Excel?

This article provides several methods to unhide all hidden sheets & worksheets in Excel step by step.

Unhide all hidden worksheets one by one in Excel

Unhide all hidden worksheets by VBA code

Unhide all hidden worksheets by Toggle Hidden Worksheets Visibility feature

Unhide all very hidden worksheets by Kutools for Excel

Unhide all hidden worksheets one by one in Excel

We can apply the Unhide Sheet feature to unhide a hidden worksheet at a time in Excel. Please do as follows:

3. Then the selected hidden sheet is displayed. Repeat above Step 2 to show all unhide worksheets one by one.

Kutools for Excel – Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required!

Unhide all hidden worksheets by VBA code

The following short VBA code also can help you display all of the hidden sheets at the same time.

1. Hold down the Alt + F11 keys in Excel, and it opens the Microsoft Visual Basic for Applications window.

Sub UnhideAllSheets() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets ws.Visible = xlSheetVisible Next ws End Sub

3. Press the F5 key to run this macro. And the hidden sheets will be displayed at once.

Kutools for Excel – Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required!

Then all hidden sheets are shown at once. See screenshot:

Unhide all hidden worksheets by Toggle Hidden Worksheets Visibility feature

Kutools for Excel – Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required!

Unhide all very hidden worksheets by Kutools for Excel

Sometimes above methods cannot unhide the hidden worksheets. That’s because these worksheets are very hidden. In this situation, you can apply the Hide/Unhide Workbooks and Sheets feature of Kutools for Excel to quickly unhide them.

Kutools for Excel – Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required!

Now all hidden worksheets including the very hidden ones are displaying in bulk. Please close the dialog as you need.

Hide/Unhide Workbooks and Sheets hide or unhide multiple opening workbooks and their worksheets in bulk, including the very hidden ones. Have a Free Trial!

Kutools for Excel includes more than 300 handy tools for Excel, free to try without limitation in 30 days.Download and Free Trial Now!

Related articles

The Best Office Productivity Tools

Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails…

More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.

Open and create multiple documents in new tabs of the same window, rather than in new windows.

Unhiding Excel sheets is easy, but can be tedious. Use this simple macro to unhide all hidden sheets in an Excel workbook.

We hide sheets for many reasons, but mostly, to keep other people out of them. We rarely hide them from ourselves. When you need to update or fix a workbook for a user, you have to remember the hidden sheets and then unhide them – which is easy enough, unless you removed that functionality from the workbook!

Doing this several times to unhide all hidden sheets isn’t necessary. Here’s a quick macro that you can copy into almost any workbook to quickly unhide sheets:

Sub UnhideAllSheets()

‘Unhide all sheets in workbook.

Dim ws As Worksheet

For Each ws In ActiveWorkbook.Worksheets

ws.Visible = xlSheetVisible

Next ws

End Sub

In a nutshell, a For Each loop cycles through all the sheets in the Worksheets collection and sets each sheet’s Visible property to true. This macro will even unhide sheets you hide via the Visual Basic Editor properties (xlSheetVeryHidden) so be careful how you apply it.

Like most macros, this one has limited appeal. If you have only a few hidden sheets and you seldom need to unhide them, it’s just as easy to manually unhide them. If, on the other hand, this is a frequent task, you’ll probably find this one useful.

It’s a good demonstration of how easy it is to cycle through an object collection. You could add an If() statement that checks for the Visible property and then change only the ones that require it, but this loop is more efficient. Just reset them all; in this case, an If() just adds more work. However, if you want to avoid unhiding certain sheets or the “very hidden” sheets, an If() statement will do the trick.