Quickly Change Formulas Using Find / Replace
So you have built that spreadsheet report your boss wanted. And you are all geared up to use it in your presentation. But in the last minute, your boss asks you to change average sales to total sales figures (or measure growth wrt to 2018 instead of 2017). 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 quick tips series – Learn more Excel quick tips.
Excel Formulas Too Confusing ? You should join Excel School.
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« Quickly change charts from one to another with this trick||Employee Turnover Dashboard – Power BI for HR »|