Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jody R - Trees
 
Posts: n/a
Default Excel - move between columns

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.
  #2   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

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..
--
Earl Kiosterud
www.smokeylake.com.

"Jody R - Trees" <Jody R - wrote in message
...
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.



  #3   Report Post  
HansM
 
Posts: n/a
Default

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?
--
HansM

"Jody R - Trees" <Jody R - wrote in
message ...
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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Brake & Move Columns Dale Excel Worksheet Functions 1 June 20th 05 03:43 PM
How do i copy columns of data in notepad into microsoft excel? JP New Users to Excel 2 February 10th 05 09:47 PM
command button in excel will move when print. [email protected] Excel Discussion (Misc queries) 1 December 29th 04 03:53 PM
Columns in Excel will not allow user to click in them Kim Excel Discussion (Misc queries) 1 December 28th 04 06:37 PM
In Excel can I move the tabs to the left side of the workbook? kit Excel Worksheet Functions 1 December 6th 04 08:15 PM


All times are GMT +1. The time now is 05:19 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"