How to change the SheetTab color and hide the worksheet in Excel

Instructions on how to change the color SheetTab and hide the worksheet display 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 -

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:

Picture 1 of How to change the SheetTab color and hide the worksheet in Excel

Step 2: After choosing the color -> sheet has a color like the picture:

Picture 2 of How to change the SheetTab color and hide the worksheet in Excel

- 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:

Picture 3 of How to change the SheetTab color and hide the worksheet in Excel

- The Colors dialog box appears, select the desired color area -> OK -> so you have created a separate color for the sheet.

Picture 4 of How to change the SheetTab color and hide the worksheet in Excel

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:

Picture 5 of How to change the SheetTab color and hide the worksheet in Excel

- Spreadsheet results have been hidden:

Picture 6 of How to change the SheetTab color and hide the worksheet in Excel

2.2 How to display spreadsheets in Excel 2013.

- Right click on any sheet -> Unhide:

Picture 7 of How to change the SheetTab color and hide the worksheet in Excel

- Unhide dialog box appears, select the sheet to display -> OK:

Picture 8 of How to change the SheetTab color and hide the worksheet in Excel

After clicking OK -> The hidden Sheet is displayed on SheetTab:

Picture 9 of How to change the SheetTab color and hide the worksheet in Excel

Above is a detailed guide on how to change the SheetTab color and hide the worksheet in Excel.

Good luck!

You've just finished reading the article "How to change the SheetTab color and hide the worksheet in Excel" edited by the TipsMake team. You can save how-to-change-the-sheettab-color-and-hide-the-worksheet-in-excel.pdf to your computer here to read later or print it out. We hope this article has provided you with many useful tech tips and tricks. You can search for similar articles on tips and guides. Thank you for reading and for following us regularly.

« PREV : How to rename, copy...
How to choose images... : NEXT »