In large Microsoft Excel workbooks containing dozens of worksheets, finding the right tab among identical grey labels can slow down your workflow. Colour-coding worksheet tabs offers an efficient way to organise spreadsheets, distinguish between inputs and finished reports, group quarterly financial data, or call immediate attention to sheets that need urgent review.
Excel provides versatile tab colouring options across desktop and web versions. Here is how to change sheet tab colour in Microsoft Excel for single tabs, multiple worksheets, and custom corporate palettes.
Method 1: Change Tab Colour Using the Right-Click Menu
The quickest way to colour-code a worksheet tab is directly from the bottom navigation bar:
- Open your workbook in Microsoft Excel.
- At the bottom of the window, locate the worksheet tab you wish to colour.
- Right-click on the tab name to open the context menu.
- Hover over Tab Colour.
- Select a shade from Theme Colours or Standard Colours.
While the tab is actively selected, the colour appears as a subtle gradient accent line along the bottom border. As soon as you click onto another sheet tab, the customised tab displays its full, vibrant background colour.
Method 2: Change Tab Colour via the Ribbon
If you prefer using ribbon commands or keyboard shortcuts:
- Click the sheet tab you want to format to make it active.
- Go to the Home tab on the Excel ribbon.
- In the Cells group, click Format.
- Hover over Tab Colour and choose your desired colour.
How to Colour-Code Multiple Worksheet Tabs Simultaneously
If you need to apply the same colour to a series of related sheets (such as all monthly expense tabs):
- Consecutive Tabs: Click the first sheet tab, hold down the Shift key, and click the last tab in the series.
- Non-Consecutive Tabs: Hold down the Ctrl key and click each individual tab you want to select.
With multiple tabs selected (indicated by white tab backgrounds), right-click any of them, hover over Tab Colour, and pick your shade. All grouped sheets will update instantly.
How to Apply Custom Hex or RGB Colours
If your project requires exact company branding colours:
- Right-click the sheet tab and hover over Tab Colour.
- Click More Colours at the bottom of the palette.
- In the Colours dialogue window, switch to the Custom tab.
- Enter your exact Hex code, or adjust the Red, Green, and Blue numerical values.
- Click OK to apply the custom shade.
How to Remove a Tab Colour
To restore a worksheet tab back to Excel’s default neutral appearance:
- Right-click the coloured tab (or group of tabs).
- Hover over Tab Colour.
- Click No Colour.
The tab colour will immediately disappear without altering any cell data, gridlines, or formatting within the worksheet.