Spiga




This blog has been moved to
www.WinSpark.net



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.




4 comments:

  Rishi

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..
http://office.microsoft.com/en-us/excel/HP100725991033.aspx?pid=CH100648501033

  Rishi

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.....