Veiw Formulas

Jason Buck · Oct 20, 2003

How do you print/view the formula for each cell?

Thanks

Peo Sjoblom · Oct 20, 2003

tools>options>view and check formula or to toggle formula view off/on
ctrl + ` (grave accent), on a US keyboard above the tab key far left

Jason Morin · Oct 20, 2003

The shortcut to view your formulas is <Ctrl><`>. You can
print from there.

HTH
Jason
Atlanta, GA

Ken Wright · Oct 20, 2003

Another Option is to use Chip Pearson's PrintFormula macro to print them all to a Word document:-

http://www.cpearson.com/excel/excelM.htm#PrintFormulas

Guest · Nov 21, 2003

highlight sheet and cntrl `

Hide columns based on row values	2	Mar 7, 2014
How do I print my spreadsheet to show the formulas of a cell?	3	Feb 22, 2010
veiw	1	Jan 13, 2010
Wrap Text - Formula View	1	May 21, 2008
Excel VBA	1	Mar 14, 2023
can't see color pattern in cell	1	Sep 9, 2004
Excel Need Countifs Formula Help	0	Apr 24, 2021
Use & with two formulas	2	Jul 12, 2013

Ask a Question