Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is it possible to sort a spreadsheet based on if a word is contained in cells within a column?

Like if I take the "title" column and sort, keeping the rows connected, to bring all the rows with a certain word to the top?

share|improve this question
up vote 0 down vote accepted

i am gonna go ahead and answer this for posterity's sake. what you wanna do here, bboy, is highlight your column and look for the 'conditional formatting' box, it is a bit harder in older editions, but 2011 is proper quick with a button under your 'home' workspace.
so you hit 'conditional formatting' with your column highlighted and 2011 gives you a dialog box that allows you to highlight based on 'text contains...' insert your text and all the cells with that token will change color.
you can then go to 'data' and 'sort' , sort the entire sheet based on the appropriate column based on 'cell color' instead of 'value'.
this will give you the effect you are looking for, older versions need to use a function applied to the whole column something like =stringcontains(text), not that exactly but its logical equivalent.
hope this helps and you havent found a way to travel into the future, learn the answer, post the answer, travel back in time, and read the answer with no knowledge of said time-travel

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .