In day-to-day uses, users need to show excel formulas when printing. Showing formulas in print may be the result of various users’ requirements. Placing **Apostrophe**, **Show Formula,** and **Find and Replace** feature, Enabling **Advanced Options**, as well as **VBA** custom function, allow Excel to show formulas.

Let’s say we have a dataset that is made of our daily shopping items. We buy products on a certain date and calculate the total cost as depicted in the following image.

In this article, we describe ways to show Excel formulas when printing.

**Table of Contents**hide

**Download Excel Workbook**

**How to Print an Excel Worksheet or Workbook?**

🔺 A simple keyboard command (i.e., **CTRL+P**) or selecting the **File** ribbon > **Print** takes you to the Excel **Print** Menu.

Excel offers multiple options in its **Print** menu. You can choose your **Printer** using the drop-down list under the **Printer **section. You can change options under the **Settings** section such as printing options (i.e., **Print Active Sheets**, **Print Entire Workbook**, **Print Selection**), number of print **Pages**, **Page Orientations**, etc.

🔺 After selecting all your necessary requirements in options, click on the **Print** icon to print the worksheet, workbook, or selection.

**5 Easy Ways to Show Excel Formulas When Printing**

**Method 1: Placing an Apostrophe to Show Formulas When Printing**

Placing an **Apostrophe** (i.e., **‘**) in front of a formula converts the inserted formula to text. We can use an **Apostrophe** (i.e., **‘**) to transform a formula outcome value into just a formula. However, we have to manually place **Apostrophes** before each formula. If we have a handful of data for converting formula outcome values into formulas, we can use this trick.

**Step 1:** Just insert an **Apostrophe** (i.e., **‘**) before the formula.

**Step 2:** Press **ENTER**. You see the formula-driven value gets transformed into the formula.

➤ You can apply **Apostrophe** (i.e., **‘**) to transform all the values in the *Total Price *column into formulas as shown in the following picture.

🔺 After showing all the formulas within a worksheet or workbook, follow the **printing instruction** in order to print desired Excel worksheet, workbook, or selection.

**Read More: How to Show All Formulas in Excel (4 Easy & Quick Methods)**

**Method 2: Show Excel Formulas When Printing Using Show Formula Feature**

Excel offers the **Show Formula** feature in the **Formula** tab. By enabling the **Show Formula** option, we can show formulas within a worksheet. Alternative to this feature, we can use keyboard shortcuts (**CTRL+`** (i.e., the **Tilde** key on the keyboard)).

**Steps:** Select the cells or a range of which you want to show the formulas. Then, go to **Formulas** > Select **Show Formulas** (from the **Formula Auditing** section).

➤ In a moment, all the formula resultant values get converted into just formulas as depicted in the below picture.

🔺 Afterward use the **printing instruction** to print desired Excel worksheet, workbook, or selection.

**Similar Readings**

**How to Stop Showing Formulas in Excel (2 Methods)****Show Value Instead of Formula in Excel (7 Methods)**

**Method 3: Show Formulas When Printing Using Find and Replace Feature**

The **Find and Replace** feature in Excel works in a way to replace given characters with given characters. We can use the **Find and Replace** feature to replace the **Equal **sign (**=**) from formulas with an **Apostrophe** and **Equal** sign (**‘=**). The inserted apostrophes before formulas convert cells to text showing the formulas in the cells as it does in **Method 1**.

**Step 1:** Highlight the entire column of *Total Price*. Afterward, go to the **Home** tab > Select **Find & Replace **(from the **Editing** section) > Select **Replace**.

**Step 2:** The **Find and Replace** dialog box appears. In the **Find and Replace** dialog box,

Insert an **Equal **sign (**=**) in the **Find What** command box.

Type an **Apostrophe** and **Equal** sign (**‘=**) in the **Replace with** command box.

Leave the other options as they are.

Click on **Find All**.

**Step 3:** Clicking **Find All** stacks all the matched cells as shown in the latter picture.

Click on **Replace All**.

**Step 4:** Excel displays a pop-up saying it has replaced all the selected cells with provided characters. Click on **OK**.

➤ Excel shows all the formulas in selected cells after replacement as shown in the below screenshot.

🔺 Now, you can use the **printing instruction**, as you want to print the desired Excel worksheet, workbook, or selection.

**Read More: Excel Show Formula as Text in Another Cell (4 Easy Methods)**

**Method 4: Enabling Advanced Options to Show Formulas in Excel**

Enabling **Advanced** **Show formulas in cells instead of their calculated results **option, displays formulas in cells. Excel offers to enable this option for individual worksheets.

**Step 1:** Click on the **File** tab of any worksheet.

**Step 2:** Select **Options** from the right side of the window.

**Step 3:** The **Excel Options** window appears. In the window, Click on **Advanced** > Scroll up to **Display options for the worksheet** > Select the desired **Worksheet** (i.e., **Advanced Options**).

**Step 4:** Check the **Show formulas in cells instead of their calculated results**. Then, click **OK**.

➤ Return to the worksheet. You see clicking **OK** in the **Excel Options** **Advanced** window, transforming all the formulas within the worksheet into just formula text.

🔺 Since you transform all the existing formula-driven values into formula text, you can proceed to print. Follow the **printing instruction** in order to print desired Excel worksheet, workbook, or selection.

**Read More: Excel Showing Formula Instead of Result (8 Reasons)**

**Method 5: Custom VBA Function to Show Formula When Printing **

Excel **VBA** macros are powerful tools to achieve object-oriented goals. We can use a **VBA** macro to generate a custom function to display formulas in worksheets.

**Step 1:** Use the **ALT+F11** keys altogether to open **Microsoft Visual Basic **window. In the **Visual Basic** window,

Select **Insert** (from the **Toolbar**) > Click on **Module** to insert a **Module** in the window.

**Step 2:** Paste the following macro in the **Module**.

```
Function ShowFormula(Cell As Range) As String
ShowFormula = Cell.Formula
End Function
```

The macro constitutes a custom function named **ShowFormula** and **Cell** is its argument as **Range**. The **Range.Formula **(i.e., **Cell.Formula**) property returns a formula in case the reference cell has one.

**Step 3:** Now, back to the worksheet and try to write the custom function in any cell (i.e., **G5**). Excel displays the available function (i.e., **ShowFormula**) as depicted in the below picture.

**Step 4:** Assign a cell reference to the custom function.

**Step 5: **Use the **ENTER** key and drag the **Fill Handle** to apply the formula to the rest of the cells as picturized in the latter picture.

🔺 As you convert all the resultant values into formulas, you can commence printing. Use the **printing instruction** in order to print desired Excel worksheet, workbook, or selection.

**Read More: How to Show Formula in Excel Cells Instead of Value (6 Ways)**

**Conclusion**

In this article, we use features, **Advanced Options**, as well as **VBA** custom function to show Excel formulas when printing. Hope these above-described methods withstand your requirements in converting resultant values to formulas when printing. Comment if you have further inquiries or have anything to add.