View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Redirection After Cutting

Think it simply depends on where is the active cell in your selection of the
range. If you select the range A20:T900 from the bottom right cell T900
upwards and left to A20, then you click on cut, you're brought back to where
the active cell, ie T900 is visible. If you select from A20 downwards and
right to T900, then you click on cut, then you'd be brought back to where the
active cell A20 is visible. Instead of selecting large ranges with the mouse,
perhaps just simply type in the range, eg: A20:T900 in the name box*, then
press ENTER to select it. That way, it would be faster to select, and the
active cell would always be the top left cell within the range.

*box with the drop arrow just above the col header "A", to the left of the
formula bar
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dnamertz" wrote:
When using Excel 2002 on my desktop PC, when I highlight a large section of
data to cut, once I've scrolled to the end of the range I'm highlighting and
click on "cut", I'm automatically taken back to the upper-left section of the
highlighted range. But, on my laptop PC, using Excel 2003, when I click on
"cut" I am not taken back up to the upper-left section of the range. I am
instead left down at the bottom end of the highlighted range.

Is there a setting that allows me to choose where I want to be taken to
after I cut a range of data?

In case my explaination doesn't make sense, here is an example. If I
highlight the range of A20 down to T900, when I select "cut" I want the cell
A20 to be showing on the screen instead of T900. Otherwise I have to scroll
back up to get to the top of the range, which is a waste of time since I want
to repaste the data a few rows below A20 (and "insertsing rows" won't work in
this instance).