how do I promote the highlighted rows to the top?

[harry]

As title.
After viewing a big file and highlighted several rows with yellow, I am
planing to goback to change or relook those rows.
How do I move all those rows to the top of the spreadsheet?

Thanks

 

[Ron de Bruin]

Hi harry

Why don't you use Conditional formatting to highlighted a row.
For example when you enter a "x" in column A.
http://www.contextures.com/xlCondFormat02.html

This way you can use AutoFilter to Filter on The "x"

 

[Frank Kabel]

Hi
see:
http://www.cpearson.com/excel/SortByColor.htm