| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to reveal a formula in a cell ?
Dear Sir
If I have formula at =SUMIF(A$1:A$20,C20,D$1:D$20) at cell F1, May I know the quick way to reveal the formula as a text i,e. €˜=SUMIF(A$1:A$20,C20,D$1:D$20) ? Currently I could only read from the formula bar , I need to go to the bar and key in €˜ in front of it in order for it to be shown as text. Thanks Low -- A36B58K641 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reveal unshown data in cell | Excel Discussion (Misc queries) | |||
| Excel 2002: How to reveal grid lines on color shaded worksheet? | Excel Discussion (Misc queries) | |||
| ExcelExcel 2002 display formula in another cell as text | Excel Worksheet Functions | |||
| Can I hide rows in Excel 2002 using a formula in a cell? | Excel Discussion (Misc queries) | |||
| Reveal cell formats and extendable range in tool/statusbar/icon. | Excel Worksheet Functions | |||
Threaded Mode
