If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how do i rearrange columns in a work sheet
I have a spresdsheet filled in with titles of the columns and information
within each column. How can I rearrange the columns? for instance Column A is titled Date, B is titled Time, C is titled Vehicle Info, etc.... I would like to replace the location of column a with column B -- JFL |
#2
|
|||
|
|||
how do i rearrange columns in a work sheet
Use a practice sheet and put in some practice data, select the entire
column, then simply cut and paste the columns, after you see how easy it is, then do your "real" sheet. "Glenn" wrote in message ... JakeMc wrote: I have a spresdsheet filled in with titles of the columns and information within each column. How can I rearrange the columns? for instance Column A is titled Date, B is titled Time, C is titled Vehicle Info, etc.... I would like to replace the location of column a with column B Look at "Move rows or columns" in the help file. |
#3
|
|||
|
|||
how do i rearrange columns in a work sheet
I tried that, followed directions and it did not work. All it did was stretch
the column not move it. -- JFL "Glenn" wrote: JakeMc wrote: I have a spresdsheet filled in with titles of the columns and information within each column. How can I rearrange the columns? for instance Column A is titled Date, B is titled Time, C is titled Vehicle Info, etc.... I would like to replace the location of column a with column B Look at "Move rows or columns" in the help file. |
#4
|
|||
|
|||
how do i rearrange columns in a work sheet
JakeMc wrote:
I have a spresdsheet filled in with titles of the columns and information within each column. How can I rearrange the columns? for instance Column A is titled Date, B is titled Time, C is titled Vehicle Info, etc.... I would like to replace the location of column a with column B Look at "Move rows or columns" in the help file. |
#5
|
|||
|
|||
how do i rearrange columns in a work sheet
JakeMc wrote:
I tried that, followed directions and it did not work. All it did was stretch the column not move it. The direction I see are as follows: Move rows or columns 1. Select the row or column you want to move. 2. Click Cut. 3. Select a row or column below or to the right of where you want to move your selection. 4. On the Insert menu, click Cut Cells. I can't see any way that following these instructions would "stretch" a column. |
#6
|
|||
|
|||
how do i rearrange columns in a work sheet
Select the entire column, then Shift+Left Mouse Button anywhere on the
**border** of the **selection** and drag it to where you want it to go (there is a light vertical line that will follow the mouse as you drag it to show you were the selected column will be placed). -- Rick (MVP - Excel) "JakeMc" wrote in message ... I have a spresdsheet filled in with titles of the columns and information within each column. How can I rearrange the columns? for instance Column A is titled Date, B is titled Time, C is titled Vehicle Info, etc.... I would like to replace the location of column a with column B -- JFL |
Thread Tools | |
Display Modes | |
|
|