How can you print formulas in Excel 2000?

P

Paul B

tdshort, one way ctrl+` to toggle between formulas and values
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **
 
B

Bernard Liengme

Best to put question in the message.

Use CTRL+` (on a US keyboard this is next to the 1 on the top typewriter
keys)
Adjust column widths and print
Reverse process

OR, use this Sub. For the active sheet, it makes a new sheet and lists
formulas and their cells

Sub ListFormulas()
Dim FormulaCells As Range, Cell As Range
Dim FormulaSheet As Worksheet
Dim Row As Integer

' 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").AutoFit
Application.StatusBar = False
End Sub
 
E

ElsiePOA

Your question is pretty vague. It's not clear just what it is you wan
to do.

If you just want to print your worksheet, having the formulas print a
formulas rather than the resulting calculation, select Tools / Options
View and click on Formulas. All formulas will show up in the cells an
you can print out the sheet.

If you want to print out ONLY the formulas, then follow that procedur
above, but before you print, push F5(Goto) and click on Special
Formulas. Then you can print, but under "print what", click o
"Selection". Now your printer will only print the formulas
 
Top