up vote 0 down vote favorite
share [g+] share [fb]

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.

link|improve this question
Your active cell shouldn't move, it should stay at the absolute location it was at before, but it won't move with what you had selected. You don't want your view to change back up to the top? – Raystafarian Feb 19 at 14:17
No. I'm wanting my view to stay down where I was in the list. I can't figure out why the view changes, but the active cell stays where it was. Seems silly. Seems like the view would stay on the active cell. – Jason Smith Feb 19 at 14:52
1  
Unfortunately, this cannot be changed – Raystafarian Feb 19 at 16:45
feedback

1 Answer

up vote 0 down vote

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.

  • To stay on the same row, press Left or Right.
  • To stay on the same column, press Up or Down.

I generally press Left & Right or Up & Down so that I've returned to the exact same cell that was active prior to the sort.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.