How do you display formulas instead of results in Excel?

To display formulas instead of their results in Excel, pressing Ctrl + ` (grave accent) is the method that toggles the display of formulas on and off. This keyboard shortcut allows users to quickly switch between viewing the actual formulas entered into cells and the results calculated by those formulas. It provides a convenient way for users to inspect their spreadsheet formulas without having to navigate through the menu options or alter settings.

The option involving the "Show Formulas" feature from the Formulas tab also allows users to achieve the same outcome; however, using the keyboard shortcut is typically faster and more efficient for those who frequently need to check their formulas. Additionally, using Alt + F11 opens the Visual Basic for Applications (VBA) editor, which is unrelated to displaying formulas in the worksheet. The "Formula View" option in the View menu is not a standard feature available in Excel, as most formula viewing options are found under the Formulas tab. Therefore, the keyboard shortcut is recognized as a direct and effective method specifically tailored for this function.