How to hide and hide sheets in Excel and show them again

Hide sheets in Excel makes Excel spreadsheets easier to see, and more to work on content on a sheet.

In an Excel file, multiple sheets can be created, helping to check the content between sheets faster than creating multiple Excel files. However, Excel files with multiple sheets are sometimes confusing for users, so you should hide the sheets that are not working. When hiding those sheets, it is easy to focus on the content of the working sheet. You do not need to delete the sheet but only hide the sheet and the content remains. Displaying the sheet again is as simple as when we hide the sheet. The following article will show you how to hide sheets on different versions of Excel.

  1. How to create a password protection for Excel sheets
  2. MS Excel - Lesson 4: Working with lines, columns, sheets
  3. How to separate sheets into separate Excel files
  4. Ways to hide data on Excel

1. Hide and show sheets in Excel 2003

Step 1:

First, the user opens the Excel file tab to hide the sheet. For example, Excel file with 3 sheets as shown, proceed to hide sheet 1.

How to hide and hide sheets in Excel and show them again Picture 1How to hide and hide sheets in Excel and show them again Picture 1

Then click on the sheet you want to hide then click the Format tab above the toolbar, choose to continue to Sheet. Click on Hide to hide the sheet.

How to hide and hide sheets in Excel and show them again Picture 2How to hide and hide sheets in Excel and show them again Picture 2

Sheet 1 results have been hidden in the Excel file interface.

How to hide and hide sheets in Excel and show them again Picture 3How to hide and hide sheets in Excel and show them again Picture 3

Step 2:

To display the hidden sheet in the Excel file, we also click on the Format tab and select Sheet and click Unhide .

How to hide and hide sheets in Excel and show them again Picture 4How to hide and hide sheets in Excel and show them again Picture 4

Then display the Unhide window interface with the hidden sheets if you hide many sheets, click on the sheet you want to display again and click OK.

How to hide and hide sheets in Excel and show them again Picture 5How to hide and hide sheets in Excel and show them again Picture 5

Sheet 1 results are displayed again in Excel file.

How to hide and hide sheets in Excel and show them again Picture 6How to hide and hide sheets in Excel and show them again Picture 6

2. Hide and show sheets in Excel 2007 or later

Step 1:

At the interface on Excel users also click on the sheet they want to hide and then select Hide .

How to hide and hide sheets in Excel and show them again Picture 7How to hide and hide sheets in Excel and show them again Picture 7

As a result, we also see that sheet 1 has been hidden in the Excel interface.

How to hide and hide sheets in Excel and show them again Picture 8How to hide and hide sheets in Excel and show them again Picture 8

Step 2:

To display the hidden sheet again, just click on any sheet and press Unhide .

How to hide and hide sheets in Excel and show them again Picture 9How to hide and hide sheets in Excel and show them again Picture 9

Also show the interface panel with hidden sheets, click on the sheet to display again and click OK to display.

How to hide and hide sheets in Excel and show them again Picture 10How to hide and hide sheets in Excel and show them again Picture 10

In addition to the above, you can also click on the Home tab and then select Format, then also select Hide or Unhide to hide or show sheets in Excel.

How to hide and hide sheets in Excel and show them again Picture 11How to hide and hide sheets in Excel and show them again Picture 11

3. How to hide, show sheeet Excel 2016 and above

Step 1:

In the Excel file interface, also click on the sheet you want to hide and select Hide .

How to hide and hide sheets in Excel and show them again Picture 12How to hide and hide sheets in Excel and show them again Picture 12

The results of the sheets that have been clicked Hide are hidden in the Excel file, here hide sheet 1 and sheet 2.

How to hide and hide sheets in Excel and show them again Picture 13How to hide and hide sheets in Excel and show them again Picture 13

Step 2:

If you want to show the hidden sheet in Excel, click on any sheet and select Unhide .

How to hide and hide sheets in Excel and show them again Picture 14How to hide and hide sheets in Excel and show them again Picture 14

Show the interface of hidden sheets. Click on the sheet you want to display again and press Ok to finish.

How to hide and hide sheets in Excel and show them again Picture 15How to hide and hide sheets in Excel and show them again Picture 15

Similarly to Excel versions, in Excel 2016 or later, you can click Format and then select Hide or Unhide for sheets in Excel.

How to hide and hide sheets in Excel and show them again Picture 16How to hide and hide sheets in Excel and show them again Picture 16

Above are detailed operations to hide or re-display sheets on different versions of Excel. You can click directly on the tab to process or through the Format section to choose whether to hide or show Excel sheets.

I wish you all success!

3.5 ★ | 2 Vote