How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Joseph Varner Your Own Question

Joseph Varner
Joseph Varner,
Category: Microsoft Office
Satisfied Customers: 36
Experience:  Enterprise Support Specialist at Arthur J Gallagher
94318210
Type Your Microsoft Office Question Here...
Joseph Varner is online now
A new question is answered every 9 seconds

Can you tell me with a MS Office 2013 excel spreadsheet that

Customer Question

Hi. Can you tell me with a MS Office 2013 excel spreadsheet that has thousands of rows - how do I tell it to search for a word in every row, (the word would always be in one particular column) and move those rows together to the top of the sheet, and highlight the rows in a color?
Submitted: 4 months ago.
Category: Microsoft Office
Expert:  Joseph Varner replied 4 months ago.

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.

Customer: replied 4 months ago.
Ok, so there is not a way to sort those rows automatically to the top?
Expert:  Joseph Varner replied 4 months ago.

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.