Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Brake & Move Columns | Excel Worksheet Functions | |||
How do i copy columns of data in notepad into microsoft excel? | New Users to Excel | |||
command button in excel will move when print. | Excel Discussion (Misc queries) | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
In Excel can I move the tabs to the left side of the workbook? | Excel Worksheet Functions |