This blog has been moved to

Showing Formulas in Microsoft Office Excel Instead of Their Results

Sometimes in an Excel worksheet you want to display formulas instead of their results. Here’s how:

1. Click the Office button, and then click Excel Options at the bottom of the menu.

2. Click Advanced, click Display options for this worksheet, click Show formulas in cells instead of their calculated results, and then click OK.



October 23, 2008 at 12:33 PM

Nice, it worked for me. Haven't noticed it yet. How can i embed a drop down box in my Excel cell? Anybody knows?

  Rahul Manekari

October 23, 2008 at 4:29 PM

Hey rishi...

Here is the answer of your question..


October 24, 2008 at 2:55 PM

Hey, thanks buddy for the link.

  Rahul Manekari

October 25, 2008 at 8:20 AM

your welcome buddy.....