ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   display only one formula (https://www.excelbanter.com/excel-discussion-misc-queries/11520-display-only-one-formula.html)

norcalchick2207

display only one formula
 
i'm taking a computer test and i need to know how to display my formula when
it prints so the formula doesn't calculate, but i only need one of the
formulas to be shown the rest need to stay in calculated form. How would i do
this?

Arvi Laanemets

Hi

Format the cell as Text, select the cell, press F2, and then Enter keys.

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"norcalchick2207" wrote in
message ...
i'm taking a computer test and i need to know how to display my formula

when
it prints so the formula doesn't calculate, but i only need one of the
formulas to be shown the rest need to stay in calculated form. How would i

do
this?





All times are GMT +1. The time now is 09:32 PM.

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