Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula View
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. |
#2
|
|||
|
|||
Hi
AFAIK this is not possible -- Regards Frank Kabel Frankfurt, Germany wrote: 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. |
#3
|
|||
|
|||
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 wrote: 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. -- Dave Peterson |
#4
|
|||
|
|||
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 On Tue, 14 Dec 2004 09:45:01 -0800, " wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
What instead of an array formula part 2 | Excel Discussion (Misc queries) | |||
Paste is is copying in formula, but display is wrong. | Excel Discussion (Misc queries) | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) |