Microsoft Office Questions? Ask a IT Expert for Support ASAP
Greetings! My name is ***** ***** I am happy to assist you today!
Regarding highlighting multiple rows with the same word, there is a nice tutorial on this here: https://exceljet.net/formula/highlight-rows-that-contain
From there , it should be simple to cut and paste them to the top of the page, and then highlight them since they are already selected.
Well, the tutorial runs through setting up a formula. What you can always do is set up a macro that runs that formula, and then set it up with a link in your quicklinks toolbar to make it turn-key.