Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.
Display Or Hide Formulas. You can control the display of formulas in the following ways. The tilde accent grave key appears on the top left of most keyboards below the Esc key.
Many Excel users do not use the Formula bar but need more screen space see how to collapse the Ribbon to get more space on the screen and hide spreadsheet tabs. Toggling the Show Formulas option in Excel. When you need to review the formulas in your spreadsheet you can switch to displaying formulas instead of their results on your spreadsheet with keyboard sh.
A pop window should appear with a number of tabs.
You can press Ctrl1 or on the Home tab click Format Format Cells. Toggling the Show Formulas option in Excel. Many Excel users do not use the Formula bar but need more screen space see how to collapse the Ribbon to get more space on the screen and hide spreadsheet tabs. Here we are going to.