Channel | Publish Date | Thumbnail & View Count | Actions |
---|---|---|---|
| 2019-10-21 12:30:00 | ![]() 91,502 Views |
You can do this easily using the Find and Replace dialog box. There is an option in the Find and Replace dialog box which allows you to select the formatting from a cell and then finds all the cells that have the same formatting.
You can use this to select the cell with bold font formatting and then find all the cells that have bold text.
Once you have selected these, you can easily highlight these, change the formatting, or delete the cells/rows.
This video is a part of my ‘Excel is two-minute’ series, where I share simple and quick tips to help you speed up your work and be more efficient
Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos – https://www.youtube.com/c/trumpexcel
This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel.
It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.
You can find a lot of useful Excel resources on the following site: https://trumpexcel.com/
Free Excel Course – https://trumpexcel.com/learn-excel/
Paid Online Training – https://trumpexcel.com/excel-training/
Best Excel Books: https://trumpexcel.com/best-excel-books/
️ Gear I Recommend:
Camera – https://amzn.to/3bmHko7
Screen Recorder – techsmith.z6rjha.net/26D9Q
USB Mic – https://amzn.to/2uzhVHd
Wireless Mic: https://amzn.to/3blQ8uk
Lighting – https://amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Please take the opportunity to connect and share this video with your friends and family if you find it useful.