If you want to rearrange the data, you have to clip the data, insert a new
column where you want it and then paste the info and delete the column the
data was in.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

If the destination column is empty, you can simply drag the existing column
to the new location and drop it. (click on the column header, then left click
and drag the heavy border that appears). Alternately, you can right click
the border and drag; when you drop you get a menu of options

If the destination column isn't empty, click on the column header, press
Ctrl-X, click on the destination, and use Alt-I, Enter

"Kerk Farrell" wrote:

If you want to rearrange the data, you have to clip the data, insert a new
column where you want it and then paste the info and delete the column the
data was in.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

Kerk,

Actually, you can.

Select the column, then shift-click the outline of the column (the selection border), and drag into
place.

HTH,
Bernie
MS Excel MVP


"Kerk Farrell" wrote in message
...
If you want to rearrange the data, you have to clip the data, insert a new
column where you want it and then paste the info and delete the column the
data was in.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions