Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Formula results are shown in worksheet cells, while formulas are visible in the formula bar only so that they won’t appear when you print. Showing formulas in the cells makes it easy to find cells that contain formulas, or to check for errors.

With a quick key combination you can see formulas instead of formula results in a worksheet.

Formulas visible in an Excel worksheet

To show formulas in all cells press CTRL+` (that little mark is the grave accent mark key). When the formulas are visible, print your worksheet as you normally would.

To switch back to showing formula results in all cells, press CTRL+` again.

Tip: If you’re having trouble finding the grave accent mark key (`), it is often located in the upper left corner on keyboards, but not always. If it’s difficult to find on your keyboard, you can also show and hide formulas by going to the Formulas tab and then clicking Show Formulas. To switch back to the standard view, click the button again.

The formula only appears in the formula bar Button image while the results appear in the workbook cells in Excel for the web. But you can do a screen capture or copy and paste the formulas to an application like Notepad and then print them.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×