Quickly Change Formulas Using Find / Replace
So you have built that spreadsheet report your boss wanted. And you were all eager to use it in your presentation. But in the last minute, your boss asked you to change average sales to total sales figures (or measure growth wrt to 2006 instead of 2007). You also want to grab an espresso before rushing to the meeting. Now what?
Simple, skip the coffee. 🙁
Of course, I am kidding, who would skip coffee for a bunch of formulas ? So, we use Find / Replace to do the dirty work while we let the roasted beans restore sanity. Just press Ctrl+` (it is the key next to 1), this will enable formula view. Now press Ctrl+H and change the spreadsheet formulas or input range en masse.
What are you still waiting for? Go get that espresso!
Do you know that you can use find / replace to change spreadsheet formatting too ?
This post is part of our spreadcheats series – Learn Excel in a month.
Excel Formulas Too Confusing ? You should get Excel Formula Help E-Book
Introducing our Online Power BI Class:
Would you like to join me on a date with Power BI? In this comprehensive online class, learn all about Power BI so you can create beautiful, insightful & interactive reports. Join me and rest of the play mates for our first ever Power BI Play Date.Click here to know more and join us.
Leave a Reply
|“Too Many Worksheets” Driving You Nuts? Read This!||Google Spreadsheets Introduces Data Validation, Sweet!|