3 Ways to Take Advantage of Color in Google Sheets

Ben Stegner 07-03-2016

Google Sheets is a viable alternative to Microsoft Excel Excel vs. Google Sheets: Which One Is Better for You? Do you really need Excel? Both desktop and online solutions have their advantages. If you have trouble choosing between Excel and Google Sheets for managing your spreadsheets, let us help you decide. Read More , especially if you don’t need all the powerful features of the latter or frequently collaborate with others on spreadsheet files 5 Google Sheets Settings Essential for Teamwork Google Sheets has more features to support collective data input and processing than you may think. We'll introduce you to Google Sheets functions and features that are essential for group projects. Read More .


If your spreadsheets are looking bland, a little color can go a long way in sprucing them up. Besides making it more visually appealing, color can help you quickly distinguish different parts to he spreadsheet.

1. You can change the color of cell borders! Select any cell or range of cells, then use the border button (to the right of the paint can) to select which borders to insert. The pencil icon in this pop-up lets you change the border color.

2. If you have more than one sheet in a workbook, you can color-code their tabs! Just right-click a tab at the bottom of the screen and choose Change color from the menu. Using a few different colors, you could quickly see which sheets need work at a glance, or which are completed.

3. When multiple people are working on a spreadsheet, you can see each person’s changes in color! Head to File > See Revision History to see the list of changes to your workbook. Each user’s edits will appear in their own color, letting you see exactly who changed at any time.

Interested in expanding your understand of color? You can learn color theory in an hour or less How To Learn Color Theory In Less Than One Hour Basic knowledge of color theory can mean the difference between an "amateur" aesthetic and a "professional" one – and it really doesn't take long to learn. Read More today!


What other ways do you utilize color in Excel? Let us know if you found these tips useful in the comments!

Image Credit: Nomadic Photo Studio via

Related topics: Google Sheets, Spreadsheet.

Affiliate Disclosure: By buying the products we recommend, you help keep the site alive. Read more.

Whatsapp Pinterest

Leave a Reply

Your email address will not be published. Required fields are marked *

  1. Charles Reid
    November 8, 2016 at 7:07 pm

    Great article and list. I haven't heard of a lot of these.

    I've used JotForm for a little bit now and really enjoy it. They push out a lot of new features and seem to pay attention to the wants of their users.