SPREADSHEET FORMULA VIEW
 

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

SPREADSHEET FORMULA VIEW
 

Tools, Options, View

Tick Formulas check box


---
Message posted from http://www.ExcelForum.com/

SPREADSHEET FORMULA VIEW
 

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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"FLKulchar" wrote in message ...
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

SPREADSHEET FORMULA VIEW
 

Larry

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

Long way around....ToolsOptionsViewWindow Options checkmark in "Formulas"

Gord Dibben Excel MVP

On Tue, 13 Jan 2004 21:23:33 -0800, "FLKulchar" wrote:

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

SPREADSHEET FORMULA VIEW
 

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

Now, I have a different question 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




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

SPREADSHEET FORMULA VIEW
 

Hi Francis

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

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