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!

5 ★ | 2 Vote

May be interested

  • How to rename, copy and move spreadsheets in ExcelPhoto of How to rename, copy and move spreadsheets in Excel
    instructions on how to rename, copy and move spreadsheets in excel. 1. how to change the name of the worksheet (sheet) in excel - method 1: + double-click the worksheet name - when the selected worksheet name is entered, enter the new name of the worksheet: + after entering the name
  • Overview of the interface in Excel 2013, 2016Photo of Overview of the interface in Excel 2013, 2016
    overview of the interface in excel 2013, 2016. the following article helps you understand the overview of the interface in excel 2013, 2016. when you open the excel interface, work as shown.
  • How to convert CAD files to Word the fastest and most standard wayPhoto of How to convert CAD files to Word the fastest and most standard way
    you are in need of converting drawings in cad files to word for printing or presentations but do not know how to transfer? how to quickly convert cad files to word, keep the best image quality, fonts, then you need to use betterwmf software - copy the image
  • Create slides from a template available in PowerPointPhoto of Create slides from a template available in PowerPoint
    the following article introduces you in detail how to create a presentation from a template available in powerpoint. step 1: open powerpoint - go to file - new - select the template available in groups
  • Create slides from an existing slide in PowerPointPhoto of Create slides from an existing slide in PowerPoint
    the following article introduces you in detail. create slides from an existing slide in powerpoint. step 1: open powerpoint - go to file - open - select the powerpoint file to apply:
  • Overview of the PowerPoint interfacePhoto of Overview of the PowerPoint interface
    introduction overview of the powerpoint interface. 1. the interface contains commands and controls. 1.1 title bar: at the top shows the name of the presentation. 1.2 ribbon: located below the title bar includes the command tags to help you create a presentation