•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Find and Replace - No option to look in values?
Our take
If you're experiencing an issue where the Find and Replace feature in Excel only allows you to search within formulas, you're not alone. This limitation can be frustrating, especially after running updates and repairs. Users often seek solutions to ensure they can search through values as well. In this discussion, we invite you to explore potential fixes and share your insights on overcoming this challenge. Your expertise could empower others facing the same situation, making data management a smoother experience for everyone.
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!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Excel 2019 - Search Replace is stuck in loop after changing TabI needed to perform a search & replace (S&R) on a cloned Tab to update formulas. I didn't realise it hadn't completed the 'S&R' and selected another tab in Excel. Now it is stuck in a loop saying: Microsoft Excel cannot find a match. There are approx 10k columns and 15k rows, and it wont allow me to return to the Tab it is searching, and I suspect it's actually looking in the newly selected tab. Is there a way to intervene and regain control or am I destined to clicking on OK till my next birthday :( submitted by /u/mbkitmgr [link] [comments]
- Change contents of cells based on a drop downSo, I'm trying to generate a spreadsheet to make the forms we use in the office to issue keys. When people are given an apartment, we have a sheet with all the key numbers on it, and then they sign for it. At the moment, we've got 22 different PDFs and Word documents, and it doesn't work. So, what I want to do is this. I've built the template in Excel and created a Reference sheet which will have all the numbers in it. What I am trying to do is set it up so that when you use the Apartment number from a dropdown, it populates with all the key numbers. This sounds like it should be easy to do, but my Excel brain is broken. Advice would be much appreciated! submitted by /u/Hot_Syrup_1774 [link] [comments]
- Vlookup / Index disappearingApologies if I'm asking a really dumb question, I am somewhat new to excel. I'm having a problem with a macro-enabled workbook. I have tried both Index and Vlookup, but both formulas just disappear and only leave behind the last value they found. Attached is a massively simplified (and ugly) version of what the spreadsheet is supposed to do. The issue I'm having is that every time I add anything new into the empty slots of column B, Vlookup completely disappears from the cell it's in and just leaves behind "Item B" or whatever the last value it searched for was. Is this supposed to work this way? I also tried Index, and the result was the same. I don't know how to figure this out without manually re-writing the formula every time the list of items changes, which is a huge pain. Thanks for any help. https://preview.redd.it/ceyghyu6t0rg1.png?width=627&format=png&auto=webp&s=1e0a247397d39b1a050841f1ada44b14b8d5fae8 submitted by /u/allegedlyautistic [link] [comments]