MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Printing Formulas in Excel

Posted by Julia on December 07, 2001 7:05 AM

I am using Microsoft Excel 97 and would like to know how to print a formula only. I have 6 columns with data in the first five. The sixth column shows the calculation of the first five. I need to print the worksheet showing the first five column data but instead of the calculation, I need the formula in the 6th column to print. I tried tools, options and check formula on the view tab but that changes the entire worksheet. I only need the 6th column formula to show. Thank you for your assistance.

Posted by Jim on December 07, 2001 8:17 AM

This is from a post earlier this year, looks like what you need.

Posted by mseyf on May 31, 2001 at 12:39:21:

In Reply to: showing some formulas !? posted by Roger on May 31, 2001 at 11:54:30:

creating a User Defined Function may be the easiest:

Function GetFormula(cell)
GetFormula = cell.Formula
End Function

if your formulas are in column A, insert a column at column B, in cell B1 enter =getformula(a1) and copy down.

Posted by Hansoh on December 07, 2001 12:11 PM

there's a little-known trick key in excel. hit the CTRL+'that little squiggly line above the TAB key'.

sorry, i forgot the name of that key.

what this does is show you ALL the formulas on the worksheet. to get rid of the formula view, hit the keys again.

another option is TOOLS->OPTIONS-->VIEW tab--> check on Formulas