Monday, March 21, 2005

Colouring Sheet Tabs in Excel

Lotus 1-2-3 has had coloured sheet tabs for years. However Microsoft finally added this feature (admittedly cosmetic only) in Office 2003.
To colour your sheet tabs click Format |Sheet |Tab Colour. Choose your colour and click OK.

You can colour mutiple sheet tabs at once by selecting multiple sheets first.
When a sheet is selected (active) then you cannot see the colour; however a small thin line under the sheet name shows.

For the Americans - colour is spelt the English way :)