USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
On the PAGE LAYOUT tab, in the Themes group, select Colors.
|
|
|
Right-click the tab and select Tab Color.
|
|
|
Use the Fill Color tool on the HOME tab.
|
|
|
You cannot change the color of a worksheet tab.
|
Detailed explanation-1: -To change the color of a sheet tab, right-click the tab, point to Tab Color and pick a color that you want. Tip: Click away from the formatted tab to see the new tab color. If you want to remove the color, right-click the tab, point to Tab Color, and pick No Color.
Detailed explanation-2: -Simply hold down the Ctrl key and press either the Page Up or Page Down key to move to the previous or next sheet, respectively. You can also use the Ctrl + Arrow keys to move between sheets. Another great shortcut for quickly changing sheets in Excel is Ctrl + Tab.
Detailed explanation-3: -Click the “Home” tab in the Ribbon. Then click the “Format” button in the “Cells” button group. Then roll your mouse pointer down to the “Tab Color” command. In the side menu that appears, then click the color you want to apply to the worksheet tab.
Detailed explanation-4: -To add a color to a worksheet tab select (Format > Sheet > Tab Color) or use the worksheet tab shortcut menu.