| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
all formulas are showing, need to hide them
Hi, I was pasting data into a page and now all the formulas are showing and
none of the results. as in I see: =INDEX('Price List'!B:B,MATCH('item reconciliation'!A9,'Price List'!A:A,0)) and not 17.00 What did I do and how do I reset? Thanks, Todd |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
all formulas are showing, need to hide them
Go to (on the menu) Tools, Options, Viw Tab -- then under Window options
Uncheck formulas.. "Todd" wrote: Hi, I was pasting data into a page and now all the formulas are showing and none of the results. as in I see: =INDEX('Price List'!B:B,MATCH('item reconciliation'!A9,'Price List'!A:A,0)) and not 17.00 What did I do and how do I reset? Thanks, Todd |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas showing on worksheet | Excel Discussion (Misc queries) | |||
| Formulas showing up as text | Excel Discussion (Misc queries) | |||
| formulas showing not value | Excel Discussion (Misc queries) | |||
| Showing + and - (show and hide) for rows in the sheet | Excel Worksheet Functions | |||
| Formulas not showing results | Excel Worksheet Functions | |||
Linear Mode
