Microsoft Office Excel is a database application which is most widely used for keeping data in offices and organizations. It is the first thing which would come in anybody’s mind when one has to keep some data in tabular format and may or may not perform some analysis on it. Files which get created in Microsoft Excel are called as workbooks and each workbook can have multiple worksheets in it. Worksheets are like pages in any document file, which separate different between different sets of data. For example we can have one file for keeping date of birth of students of every class in your school and you can have multiple worksheets for individual classes. Worksheets are though different entities altogether but the data saved in them can be used in any other worksheet or at times by any other workbook as well. Depending upon the purpose and need of the file the number of worksheets may increase. By default there are 3 worksheets available in a new workbook and this default number can be changed by making alterations in the options of Microsoft Excel. Different sheets can be accessed by the small tabs which are present on the bottom left corner of the excel window. These sheets are by default named as Sheet1, Sheet2, Sheet3 and so on but the names of these sheets can be changed for better understanding and reviewing. Renaming of these sheets can be easily done by right clicking on the sheet tab and then selecting Rename. Renaming sheet is a good idea but if you have to categorize some sheets together then you can even use some colors for these tabs. For example in the same school scenario we can color all the tabs containing personal information in Blue and we can color all the sheets containing academic information in Red. In this post now we will discuss how to change the color of worksheet tabs in Microsoft Excel.
Steps for coloring the worksheet tabs in excel are as follows:
Step1: Open the Workbook in which you want to do the same.
Step 2: Click on the tab which you want to color. If you want to give same color to multiple tabs then press the CTRL key while you make the selection of the tabs. This will allow you to select multiple tabs at the same time.
Step 3: Once you have selected the tabs then right click on the tab or on the selection of tabs and then click on Tab Color option in the context menu.
Step 4: This action will present you a small window displaying the default color palette from which you can select a color. If you want more color choices then click on the more color button where you can create your own custom colors.
Step 5: After you get the color of your choice select it and click on OK to close all the color windows.
By following the steps given above you can easily color the worksheet tabs in any Microsoft Excel Workbook.