Sort Repeat Using F4
 

I used to be able to use the F4 key to repeat a data sort on different rows
of data. All the columns are the same, but the rows vary and each "section"
has to be sorted individually. F4 was perfect in Excel 2003. Does anyone
know of a different way to repeat the sort function? The repeat function
still works for other things, like inserting rows. Please help, i just
switched to Excel 2007 and i use the repeat function every day.

thanks.