ExcelBanter - how do you can show the formulas on spreed sheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do you can show the formulas on spreed sheet (https://www.excelbanter.com/excel-discussion-misc-queries/125283-how-do-you-can-show-formulas-spreed-sheet.html)

goldiedulku

how do you can show the formulas on spreed sheet

Mike Middleton

how do you can show the formulas on spreed sheet

goldiedulku -

how do you can show the formulas on spreed sheet <

In Excel 97-2003, Tools | Options | View | Formulas, or shortcut key
Control+tilde.

In Excel 2007, Office Button | Excel Options | Advanced | (Display options
for this worksheet) Show formulas in cells instead of their calculated
results.

- Mike
http://www.mikemiddleton.com

All times are GMT +1. The time now is 05:54 AM.