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)
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…