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.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiN31w-n1BoR3rdEOwH8X5EIjUDXmAVPGrmyZfvSqyJbq4joOkJXvm5vbgKcVG9jwDGPLahOgC2i4Idspu4TV0WowvOg6fviU0j7KQWmf7G19mp3z1NyJCYJfAvyBWarvW6zWgVcGh1MwE/s400/Sheet+tab.png)
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.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfqnIprGtFk6MglyF3muGmLbD1pSoQ3_UzZp8LNWDLWZ2fQ6H4nDMS-kE8k8-DLLxSJu_8Il1dUgNdr6HwGMl2x3b74ZtdcAdUbJGzJx23ty46s8K0t25TkZTwsav2jMtAgZI2c_Ce-vo/s400/Change+the+tab+color+of+the+worksheet+in+Excel+2007.png)
0 comments:
Post a Comment