How to change the SheetTab color and hide the worksheet in Excel
The following article will guide you in detail how to change the SheetTab color and hide the workbook in Excel.
SheetTab is where the names of the sheets are displayed so you need to color them to distinguish them better.
1. How to change the color of SheetTab in Excel.
Step 1: Right-click the name of the Sheet to change color -> Tab Color -> select the color to create:
How to change the SheetTab color and hide the worksheet in Excel Picture 1
Step 2: After choosing the color -> sheet has a color like the picture:
How to change the SheetTab color and hide the worksheet in Excel Picture 2
- In case you want to create a separate color you do the following: Right-click the sheet name to change color -> Tab Color -> More Colors:
How to change the SheetTab color and hide the worksheet in Excel Picture 3
- The Colors dialog box appears, select the desired color area -> OK -> so you have created a separate color for the sheet.
How to change the SheetTab color and hide the worksheet in Excel Picture 4
2. How to hide the workbook in Excel 2013.
2.1 How to hide spreadsheets in Excel.
- Right-click the name of the worksheet you want to hide -> Hide:
How to change the SheetTab color and hide the worksheet in Excel Picture 5
- Spreadsheet results have been hidden:
How to change the SheetTab color and hide the worksheet in Excel Picture 6
2.2 How to display spreadsheets in Excel 2013.
- Right click on any sheet -> Unhide:
How to change the SheetTab color and hide the worksheet in Excel Picture 7
- Unhide dialog box appears, select the sheet to display -> OK:
How to change the SheetTab color and hide the worksheet in Excel Picture 8
After clicking OK -> The hidden Sheet is displayed on SheetTab:
How to change the SheetTab color and hide the worksheet in Excel Picture 9
Above is a detailed guide on how to change the SheetTab color and hide the worksheet in Excel.
Good luck!
You should read it
- How to change spreadsheet color lines in Excel
- How to rename, copy and move spreadsheets in Excel
- What is a worksheet? Differentiate between Worksheet and Workbook
- Change the slash to a dot in Excel format
- Tip Hide professional Excel spreadsheets
- How to hide and hide sheets in Excel and show them again
- Types of data hiding in Excel - Hide pictures, graphs, rows, columns
- How to change gridlines color in Excel?
- Instructions to change the cell background color (Cell) in Excel
- Change color between different lines in Microsoft Excel
- Lock one or more data columns on Excel worksheet - Freeze data in Excel
- The easiest way to Hide rows in Excel
May be interested
How to rename, copy and move spreadsheets in Excel
Overview of the interface in Excel 2013, 2016
How to convert CAD files to Word the fastest and most standard way
Create slides from a template available in PowerPoint
Create slides from an existing slide in PowerPoint
Overview of the PowerPoint interface