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

Some Excel jockey told me how to do this once, but I've forgotten.

Basically I have a huge list sorted by a STATUS column. I'd like to press the down key and go to the next changed value in the column, so I can easily navigate all statuses. I know there's a certain key command do this.


share|improve this question
Are you sure the rows weren't grouped – Dr. belisarius Feb 17 '11 at 14:35
Yes, I'm sure. I distinctly remember this person sorting by a certain column, and then hitting a hotkey + down arrow to skip to the row where the value changed. – Mike Cole Feb 17 '11 at 14:41
Hold ctrl + shift while you press two keys in sequence: once to select the rest of the column, then | (vertical bar, backslash key) once to select column changes and jump to the next one (from here). – Tyler James Young Feb 4 '15 at 16:13

Could be (s)he had written a macro and assigned it to a keyboard shortcut

Sub GoToNextGroup()
    Loop Until ActiveCell <> ActiveCell.Offset(-1,0)
End Sub
share|improve this answer
Nope, I remember because after they had shown me I used it on my machine several times. – Mike Cole Feb 20 '11 at 4:59

You must log in to answer this question.

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