ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   all formulas are showing, need to hide them (https://www.excelbanter.com/excel-discussion-misc-queries/145683-all-formulas-showing-need-hide-them.html)

Todd

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

JMay

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



All times are GMT +1. The time now is 01:39 AM.

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