Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Showing Formulas
Is there some way to show the formulas used and their current values
in a report? Thanks |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Showing Formulas
Ctrl-` (grave) will toggle between displaying formulas and their
values. It's the character next to the number 1 on most US keyboards. HTH, JP On Mar 19, 1:08*pm, trvlnmny wrote: Is there some way to show the formulas used and their current values in a report? Thanks |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Showing Formulas
On Mar 19, 1:17*pm, JP wrote:
Ctrl-` (grave) will toggle between displaying formulas and their values. It's the character next to the number 1 on most US keyboards. HTH, JP On Mar 19, 1:08*pm, trvlnmny wrote: Is there some way to show the formulas used and their current values in a report? Thanks- Hide quoted text - - Show quoted text - I do not want to toggle between showing and hiding the formulas. I want the formulas to be on the printed report so readers know how a column was calculated. Thanks |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Showing Formulas
For formulas and values see
http://www.mvps.org/dmcritchie/excel/formula.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "trvlnmny" wrote in message ... Is there some way to show the formulas used and their current values in a report? Thanks |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Showing Formulas
Gotcha, go to ToolsOptionsView tab, check box next to "Formulas"
HTH, JP On Mar 19, 2:48*pm, trvlnmny wrote: I do not want to toggle between showing and hiding the formulas. I want the formulas to be on the printed report so readers know how a column was calculated. Thanks |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Showing Formulas
From John Walkenbach's storehouse of macros.
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 Wed, 19 Mar 2008 11:48:42 -0700 (PDT), trvlnmny wrote: On Mar 19, 1:17*pm, JP wrote: Ctrl-` (grave) will toggle between displaying formulas and their values. It's the character next to the number 1 on most US keyboards. HTH, JP On Mar 19, 1:08*pm, trvlnmny wrote: Is there some way to show the formulas used and their current values in a report? Thanks- Hide quoted text - - Show quoted text - I do not want to toggle between showing and hiding the formulas. I want the formulas to be on the printed report so readers know how a column was calculated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Showing formulas | Excel Discussion (Misc queries) | |||
all formulas are showing, need to hide them | Excel Discussion (Misc queries) | |||
Formulas showing on worksheet | Excel Discussion (Misc queries) | |||
formulas showing not value | Excel Discussion (Misc queries) | |||
Formulas not showing results | Excel Worksheet Functions |