1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Find and Replace - No option to look in values?

https://preview.redd.it/ynaenmtog7qg1.png?width=508&format=png&auto=webp&s=3ff5dad44c6daef6f77bf8e2db7ce51e360ee2ac

This is a new one for me. Today I wanted to use find and replace to change some values in a spreadsheet. However, the dialog only gives me the option to look in formulas. I've run all available updates, did a full repair on Office, and tried multiple different files; this is present everywhere.

Any idea how to fix this?

Running Excel version 2602 Build 16.0.19725.201264 64-bit.

Thanks in advance for any suggestions!

submitted by /u/RavingLuhn
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article