how to display formulas on the sheet

B

Bob Phillips

Ctrl-` (character to left of numbers)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
A

Albion

Else you could go to "tools", "options", then in the "view" panel, tick on
"formulas".
that´ll make you see every formula by its composition rather by its result.
Enjoy !

Albion - Argentina
 
B

Bob Phillips

not AFAIK, it does it on the basis that formulae are longer, so you need
wider columns to see them.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
G

Gord Dibben

Only through a macro which autofits the columns when in formula view.

Sub test()
ActiveWindow.DisplayFormulas = True 'False
Columns.AutoFit
End Sub


Gord Dibben Excel MVP
 
G

Gord Dibben

Yes.

If you have blank columns set to a width of 3 or 23, they will be reset to
default which is 8.43.

Other columns with data or formulas will autofit to size.

I prefer to run John Walkenbach's ListFormulas macro to list formulas, cell
addresses and results on another sheet.

http://j-walk.com/ss/excel/tips/tip37.htm

Then you don't muck about with formatting of the original sheet just to see or
print the formulas.


Gord
 
Top