how to display formulas on the sheet

[flat6]

I would like to know how display the formulas on the sheet.

 

[Bob Phillips]

Ctrl-` (character to left of numbers)

--

HTH

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

 

[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

 

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

 

[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

 

[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