Excel - move between columns

J

Jody R - Trees

I enter tree counts for a Christmas tree farm and want to move from the
bottom of column A to the top of column E, etc. automatically after entering
the information. How can I do this? Thanks.
 
E

Earl Kiosterud

Jody,

Probably not enough information. You can select the stuff at the bottom of
col A, Cut, and at the top of col E, do either paste, or insert cut cells.
The latter may change formula references to these cells, and will push the
stuff below that point downward..
 
H

HansM

If you're just doing two columns A & E, select the part of column E you want
to work with, hold down CTRL and select the part of column A you want to
work with. Now let go of the Control key. You should be at the first
selected cell of column A. Enter info while the cells are selected and
you'll be moved from column A to column E.

If you want to do this for three columns, select the second column first,
then the third and finally the first one. Start entering and it will move
from column 1 to 2 to 3. This will work for many columns, just be sure to
start by selecting the second column and the last one to select is the first
column you're starting with.

Maybe someone has a better idea? Or does this not address the question?
 
Top