Hello Tiller Community! I have a spreadsheet tip for you.. color coding your sheet tabs!
Your favorite sheet tabs are easier to locate if they have a little color to them.
Whether you use Google Sheets™ or Microsoft Excel™ you can easily change the tab color by right clicking on the tab.
In Google Sheets, choose “Change color” and select the color that helps you quickly identify your frequently used sheet. Sheets adds a line of color below the tab name.
Similarly in Excel, right click to select “Tab Color.” Excel will shade the entire tab your color of choice.
What color do you use for your Transactions tab in the Tiller Foundations sheet?
6 Likes
I do something very similar. I have enough sheets that I primarily use the menu to the left of the tabs.
I color code the sheet tabs by their function. For example, the first tab is Transactions, colored blue. Then I have an empty tab called [Reports], after which all sheets that generate some sort of report (monthly analysis, category tracker, etc) are located, colored green. Then an empty tab called [Tools] followed by sheets that I use to feed data into others (like Paycheck Deduction Transaction Generator), then [Experimental]–things I’m trying out), [Data]–sheets that primarily hold data and don’t require much interaction (Categories, Accounts, Balance History), [Notes]–where I track any changes to the setup, reminders for monthly/semi-annual/annual/etc manual actions I need to take, and [Archive]–old copies of data that I don’t want to get rid of just yet, or sheets that I have stopped using and will eventually get rid of.
5 Likes
I use this feature!
My transactions sheet is i believe the same blue as the header bar and then my budgeting sheets are green because hopefully I’m in the green lol. Net worth sheets are yellow, credit card sheets are purple, lastly bills and debt sheets are red . It definitely provides easier navigation.
1 Like
I love using tab colors + the “pancake” menu to the left of the tabs as well (also called the All Sheets menu)
I have so many sheets now, even that menu requires some scrolling. Short-cut keys can help if you like to type rather than reach for the mouse. Try Command+J (or Ctrl+J for Windows) to get to the Named Range box, and type the sheet name:
3 Likes
Great system @tcw1138 !! Also a great tip to use the 3 lines menu. When it was 4 lines I would call it the “Big Mac” … but now Google changed it down to 3.
Oooh @brettanicus, that is a fantastic time saving tip! Thank you for this.
What a fantastic idea! Thank you for sharing!
1 Like
Great tips here! @brettanicus that’s REALLY handy! 
1 Like
It’s a simple trick, but really helpful! Glad you like it @shersocks
