how do i rearrange columns in a work sheet

J

JakeMc

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
 
M

Meebers

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.
 
J

JakeMc

I tried that, followed directions and it did not work. All it did was stretch
the column not move it.
 
G

Glenn

JakeMc said:
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.
 
G

Glenn

JakeMc said:
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.
 
R

Rick Rothstein

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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top