![shortcut to save as excel shortcut to save as excel](https://static.javatpoint.com/ms/excel/images/excel-save-as-shortcut6.png)
If you ask me, my favorite one is the keyboard shortcut but I also like to use power query sometimes. Sometimes using complex and large formulas make your workbook heavy in size, so it’s better to convert them into absolute values before sharing them with others.Īnd all the methods which we have discussed above can help you in different situations. Related: Excel Power Query Tutorial Conclusion By using this way you don’t need to copy-paste data every time. The best part is when you make any changes in your formula table you just need to refresh the power query table. Here you have a long formula to clean a text value and then convert it into the proper case. Let’s think differently. You have a complex formula which is a combination of two or three functions. Here I have mentioned a simple VBA code where you just need to select the range of the cells and run this macro. If you want to automatically convert all the formulas into text or numeric values then you can use VBA for that.
Shortcut to save as excel code#
Convert Formulas into Values with a VBA Code This will instantly convert all the formulas from those cells into static result values.
Shortcut to save as excel update#
Some functions are volatile and when you update your worksheet their value will recalculate.If you are sending a report to someone without its source data then it’s better to convert all the formulas into static values.Here are some reasons why you need to replace a formula with its result value.
![shortcut to save as excel shortcut to save as excel](https://i1.wp.com/www.howtoexcel.org/wp-content/uploads/2017/02/7-Keyboard-Shortcuts-For-File-Menu-Commands.png)
Why You Should Convert a Formula to Value Let me tell you some of the interesting ways to do this but before that. Just think this way, when you send a report to someone, they are not concerned with formulas but with the values, a formula returns. It simply means to replace a formula with its result value. From the starting days of my job, I have learned one thing hard way:īefore sending a report (In Excel) to someone we must convert a formula to value.