print formula

B

Bentleypiano

i need to know how to get formula printed on the spreadsheet.

please advise

margaret
 
C

CLR

Tools > Options > ViewTab > check "Formulas" box under "Window options" >
OK.......

un-check the box to return to normal......


Vaya con Dios,
Chuck, CABGx3
 
D

David McRitchie

Hi bentleypiano,
If you mean printing the formula used in another cell, see

Show FORMULA or FORMAT of another cell
I prefer to show the formula in use for documentation purposes,
within the actual spreadsheet they are active in, which I think is the best choice.
http://www.mvps.org/dmcritchie/excel/formula.htm#getformula

If not familiar with installing a User Defined Function see
http://www.mvps.org/dmcritchie/excel/getstarted.htm

use is similar to Excels own functions
=GetFormula(B4)
or if installed in a different workbook.
=personal.xls!GetFormula(B4)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing Outline view - formatting lost 0
Blank Page After Envelope-Label Wizard 5
Descenders clipped 0
Dealing with a Pivot Table (when I don't want to) 0
Page numbering with Merged Document and IF statements 1
Publisher adding blank page when printing my booklet... 2
Copy addition formula of non-consecutive horizontal cells 2
Print order of TriFold - Publisher 365 0

Top