How do I print formulas in a spreadsheet?
 

How do you display the formulas in an Office 2007 spreadsheet so they will
print?

How do I print formulas in a spreadsheet?
 

Hit Ctrl + ~ to display all the formulas..
(tilde. The key just above Tab key)

OR
If you are looking to just print few formulas then just enter a apostrophe
(') infront of the formula..

If this post helps click Yes
---------------
Jacob Skaria


"katiesmom" wrote:

How do you display the formulas in an Office 2007 spreadsheet so they will
print?

How do I print formulas in a spreadsheet?
 

It's actually Ctrl+` (grave), Ctrl+~ doesn't seem to do anything.

--JP

On Nov 3, 11:43*am, Jacob Skaria
wrote:
Hit Ctrl + ~ to display all the formulas..
(tilde. The key just above Tab key)

OR
If you are looking to just print few formulas then just enter a apostrophe
(') infront of the formula..

How do I print formulas in a spreadsheet?
 

If you want formulas from all worksheets printed out on one sheet use this
macro from John Walkenbach.

Sub ListFormulas()
'from John Walkenbach
Dim FormulaCells As Range, Cell As Range
Dim FormulaSheet As Worksheet
Dim Row As Integer
Dim WS As Worksheet
' Create a Range object for all formula cells
On Error Resume Next
Set FormulaCells = Range("A1").SpecialCells(xlFormulas, 23)

' Exit if no formulas are found
If FormulaCells Is Nothing Then
MsgBox "No Formulas."
Exit Sub
End If

' Add a new worksheet
Application.ScreenUpdating = False
Set FormulaSheet = ActiveWorkbook.Worksheets.Add
FormulaSheet.Name = "Formulas in " & FormulaCells.Parent.Name

' Set up the column headings
With FormulaSheet
Range("A1") = "Address"
Range("B1") = "Formula"
Range("C1") = "Value"
Range("A1:C1").Font.Bold = True
End With

' Process each formula
Row = 2
For Each Cell In FormulaCells
Application.StatusBar = Format((Row - 1) / FormulaCells.Count, "0%")
With FormulaSheet
Cells(Row, 1) = Cell.Address _
(RowAbsolute:=False, ColumnAbsolute:=False)
Cells(Row, 2) = " " & Cell.Formula
Cells(Row, 3) = Cell.Value
Row = Row + 1
End With
Next Cell

' Adjust column widths
FormulaSheet.Columns("A:C").Cells.WrapText = True ''AutoFit
Application.StatusBar = False
End Sub


Gord Dibben MS Excel MVP

On Tue, 3 Nov 2009 08:40:19 -0800, katiesmom
wrote:

How do you display the formulas in an Office 2007 spreadsheet so they will
print?

How do I print formulas in a spreadsheet?
 

katiesmom -

To display formulas in Excel 2007, on the Formulas ribbon, click Show
Formulas (in the Formula Auditing section). Then print.

- Mike
http://www.MikeMiddleton.com


"katiesmom" wrote in message
...
How do you display the formulas in an Office 2007 spreadsheet so they will
print?