SPREADSHEET FORMULA VIEW

  • Thread starter Thread starter FLKulchar
  • Start date Start date
F

FLKulchar

Instead of viewing the numeric contents of a cell,

HOW CAN I VIEW MY SPREADSHEET (and ultimately print it)
seeing my FORMULAS entered into the cells.

Easily done in Microsoft Works under the VIEW menu!!

But, in EXCEL, I am at a loss.

Please help.

Larry
 
Hi Larry,
One way would be to toggle to formula view and print
Ctrl+` (accent grave or whatever is to left on 1 in number row)
or from tools, options, view, formula view

problem with that is that the cells are exactly 3 X the width of
your normal view, so you may have columns that are too
narrow or too wide. If you change the column width in formula
view you will change the widths in normal view.

My preference would be to show a few representative formulas
and not waste the paper. See my formula page
for GetFormula and GetFormulaD macros
http://www.mvps.org/dmcritchie/excel/formula.htm

Another alternative is to print the formulas on a page created
to show formula in a list (j-walk tip 37, for instance)
address, formula, value

Creating a List of Formulas (Tip 37) « can be found on
John Walkenbach's site (Tip 37). It uses less coding but is identical
in function, to the GetFormulaInfo example from Microsoft.
 
Larry

CRTL + `(backquote above TAB key) will toggle view formulas on/off.

Long way around....Tools>Options>View>Window Options> checkmark in "Formulas"

Gord Dibben Excel MVP
 
I saw your answer to my excel query, and i was quite impressed with your
presentation...THANK YOU.

Now, I have a different question re: Copying and Pasting functions from
1 cell to another.

FOR EXAMPLE: I have a column of names, 25, of them, in A1 through A25.

I have an ENTERED formula in B1...,for example,...
=IF(A1="Larry", TRUE, FALSE)

If I paste this formula to B2:B25...my A1 becomes A2:A25

BUT I WISH TO KEEP EACH CELL in the B column as A1 !!

for example, my 12th entry should read:

=IF(A1="Larry", TRUE, FALSE) NOT =IF(A12=....etc.)

Is there a paste special (or whatever that can handle this)

thanks,

Larry
 
Hi Francis

Francis L. Kulchar wrote:
[snipped]
I have an ENTERED formula in B1...,for example,...
=IF(A1="Larry", TRUE, FALSE)
Click to expand...

change to
=IF($A$1="Larry", TRUE, FALSE)

The $ signs will create an absolute reference (you have used a relative
reference). You can toggle between them with hitting F4

HTH
Frank
 
Back
Top