5

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!

Mike Cole
  • 431
  • 3
  • 12
  • 28
  • 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
  • 4
    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](http://superuser.com/questions/873242/is-there-a-way-to-skip-down-to-the-next-change-in-value-in-excel)). – Tyler James Young Feb 04 '15 at 16:13
  • 4
    Possible duplicate of [Is there a way to skip down to the next change in value in Excel?](https://superuser.com/questions/873242/is-there-a-way-to-skip-down-to-the-next-change-in-value-in-excel) – Alex M Oct 17 '19 at 18:16
  • From the duplicate question: Highlight the column, press `Ctrl`+`Shift`+`\\` – Engineer Toast Dec 14 '21 at 13:35

0 Answers0