HomeApplicationOffice informationHow to display formulas and print formulas in Excel

How to display formulas and print formulas in Excel

Display formulas and print formulas in Excel so you can see the formula directly in the data cell, not see the results anymore. To be able to display and print the formula so please follow the instructions below of TipsMake.com .

How to display formulas and print formulas in Excel Picture 1

Normally when we use a formula in Excel, the results of that formula will be displayed in the data cell. When you click on that data cell you can only see the formula on the recipe tray.

But if you install based on the instructions below, instead of the results of that formula, you can see all the formulas in the Data Sheet displayed right in your data box.

We have all three possible ways to display formulas in Excel.

The first way , you can open the Formulas ribbon on the tool and then click Show Formulas in the Formula Auditing section of this ribbon.

How to display formulas and print formulas in Excel Picture 2

The second way , you need to open the File ribbon on the tool, then click on the Options tab in the File 's options list .

How to display formulas and print formulas in Excel Picture 3

The Excel Options function window will be displayed on the screen shortly after. Go to the Advanced tab of this function window.

Then scroll down to see Display options for this worksheet . You select the Sheet that you want to display the formula and then put a checkmark in front of the Show formulas in cells instead of their calcuated results . Then click OK to confirm the settings you've just given.

How to display formulas and print formulas in Excel Picture 4

The third way is to use the Ctrl + ` key combination on the keyboard.

All three methods will produce the result that the formula used in the spreadsheet is displayed directly on the data cell like the image below.

How to display formulas and print formulas in Excel Picture 5

As for printing the formulas on paper, you just need to leave the formulas in display mode on the data box and then perform the printing data in Excel.

Go to the File ribbon on the toolbar and select the Print tab in the File's list of options, or simply use the Ctrl + P key combination on the keyboard.

How to display formulas and print formulas in Excel Picture 6

You can see that the Preview in Print mode shows what will be printed on the paper, which is the formula displayed directly in the table.

How to display formulas and print formulas in Excel Picture 7

Thank you for reading our article TipsMake.com on how to display formulas and print formulas in Excel on paper. Wish you can successfully implement this tip in your document file.

5 ★ | 1 Vote

You should read it

May be interested

  • How to lock Excel Sheet, set a password for the sheet in ExcelPhoto of How to lock Excel Sheet, set a password for the sheet in Excel
    lock sheet, set password for data sheet in excel to create security for your data file, do not let anyone edit or add data. tipsmake.com will guide you how to do in our article below.
  • Instructions on how to plot stacked columns in ExcelPhoto of Instructions on how to plot stacked columns in Excel
    draw a stacked column chart in excel to represent data with images to give you a more intuitive look. in this article, tipsmake.com will guide you to create a stacked column chart in excel for an existing data table.
  • How to count the number of occurrences of a character in ExcelPhoto of How to count the number of occurrences of a character in Excel
    counting the number of occurrences of a character in excel is a trick that requires you to use a combination of two different functions. to know how to combine this function, please follow the following article of tipsmake.com us.
  • DCOUNT function in Excel - Usage and practical examplesPhoto of DCOUNT function in Excel - Usage and practical examples
    the dcounta function is one of many frequently used math functions in excel. the dcount function helps you count non-blank data cells in list columns or data arrays with defined conditions.
  • How to move rows and columns in ExcelPhoto of How to move rows and columns in Excel
    how to move rows and columns in excel. when you edit documents on excel columns and rows it may be during that process that you want to rearrange the order and position of the columns and rows. if you do not know how, you can follow the following method of tipsmake.com.
  • Common Excel functions you need to know about accountingPhoto of Common Excel functions you need to know about accounting
    mastering the common excel functions helps accountants save time and effort compared to conventional manual calculations. today, software tips will list and guide readers on how to use some functions commonly used in accounting.

Office information