Find All Cells With A Certain Type Of Formatting – With This Cool Find Trick!


the-vlookup-book-ebook-combo

This is a really cool Excel trick that can potentially save your a tonne of time.  By the using the Find functionality in Excel we can find all the cells that meet your chosen formatting criteria, select all of those cells, then change them all at once. How neat is that. Come on let’s see how easy it is…

  • First open the Find dialog box by hitting CTRL+F
  • Click on the Options Button to enable us to find Formatting within the worksheet
  • Select the formatting you are looking for by selecting Choose Format From Cell
  • Hit Find All- Excel will show you a preview of the formatting
  • Hit CTRL+A to select ALL of the cells that Excel has found with this formatting

297695102297695302

In my example I am looking to select all of the cells with black bold text and orange background.  Once all of the cells are selected I can go ahead and carry out the replacement of this formatting style.

  • Hit close on the Find and Replace dialog box after you have selected all of the cell Excel has found with the formatting- all of the cells will still be selected venen when you hit the Close Button
  • Go ahead and change your selected cells to the new formatting stye you want
  • The new style will be automatically applied to all of the selected cells
  • Magic!

More Excel Tips

Why you NEED to know about Pivot Tables

Refresh all of your Pivot Tables with one click

Delete obsolete items from your Pivot Tables blog post or watch the YOUTUBE video..

[amazonjs asin=”1118490363″ locale=”US” tmpl=”Small” title=”Excel 2013 Bible”]

[amazonjs asin=”1118510127″ locale=”US” tmpl=”Small” title=”Excel 2013 For Dummies”]

[amazonjs asin=”B01B1VANVM” locale=”US” tmpl=”Small” title=”Excel: Bootcamp Learn the Basics of Microsoft Excel in 2 Weeks! (FREE Bonus, Excel 2016,Microsoft Excel) (FREE Books, Windows 10 Books, Windows)”]

 

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts