How to hide and hide sheets in Excel and show them again
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.
- How to create a password protection for Excel sheets
- MS Excel - Lesson 4: Working with lines, columns, sheets
- How to separate sheets into separate Excel files
- 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.
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.
Sheet 1 results have been hidden in the Excel file interface.
Step 2:
To display the hidden sheet in the Excel file, we also click on the Format tab and select Sheet and click Unhide .
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.
Sheet 1 results are displayed again in Excel file.
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 .
As a result, we also see that sheet 1 has been hidden in the Excel interface.
Step 2:
To display the hidden sheet again, just click on any sheet and press Unhide .
Also show the interface panel with hidden sheets, click on the sheet to display again and click OK to display.
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.
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 .
The results of the sheets that have been clicked Hide are hidden in the Excel file, here hide sheet 1 and sheet 2.
Step 2:
If you want to show the hidden sheet in Excel, click on any sheet and select Unhide .
Show the interface of hidden sheets. Click on the sheet you want to display again and press Ok to finish.
Similarly to Excel versions, in Excel 2016 or later, you can click Format and then select Hide or Unhide for sheets in Excel.
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!
You should read it
- How to display sheet tabs in Excel
- How to hide the Sheet Tabs (sheet bar) in Excel
- How to hide and show Sheet in Excel
- How to create a password protection for Excel sheets
- Part 4: Hide Sheet, Sheet tab, Scroll Bar, Workbook
- Show Sheet Tab in Excel when hidden
- Recover deleted Sheet in Excel
- Shortcut switch Sheet in Excel
- How to lock Excel Sheet, set a password for the sheet in Excel
- How to separate sheets into separate Excel files
- How to Unprotect an Excel Sheet
- How to copy sheet from Excel file to another Excel file