Home |
Search |
Today's Posts |
#1
|
|||
|
|||
print formula
i need to know how to get formula printed on the spreadsheet. please advise margaret -- Bentleypiano |
#2
|
|||
|
|||
Tools Options ViewTab check "Formulas" box under "Window options"
OK....... un-check the box to return to normal...... Vaya con Dios, Chuck, CABGx3 "Bentleypiano" wrote in message m... i need to know how to get formula printed on the spreadsheet. please advise margaret -- Bentleypiano |
#3
|
|||
|
|||
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...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) --- 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 "CLR" wrote... Tools Options ViewTab check "Formulas" box under "Window options" OK....... un-check the box to return to normal...... "Bentleypiano" wrote ... i need to know how to get formula printed on the spreadsheet. please advise margaret -- Bentleypiano |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
Frequency formula | Excel Worksheet Functions | |||
Multiple Condition Sumif Formula | Excel Worksheet Functions | |||
Can I use Print in an if formula? | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |