Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

Thanks!

share|improve this question
    
Are you sure the rows weren't grouped –  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

1 Answer 1

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

Sub GoToNextGroup()
    Do
        ActiveCell.Offset(1,0).select)
    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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.