how do I promote the highlighted rows to the top?

harry · Oct 13, 2004

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 · Oct 13, 2004

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 · Oct 13, 2004

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

how do I promote the highlighted rows to the top?

harry

Ron de Bruin

Frank Kabel