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 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
May be interested
- The COUNTA function, how to use the function to count cells containing data in Excelthe counta function in excel counts the number of cells containing data, non-empty cells in excel.
- How to calculate the percentage change in Pivot Table in Excelalthough the main function of a pivottable is to summarize large data, you can use them to calculate the percentage change between values.
- Use Google applications more efficiently with Google Apps Scriptwith google apps script, you can add menus, custom dialogs, write functions and macros, build add-ons for google docs, sheets and slides.
- 10 awesome PowerPoint templates make the presentation 'shine'in today's article, tipsmake.com will introduce 10 best powerpoint templates, saving you time and effort when creating presentations.
- How to insert special characters in Excelinserting special characters in excel is as simple as inserting characters in word.
- How to convert doc, docx to PDF by Cloudconvertconverting doc or docx documents to pdf is simple, increasing the security of text files.