Find or Replace Text and Numbers in Excel (surprising features)

Use Excel's Find and Replace feature to not only find and select all cells, but to also find and replace cell formatting.
You can use Excel's shortcut keys Ctrl + F to get to the FIND dialogue box and Control + H to get to the replace dialog box.

🔍 What You'll Discover:
- Accessing Find & Replace: Learn the quickest ways to launch Find & Replace in Excel, including time-saving keyboard shortcuts.
- Exploring Hidden Options: Dive deep into the lesser-known features of Find & Replace, such as searching within comments, formulas, and even specific formatting.
- Advanced Search Techniques: Understand how to tailor your searches for precise results, whether you're looking within a single sheet or an entire workbook.
- Replacing with Formatting: Learn how to not just replace text but also apply new formatting styles in one go, saving you valuable time and effort.
- Smart Formatting Replacement: Discover how to efficiently update cell formatting across your workbook – ideal for company-wide branding updates.

You can search for a specific text in formulas, cells and also comments. You have the option to search inside the entire workbook or a specific worksheet.

You can get more advanced with Excel's find and replace feature by searching for a specific cell formatting and replacing it with another. For example, you need to replace one cell color with another color. You can quickly do that with Find and Replace.

🚩Let’s connect on social:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#excel

[robertflynn]

Leila, no matter how much I think I know about a certain Excel feature or function, you always manage to uncover all these hidden gems when I watch your videos. Thanks once again for another great video!

[vivekphadke]

It proves that we don't see many things which are in front of our eyes, as such do not even explore them. That's where a role of a teacher starts... To show a correct path. Thanks a lot Leila

[dasrotrad]

You are right again... I have been 'staring' at Excel for years and have never used these basic features before! Thank you Leila.

[pavannandula]

Awesome!. I used Find & replace but never knew that we can find for a format/color & replace them. Great aspect. You're a really awesome mentor to the subscribers

[gopalakrishnarao]

Thanks to my Excel Teacher, for teaching us in an Excellent way. In every Video you are making us to learn & learn something, and become smarter. Thanks a lot.

[musiqueclassiquepourtoujours]

I have been into data science for close to 10 years now and I must say that you are like a greek goddess for excel users both beginners and expert users!! Great going!!👍🏻

[mattias]

I never actually 'bothered' to consider Find/Replace as anything else but just that... text replacement. But as with all your tutorials you always shed new light on things, you rock! :)

[SuperSaj]

This blew my mind!!!! You are a genius

[ankurshukla]

Indeed Find and replace option helps us a lot. I used them very frequently as it is too helpful when you need to change anything in your workbook. You can change your formula reference, you can filter bold part, you can change whole formula ( I used this trick to put SUBTOTAL instead of SUM in multiple cells)

Really great option in excel. Thank you Leila sharing more things like highlighting all the found value in one time.

[ObsoleteIntelligence]

Great videos. No need to memorize the RGB code in the end though. Click "Format" after selecting a format from a cell and you can edit the selected format.

[incognitootingocni]

Super helpful, as always!!! HUGE THANKS Leila - from China!!!

[ca.lakshminarayanreddyjamb]

Awesome Leila!!! I can't imagine so much hidden in excel in find and replace. You are making me to learn and new dimensions to look it in every video you post. Keep up the good work.

[WESTPRINGLE]

Fantastic, you are a wealth of knowledge. I know Excel well, but you give me much more, thanks you.

[allegro]

I have been struggling with finding good resources for my excel questions until I came across your videos. Thanks Leila for putting through such an amazing job.

[michaelnwachukwu]

You are the best I have seen on YouTube on this subject. Thank you!

[signalmas]

Awww... enlightening. replace colors and being able to mass highlight the finds.... awwww LOVE IT, upset I didn’t know about it years ago. Thank you Leila

[RahulKumar-zvnd]

You always teach something new about what we are already using but in a very limited and conservative way. You are superb! Thank you so much

[DjanCarnary]

Mind blown!!... i had no idea that you can find and replace formatting :O Amazing tip! :)

[vincentandrew]

Omg, I didn't know you could do control+down in the search box!

[AmitKumar-eexj]

the way you explain the things are very easy to understand....such an great