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

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 ?

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

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.

--
Jim
"chriso" wrote in message
...
|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 ?