Clearing the tab colour

I use colours on my sheet tabs to signify different things.

To clear a colour, you can use the following keyboard shortcut

Alt h o t n

Pressed in sequence, not held down.

Related Posts


Show Sheet Tabs

If you find the sheet tabs are missing at the bottom of the screen, you can fix the issue with the setting below.

To access this screen press, in sequence (not held down)

Alt t o a

and scroll down about half way.

show sheet tabs

Clearing Filters

The keyboard shortcut to clear all filters is pretty straight forward

Alt a c

Keys are pressed in sequence, not held down.


Some people regard discipline as a chore. For me, it is a kind of order that sets me free to fly.

Julie Andrews (1934 – )