In many tables, formulae automatically edit values that have been entered. This is very practical when working on a PC-but the formulae cannot be seen when taking a printout. You need those formulae for a discussion with colleagues.

Use the key combination [Ctrl] + ['J to toggle between the normal table view and a special view, in which the table cells display formulae instead of their results. However, this view does not show specific formats such as centered cell contents.



The only way to deal with this is to save you should directly close the file without re-saving the contents. To achieve the same effect in older versions of Excel, call up "Tools I Options" and activate the "Formulas" option on the "View" tab in the dialog that opens. In Excel 2007, click the" Formulas" tab, and then under "Formula Auditing", click the "Show Formulas" button. The special formula view can be used to get an overview of the formulae used and to document the contents of your table draft.