Topics

Feb 6, 2011

Change the tab color of the worksheet in Excel 2007

Microsoft Excel provides the option of coloring the worksheet tab. You do this to identify the worksheets that have identical or meaningful information that suits your needs. You can also select multiple worksheets and apply the tab color at the same time. To select multiple worksheets do the following:
Selecting all worksheets: Right click on the sheet tab and click Select All Sheets.
Selecting adjacent worksheets: Click on a worksheet and then press the Shift key. Keep the Shift key in pressed state, click to select the last worksheet.
Selecting non-adjacent worksheets: Click on a worksheet and then press the Ctrl key. Keep the Ctrl key in pressed state, click to select other worksheets.
Once the selection of the worksheets is over, perform the following steps to color a worksheet tab:
1. Open Microsoft Excel and open the workbook for which you need to color the worksheet tab.
2. Click the worksheet that needs the tab coloring.
3. From the Home tab, in the Cells group click Format and point to Tab Color and select a color.

You can also right click on the worksheet tab and point to Tab Color and make a color selection.

0 comments:

Post a Comment