Advanced find and replace tricks in excel (save hours of time!!!)

In this beginners tutorial we learn advanced tricks for using excel find and replace. Did you know that find and replace can be used to replace color, number and other formats in excel. It can also be used to select and change (or delete) multiple cells. The find and replace tricks covered in this video will save you hours of time manually updating your spreadsheets! We also show you the find and replace shortcut for excel. Take your spreadsheet knowledge to the next level with this easy tutorial.

0:00 Introduction
0:24 Find and replace shortcut and where else you can find it
0:54 Basics of find and replace
2:15 Find all - how to use it
2:39 Find and replace: select all instances
3:03 Find and replace formatting
3:37 Change formatting from one style to another
5:37 Find and replace formatting using RBG code
6:24 Find and replace number formatting

Learn Excel online for free: Our Excel for beginners tutorial will teach you all you need to know to take you from zero to Excel hero!

What Microsoft Excel tips and tricks do you want to learn? Let me know for future videos! I'll continue to develop tutorials covering Excel basics for beginners and will build up a catalogue of free Microsoft Excel course materials! :-)

[intersubjecivity]

Hello, thank you for this video. It is very useful, however, in my case when I click on the "options" in Find and Replace I get no buttons to choose the format (neither of the two small windows that show in your video), so I cannot progress. Is this because I am using a Mac? Is there another method for Mac users? Thank you.