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.

How to change tab color in Google Sheets

  1. Go to the bottom of a sheet and put your cursor on a tab
  2. Right-click and select “Change color” in the pop-up menu
  3. Choose one of the existing colors or create a customized color
How to change tab color in Google Sheets

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

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