How to View Formulas instead of Values in Excel Cells?
If you are new here, Subscribe to Full Feeds or by Email or follow us in Twitter and receive free daily updates on Office and Windows Tips, Tricks and Tweaks..
In my last post about Relative and Absolute Reference in Formulas, I showed the formulas in all the cells instead of the values. Formulas in Excel are the best time saver for any calculations. But sometimes with too many formulas in hand, its easy to get confused and get lost.
So if you are looking at each cell to find out what formula you had written down, then this tip might save you time and will give you better understanding of the formulas.
Use the Show Formulas button in Excel under Formulas tab to view all the formulas used in the sheet rather than the values. You can see in the picture below how formulas are shown instead of the actual values.
Keyboard Shortcut to Show Formulas in Excel
You can also use the keyboard Shortcut CTRL + ` to show formulas in Excel. (` Grave Accent key is the one below the Escape Key on the far upper left side of the keyboard)
[...] see how you can display all the formulas in Excel, so its easier to review the Excel [...]
With the new version of Office, all menus and features are rearranged and for a newbie, its difficult to spot each of these.
@Nirmal, Yeah I guess what you said is true…but I believe after one learns where a fuctionality is available, its easier to use the Office 2007 that the earlier versions. But what I have understood from my friends is that if they have used to work around Office 2003, they still expecting the fuctionality to be available there and now they are not happy since its in a new place…
I was looking for this command under the View menu but actually now you point it out auditting is a logical place to put it. Now where did edit Links go !?