Excel show formula as text in another cell

This post is going to show you all the different ways you can show the formulas in your Microsoft Excel spreadsheets.

Normally when you create a formula in Excel it will return a calculated value in the cell.

But you might want to see the formula and not the value it generates.

This can be very useful for inspecting your formulas for potential errors.

Showing your formulas will also help you to familiarize yourself with a new spreadsheet and what items are calculations and which are static data.

When the need to view your formulas arises, how do you show them in the grid instead of the values?

Get your copy of the example workbook used in this post and read on to find out!

Show Formulas from the Formula Bar

This method is the most simple and straightforward way to view your formulas.

When you select any cell, it will show any formula in the formula bar.

This is also the most limited method as it will only allow you to view one formula at a time.

Show Formulas with Edit Mode

This method will still only allow you to view on

how to show formulas in excel cells

how to show formulas in excel mac