Formulas In Excel 2010 Cells

Excel 2010 has built-in option to deal with the data cell according to the user’s need. Sometime for making audience to comprehend the complete datasheet, you just need to show the formulas in the cell rather than the evaluated values. This could be very beneficial for making out tutorial for the novices. In this post we will let you know how to show only the formulas in the data cells.

Launch Excel 2010 spreadsheet on which you want to show formulas in the cells rather than the evaluated result. For instance we have included a spreadsheet containing fields;Name, Course, Marks, Grade, and Status.

We have evaluated values present in Grade and Status through a formula. Now for showing all the formulas in every field and every cell, go to File menu and click Options.

options2 Show Formulas In Excel 2010 Cells

It will bring up Excel Options dialog, from left sidebar click Advanced and from right pane scroll down to find Display options for this worksheet group. Now under this group enable ‘Show formulas in cells instead of their calculated result’ option. Click OK to continue.


Upon click you will see all the cells which contained formula results, now showing the complete formula statement.


You can also check out previously reviewed guides on Tracking Formula Precedents & Dependents and Validating data in Excel 2010.

قالب وردپرس

About Alyse Kalish

Alyse Kalish
As an Associate Editor for The SalesJobInfo, Alyse is proud to prove that yes, English majors can change the world. She calls many places home, including Illinois where she grew up and the small town of Hamilton where she attended Colgate University, but she was born to be a New Yorker. In addition to being an avid writer, Alyse loves to dance, both professionally and while waiting for the subway.

Leave a Reply

Your email address will not be published. Required fields are marked *