ExcelBanter - how do I display cell formulas in Excel 2007

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

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

- - how do I display cell formulas in Excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/222577-how-do-i-display-cell-formulas-excel-2007-a.html)

pangracs

how do I display cell formulas in Excel 2007

In previous versions of Excel, all cells could be made to display their
formulas but in 2007 I can find how to do that.

Sheeloo[_3_]

how do I display cell formulas in Excel 2007

Press CTRL-`

It toggles between showing formulas and values...

"pangracs" wrote:

In previous versions of Excel, all cells could be made to display their
formulas but in 2007 I can find how to do that.

JR Hester

how do I display cell formulas in Excel 2007

You may also select all cells, Open teh Formulas tab, and choose Show
Formulas from eth formula audint group. If you are displaying in smaller than
full screen window you may not see that option, but it is there!

"pangracs" wrote:

In previous versions of Excel, all cells could be made to display their
formulas but in 2007 I can find how to do that.

All times are GMT +1. The time now is 12:34 PM.