How do I find a change of data in an excel column ?

C

chriso

I use large spreadsheets with the same data in a column. Once sorted I want
to jump to where the data changes. What is the key sequence used ?
 
J

Jim Rech

You can use the Goto Special Column Differences feature.

-Select the column.
-Press F5, Special, select Column Differences and OK.
-Press F4 thereafter to repeat.
 
Top