February 12, 2014

How to Add Color to Sheet Tabs in Spreadsheets 2013

In Spreadsheets 2013, you can apply different tab colors to each sheet tab, or the same color to all sheet tabs of your workbook. Follow these guide to add colors to the sheet tabs.

Select sheet tabs

Step 1 Launch Spreadsheets 2013, and open an existing workbook that has more than one sheets.
Step 2 Select one or more than one sheet tabs.
. To select one sheet tab, simple click on it. 
. To select more than one tabs, hold on Ctrl and select sheet tabs (can be discontinuously).
. To select all tabs, select the first sheet tab, then hold on Shift key and select the last tab. Or, you can simply right click on one of the sheet tabs, and choose Select All Sheets.
select all sheets

Apply color to selected sheet tabs

There are two methods to apply a color to the selected sheet tab(s).
1. Right click on the sheet tab(s) and go to Tab Color, and choose a color from the color pallette.
2. Somesimes if you have selected multiple sheet tabs, right clicking might cancel the selection. In this case, you can go to Home tab (2013 Style interface) > Worksheet > Tab Color and choose a color to apply. See following:
apply sheet tab color

No comments:

Post a Comment