Formula View

[Guest]

When in the Formula View ( by clicking Ctrl `), how can I format the cells to
wrap text so I can see and print all formulae in my spreadsheet.

 

[Frank Kabel]

Hi
AFAIK this is not possible

 

[Dave Peterson]

Maybe you can use a helper worksheet and a UserDefinedFunction:

Option Explicit
Function getFormula(rng As Range)
With rng(1)
If .HasFormula Then
getFormula = .Formula
Else
getFormula = .Text
End If
End With
End Function

Then you can insert a new worksheet and do this in A1:

=getformula(sheet1!a1)

Drag down as far as you need and to the right as far as you need.

Format the way you want.

If you're new to macros, you may want to read David's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Gord Dibben]

You cannot wrap text for formulas.

You could edit/replace the = sign with "=" and see all formulas as text, which
you could wrap.

Alternative...................

See John Walkenbach's site for his ListFormulas macro.

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

"Most users have discovered that Excel has an option that lets you display
formulas directly in their cells: Choose Tools Options, click the View tab,
and select the Formulas checkbox. However, Excel doesn't provide a way to
generate a concise list of all formulas in a worksheet. The VBA macro below
inserts a new worksheet, then creates a list of all formulas, cell addresses
and their current values."

Gord Dibben Excel MVP