![]() |
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 |
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