keyboard shortcuts - Is there a way to skip down to the next change in value in Excel?

For my current daily use of Excel, I have a sheet where hundreds of consecutive rows have the same value for a particular column. I’d like a way to quickly skip down to the next different value.

ctrl + ↓ goes to edge (i.e. the end or the next break in data), but I want to only skip identical cells.

I am looking for a keyboard command, not a macro or an extension-dependent solution.

The solution must work for a column of formula-populated cells. The formula in question:

=VLOOKUP($N19377,'Dates and Codes'!$B:$D,2,FALSE)

Answer

You can use the Go To feature to get to the next different cell.

1. Highlight the column you are interested in


2. Press Ctrl+Shift+\

The first different cell within that column will be selected.

Step 2 is the shortcut for the following steps:

1. Press F5 to bring up the Go To menu


2. Click Special..., click Column Differences, and then click OK.

For more information see the Excel Help Documentation: Find and select cells that meet specific conditions.