Get better at working with Google Sheets! Join 50,000 readers to get an actionable tip in your inbox every Monday.
Sheets Tip 364: Keep track of important tabs
|
Welcome to the Google Sheets Tips newsletter #364, your Monday morning espresso, in spreadsheet form! Thanks to the hundreds of you who signed up for the Modern Google Sheets course last week. I'm excited to teach the workshops, which start next week. And thanks for your patience with the extra course promotion emails. We're now back to business as usual, with the once-a-week Google Sheets Tips newsletter. Lastly, Happy Halloween! It's a fun night here in our little town. Most of town seems to get involved, either joining the throngs of trick or treaters (especially if you have young children) or handing out the candy. It's nice to see all my neighbors, although sometimes I can't tell who I'm talking to because 1) it's dark and 2) everyone's wearing silly costumes. ➜ NewsI. II. ➜ Sheets Tip #364: Keep track of important tabsToday I'm sharing a simple trick that helps keep your tabs (sheets) organized effectively inside your Google Sheet file. If you have a lot of tabs, it can be hard to spot the one you're after because they all look the same. Here's how to make the important tabs stand out: Step 1: Add colorRight click a tab and select the "Change color" option to add a subtle color to the base of the tab. This helps, but I find it too subtle on its own. Step 2: Add a pin emoji 📌Copy and paste the pin emoji 📌 into the tab name for a surefire way to make the tab easy to find. Step 3: Move important tabs to the first positionI often also move my important tabs to the first position in my Sheet, which makes them easy to find. Now you'll never lose track of your important tabs again! If you enjoyed this newsletter, please forward it to a friend who might enjoy it. Have a spooky week! Cheers, P.S. Some Halloween CHAR formulas for you: |
Google Sheets Tips
Get better at working with Google Sheets! Join 50,000 readers to get an actionable tip in your inbox every Monday.
Hi Reader, Welcome to the Google Sheets Tips newsletter #382, your Monday morning espresso, in spreadsheet form! If you feel like the AI wave is moving faster than you can keep up with, you aren't alone. The gap between "playing with a chatbot" and "building reliable AI systems" feels wider than ever, and that feeling is only increasing with every new AI announcement. For the past couple of months, I’ve been working on a new course to help address this challenge. Next Monday, I’m opening...
Hi Reader, Welcome to the Google Sheets Tips newsletter #381, your Monday morning espresso, in spreadsheet form! Since last week, the weather in the Mid-Atlantic region has been even more volatile than that mission critical spreadsheet your non-technical boss "fixed" recently. We had a day over 80F, followed by a wild 50F drop to temps in the 30's and snow squalls. And later today, we're forecast to have a severe thunderstorm and possible tornadoes. It's threatening enough that schools in...
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #380, your Monday morning espresso, in spreadsheet form! I read something online last week (source) that really resonated with me: Joy is a competitive superpower The author gave the example of the US figure skater Alysa Liu, who rocked a huge smile on her way to a gold medal at the recent Winter Olympics. As someone who has a tendency to take things too seriously, this was a good reminder for me to smile more and...