Excel's Find and Replace (surprising features)
Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials
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 Control + F to get to the FIND dialogue box and Control + H to get to the replace dialog box.
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.
⯆ Blog post: https://www.xelplus.com/excel-find-and-replace/
LINKS to related videos - Excel basics playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyx1KSoobwukzf1Nf-Y97Rw0
★ My Online Excel Courses ► https://courses.xelplus.com
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
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!
#MsExcel
Видео Excel's Find and Replace (surprising features) канала Leila Gharani
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 Control + F to get to the FIND dialogue box and Control + H to get to the replace dialog box.
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.
⯆ Blog post: https://www.xelplus.com/excel-find-and-replace/
LINKS to related videos - Excel basics playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyx1KSoobwukzf1Nf-Y97Rw0
★ My Online Excel Courses ► https://courses.xelplus.com
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
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!
#MsExcel
Видео Excel's Find and Replace (surprising features) канала Leila Gharani
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Excel IF Function with PARTIAL Text Match (IF with Wildcards)](https://i.ytimg.com/vi/b9WoDkPOTPs/default.jpg)
![Save Hours with (The Best) Find & Replace Tricks for Excel](https://i.ytimg.com/vi/CEK6OuqKoyk/default.jpg)
![3 EASY Ways to Find and Remove Duplicates in Excel](https://i.ytimg.com/vi/ADArCWLz55Y/default.jpg)
![How Power Query Will Change the Way You Use Excel](https://i.ytimg.com/vi/6lBqYInBldk/default.jpg)
![Find and Replace Multiple Values in Excel - ALL AT ONCE!](https://i.ytimg.com/vi/X7x1DG_GSQc/default.jpg)
![Change CASE of text in Excel (3 ways including NO Formulas)](https://i.ytimg.com/vi/LN6BB5p6lGc/default.jpg)
![Return Multiple Match Results in Excel (2 methods)](https://i.ytimg.com/vi/fDB1Ktyhp3Y/default.jpg)
![SUPER EASY Excel Data Entry Form (NO VBA)](https://i.ytimg.com/vi/cNpFB8M1-dI/default.jpg)
![](https://i.ytimg.com/vi/GxyZKHr86oQ/default.jpg)
![SURPRISING Advanced Filter TRICK in Excel (You've Never Heard Of!)](https://i.ytimg.com/vi/evrnIuDRtsQ/default.jpg)
![Quick Excel Trick to Unstack Data from one Column to Multiple Columns](https://i.ytimg.com/vi/rscXNUlRsH0/default.jpg)
![Find and Replace Multiple Values in Excel using VBA Macro](https://i.ytimg.com/vi/bjPxRty00QU/default.jpg)
![Excel - Find and Replace trick](https://i.ytimg.com/vi/BpfqN2wPD1g/default.jpg)
![Excel Complex Lookup: Find Header based on Lookup Criteria in Matrix with INDEX & SUMPRODUCT](https://i.ytimg.com/vi/OJLfPc9YlqE/default.jpg)
![How to Find and Replace Multiple Values in Excel - All at once](https://i.ytimg.com/vi/xI5wOwPrEI0/default.jpg)
![Searchable Drop Down List in Excel (Very Easy with FILTER Function)](https://i.ytimg.com/vi/Z-h2UER3b_0/default.jpg)
![All about Excel Comments (Notes) in 8 Minutes! Shortcut Keys, Customize Background & More](https://i.ytimg.com/vi/2PhaaEWY1pQ/default.jpg)
![Master Excel's SUMPRODUCT Formula](https://i.ytimg.com/vi/lzjc_eEISe8/default.jpg)
![Remove ALL Unwanted Spaces in Excel (TRIM ALL Function?)](https://i.ytimg.com/vi/ZKgosgTo38I/default.jpg)
![Excel shortcut keys you SHOULD know!](https://i.ytimg.com/vi/Xe4U_-o_EWw/default.jpg)