AirMaximus88
New Member
- Joined
- Mar 13, 2014
- Messages
- 16
Hi everyone!
First time poster here, I do apologise if I contravene any forum rules.
I am having trouble with missing aspects of the Find and Replace function. The Find function allows me to look in Formulas, Values and Comments, but the Find and Replace function only allows me to look in Formulas. I could have sworn that I previously used this function to look in the Values of cells rather than just the Formulas. Any ideas what I've done?
Pictures attached:
Fig 1. Find function allows me to look in Formulas, Values and Comments.
Fig 2. Find and Replace function only allows me to look in Formulas.
Thanks for your help,
Max
P.S. As an afterthought I should probably have mentioned my current version - Excel 2010 Ver. 14.0.7113.5005 (32-bit)
First time poster here, I do apologise if I contravene any forum rules.
I am having trouble with missing aspects of the Find and Replace function. The Find function allows me to look in Formulas, Values and Comments, but the Find and Replace function only allows me to look in Formulas. I could have sworn that I previously used this function to look in the Values of cells rather than just the Formulas. Any ideas what I've done?
Pictures attached:
Fig 1. Find function allows me to look in Formulas, Values and Comments.
Fig 2. Find and Replace function only allows me to look in Formulas.
Thanks for your help,
Max
P.S. As an afterthought I should probably have mentioned my current version - Excel 2010 Ver. 14.0.7113.5005 (32-bit)