Think of showing formulas as a way of proving to your math teacher how you came up with your answer. If your work is ever being audited, now you can show the proof behind the math. This will serve you well if you are ever being audited or need to show your work. Spreadsheets can have hundreds of thousands of rows, and sometimes you want to be able to see the math and formula behind the numbers. It couldn’t get much easier than that! Benefits of Showing Formulas You never even have to take your hands off the keyboard and you can easily show all the formulas you want in Microsoft Excel.
![showing fractions in microsoft word showing fractions in microsoft word](https://i0.wp.com/howtotypeanything.com/wp-content/uploads/2021/03/Insert-fraction-symbol-5.png)
You can also click and highlight multiple cells at once if you are looking to show a formula in more than one cell in Excel. All you need to do is click in the cell where you want to show a formula and use that shortcut. There is more than one way to show formulas in Microsoft Excel, and if you prefer to use keyboard shortcuts than use mouse clicks, you can also use “CNTRL ~” as a way to show formulas. You can show the formula in one cell or across the entire spreadsheet if you desire. Clicking Show Formulas will show all the formulas, which will help you validate your calculations, ensuring there are no miscalculations. The Formula auditing group is up on the top of your spreadsheet in the header row. Use Show Formulas, which is under the Formulas tab under the Formula auditing group. This will allow you to display the logic you are looking for. How can you easily view calculations so you can audit them? Use a simple SUM function to show all the information you want. Save time in Excel by displaying formulas
#SHOWING FRACTIONS IN MICROSOFT WORD HOW TO#
Building in formulas is one of the best features of Excel, so you might as well know how to showcase them! Once you learn how to show formulas in Excel, it’s a skill that is so easy you’ll never forget it. There are just a few steps to follow if you need to show your formulas while using Microsoft Excel. But, other times you might want to show your work and show the formulas you used in your calculations.
![showing fractions in microsoft word showing fractions in microsoft word](https://authorservices.wiley.com/asset/photos/book-author.html/Mathtype2.jpg)
Sometimes, you want a clean spreadsheet just showing the numbers and the answers. It can be used to perform simple math equations, or you can build complicated multi-tab spreadsheets that show every math and dollar amount you can imagine. Microsoft Excel is one of the best computer tools available today.