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

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#rows.com
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#AI-powered spreadsheet
#spreadsheet API integration
#find and replace
#Excel
#spreadsheet