Displaying a formula in cells - Massey University
Displaying a formula in cells
Microsoft Excel 2007
You may wish to display the script of a formula contained in a particular cell to show how you performed your calculation. e.g.) Sample data ? TOTAL cells contain formulas (cells are greyed).
1. Formulas > Show Formulas
, 2. The formulas are now shown.
Tip
A shortcut key for showing formulae is:
When you finish, perform the same shortcut key to go back to the normal data view.
Produced by Massey University Library Information Commons
Page 1 of 1
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- how to show formula in excel cells instead of value
- array formulas in excel 2016 university of wyoming
- spreadsheet showing formula not result
- excel spreadsheet showing formula not result
- how do i show a value instead of formula in excel
- how to show value not formula in excel
- calculating and displaying regression statistics in excel
- displaying a formula in cells massey university
- why is excel spreadsheet formulasum displaying as
- title putexcel — export results to an excel file
Related searches
- how to add a formula in excel
- how to create a formula in excel
- replace a formula with its result excel
- how to make a formula in excel
- solving a formula for a variable calculator
- solve a formula for a variable calculator
- format within a formula excel
- find a formula for the sequence
- how to combine data in cells excel
- creating a formula in excel
- select a range of cells vba
- excel change a formula to a value