ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Showing formulas (https://www.excelbanter.com/excel-discussion-misc-queries/176169-showing-formulas.html)

jfg

Showing formulas
 
I have Excel 2003. I would like my worksheet to show formulas used. How do I
do this?

Thank you.

David Biddulph[_2_]

Showing formulas
 
Why not try typing
show formula
into Excel help?
--
David Biddulph

"jfg" wrote in message
...
I have Excel 2003. I would like my worksheet to show formulas used. How do
I
do this?

Thank you.




Matt Richardson

Showing formulas
 
On 9 Feb, 07:54, "David Biddulph" <groups [at] biddulph.org.uk wrote:
Why not try typing
show formula
into Excel help?
--
David Biddulph

"jfg" wrote in message

...

I have Excel 2003. I would like my worksheet to show formulas used. How do
I
do this?


Thank you.


To do this just press CTRL and ` (which is the accent key you usually
find to the left of the number 1 key on your keyboard along the top
row. This will toggle between showing the values and showing formulas
in cells.

Hope this helps,
Matt Richardson
http://teachr.blogspot.com

jfg

Showing formulas
 
Thank you very much, Matt. I went to your "teachr" link. I liked it very much
and will use it as an Excel reference. Again, thank you.

jfg

"Matt Richardson" wrote:

On 9 Feb, 07:54, "David Biddulph" <groups [at] biddulph.org.uk wrote:
Why not try typing
show formula
into Excel help?
--
David Biddulph

"jfg" wrote in message

...

I have Excel 2003. I would like my worksheet to show formulas used. How do
I
do this?


Thank you.


To do this just press CTRL and ` (which is the accent key you usually
find to the left of the number 1 key on your keyboard along the top
row. This will toggle between showing the values and showing formulas
in cells.

Hope this helps,
Matt Richardson
http://teachr.blogspot.com


jfg

Showing formulas
 
Thank you for your response, David. I went to Excel and typed "show formula"
in the Excel Help and got the answer I was seeking. Thanks for reminding me
to use this very valuable resource.

jfg

"David Biddulph" wrote:

Why not try typing
show formula
into Excel help?
--
David Biddulph

"jfg" wrote in message
...
I have Excel 2003. I would like my worksheet to show formulas used. How do
I
do this?

Thank you.






All times are GMT +1. The time now is 08:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com