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

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.

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.

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.

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.

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