Finding and extracting Data only if it is in BOLD

[Zack99]

Hey everyone,

Within my data, I have bolded the rows that are useful to me. I would like to take only those bold rows, while leaving the non-bold rows behind.

Hope this is clear!

Thanks

[benishiryo]

hi Zack99, is the entire row bold? if so, you can do this:

CTRL + F to find -> Options -> Format -> Font -> Font Style: Bold -> OK -> Find All
you will see a whole list they searched for you. scroll to the end of it and while holding on to the SHIFT key, left click your mouse on the last entry. that will highlight all the bold cells. close the Find window & you can now copy them to wherever you want it. to delete them, go to Home -> Delete -> Delete Sheet Rows.

if the entire row is not bold, but you want to highlight the entire row when 1 cell is bold, do a longer way. use the same step as above to find & still select the results they found. this time, instead of copying, highlight them with a colour. with Excel 2007/2010, you can autofilter by cell colour. so filter by the colour you chose, and you can copy those rows.

hope that helps