You probably already know how to display the formulas in cells rather than the results of those formulas, right? If you're like most people, you follow these steps:
Figure 1. The Display Options for a worksheet.
A much faster way to get the same result is to simply press Ctrl+`. (That's hold down the Ctrl key while you press the accent grave, which is the backwards apostrophe just to the left of the 1 key and above the Tab key.) The shortcut is a toggle, which means that you can press it repeatedly to switch between the display of formulas and results.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (6198) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and Excel in Microsoft 365. You can find a version of this tip for the older menu interface of Excel here: Shortcut for Viewing Formulas.
Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!
Summing data is a common need in Excel. Summing lots of data based on a condition that needs to be met can be a bit more ...
Discover MoreWhen you are getting the hang of how to put together formulas in Excel, you might run into a situation where you open a ...
Discover MoreWhen analyzing data, you may have a need to calculate a sum based on just part of a particular cell. This tip examines ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2021-05-11 05:25:33
Peter
I like the options for invoking formulas quickly, but I am not a fan of the all or nothing mode of operation.
I have recently discovered =FORMULATEXT(), which gives me the ability to review formulae and calculated results at the same time.
2021-05-10 07:52:36
Russell Stainer
Another way to do it, is to go to the 'Formulas' tab in the ribbon, go to the 'Formula Auditing' group, and toggle 'Show Formulas'. If you right-click it, you can also add it to the Quick Access Toolbar.
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2022 Sharon Parq Associates, Inc.
Comments