Get better at working with Google Sheets! Join 50,000 readers to get an actionable tip in your inbox every Monday.
Sheets Tip 296: The Big (Formula) Reveal!
|
Welcome to the Google Sheets Tips newsletter #296, your Monday morning espresso, in spreadsheet form! A big thank you to this week's sponsors who help keep this newsletter free to read: _______ ➜ NewsI. Read more >> (second story) II. This story tells how the Williams F1 Racing team used a gigantic Excel spreadsheet to manage the parts list for their F1 racing cars. In preparation for the 2024 racing season however, they modernized their operations and upgraded away from spreadsheets. _______ ➜ Google Sheets Tip #296: The Big Reveal! A.k.a. how to show formulasIn this tip, we look at two methods to view formulas in our Sheets. Of course, we can always see any individual formula in the formula bar above our grid: In this case, we are looking at a CHOOSE function. But sometimes it's helpful to see multiple formulas and know where they are in our Sheet. For that, we have two techniques at our disposal: 1. Show FormulasTo show all the formulas, go to the menu: View > Show > Formulas or use the shortcut Ctrl + ` In our Sheet, all the formulas will now show up (you might need to resize the cells to see them fully): To return to the results, uncheck Formulas in the View menu again. Easy! 2. Show Formulas with the FORMULATEXT functionIn addition to the menu option, we have a function dedicated to revealing formulas! Suppose you have a formula in cell C2, then use this formula to reveal that formula: =FORMULATEXT(C2) In our Sheet, it looks something like this: The nice thing about FORMULATEXT is that we can combine it with other formulas. For example, we can add a checkbox to cell D1 and an IF statement to toggle the formula views on/off! The formula in cell D2 in this example is: =IF( $D$1 , FORMULATEXT(C2) , ) Happy Formula Auditing! _______ If you enjoyed this newsletter, please forward it to a friend who might enjoy it. Have a great week! Cheers, |
Google Sheets Tips
by Ben Collins
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 this anniversary edition of the Google Sheets Tips newsletter, your Monday morning espresso, in spreadsheet form. This is the 300th edition of this weekly newsletter! 🎉 I've been sending it out for six years. The first issue — about keyboard shortcuts — was sent on 30 April 2018 to 2,357 of you. (Huge shout-out to anyone who's still with me!) In honor of this milestone, I want to look back at the six-year journey: The newsletter began life as the "Monday Tip" newsletter,...
Hi Reader, Welcome to the Google Sheets Tips newsletter #299, your Monday morning espresso, in spreadsheet form! A big thank you to this week's sponsors who help keep this newsletter free to read: SHORTFORM Raising the Bar on Book Summaries With Shortform, you get deep insights that go beyond the typical 1-pager, with chapter breakdowns, well-researched commentary and analysis, connections to other books and counter-arguments, and even interactive exercises. Instead of spending days on a...
Hi Reader, Welcome to the Google Sheets Tips newsletter #298, your Monday morning espresso, in spreadsheet form! I hope you are doing well on this fabulous Monday morning. As an adult, it's rare to experience something completely new in day-to-day life. Days follow a familiar pattern, even if the specifics are different. Last week, however, the New York region was hit by a rare earthquake (thankfully, not too serious). I happened to be in Legoland New York with my family, in the gift shop,...