How do I sort in Excel 2007 but do not go to the top of the list? I have a filtered set of data many rows long. However, when I am deep in the list, and select to change the sort by method on one of the columns, my active cell is moved all the way back up to the top of the list. This seemed to change with Excel 2007 over previous versions.
When you sort in Excel 2007 the window jumps up to show the top of your list, but the active cell is still on the same row it was before you sorted. To move the visible window back to the active cell, use the arrow keys.
I generally press