Arrow left
Back to guides
Google Sheets Tips

How to Change Tab Color in Google Sheets

In this article, you will learn how to change tab color in Google Sheets.

Why do you change tab color in Google Sheets?

It is useful to differentiate tabs by coloring tabs in different kinds of colors. You can quickly tell what type of sheet you are working on even if you have multiple sheets in a file. We recommend that you use similar colors for a group of relevant tabs.

For example, you can color a revenue summary sheet in red and its back-data sheet in light red, and make the tab color of a cost sheet green, etc. As another example, you may have unnecessary sheets in your file but want to keep them just in case. In that case, you can make the color of those unnecessary tabs black and leave a note in the file that black tabs are not used.

With such notes and colored tabs, people can easily understand they are not in use and avoid referring the unused tabs mistakenly.

Save hours formatting your next financial spreadsheet!
100+ templates, all free to use.
Free Spreadsheet Templates

How to change tab color in Google Sheets

  • Go to the bottom of a sheet and put your cursor on a tab

  • Right-click and select “Change color” in the pop-up menu

  • Choose one of the existing colors or create a customized color

How to change tab color in Google Sheets

Level up your Google Sheets skills with our FREE LiveFlow Academy
Basic and intermediate classes live now! Earn your certificate today.
Enroll in LiveFlow Academy

How do you change the color of a Google sheet?

Do you need to know how to color cells in Google Sheets? Check the following article: How to Color Cells in Google Sheets

 

How do I change tabs in Google Sheets?

Do you want to move to another tab in the same file? Go to one of our articles: How to Switch between Tabs in Google Sheets

The world's top businesses trust LiveFlow to automate their financial reporting
We turn Quickbooks Online data into a live FP&A dashboard in Sheets FAST!
Book a Demo

Learn how to do this step-by-step in the video below 👇

Automate financial reporting with LiveFlow

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how

Need help?

Our team is here to help you any time between 9am and 10pm EST.
Check Icon
Email us at: help@liveflow.io

Liked this article? Then you'll love the ones below