I have a database where I would like to switch the contents in column c and
put it in column d and vice versa. Is there a means of accomplishing this
using "paste special" or some other means or am I just better off inserting a
column and then deleting a column? Thank you in advance for your assistance.

Select Column D header to get all of D

Hold SHIFT key and slide cursor down to side of column in first row.

Will change to a 4-headed arrow.

Click and move the Column C.

D will drop and C will move right.


Gord Dibben MS Excel MVP

On Wed, 9 Aug 2006 15:49:22 -0700, SJT wrote:

I have a database where I would like to switch the contents in column c and
put it in column d and vice versa. Is there a means of accomplishing this
using "paste special" or some other means or am I just better off inserting a
column and then deleting a column? Thank you in advance for your assistance.

Thank you very much.

"Gord Dibben" wrote:

Select Column D header to get all of D

Hold SHIFT key and slide cursor down to side of column in first row.

Will change to a 4-headed arrow.

Click and move the Column C.

D will drop and C will move right.


Gord Dibben MS Excel MVP

On Wed, 9 Aug 2006 15:49:22 -0700, SJT wrote:

I have a database where I would like to switch the contents in column c and
put it in column d and vice versa. Is there a means of accomplishing this
using "paste special" or some other means or am I just better off inserting a
column and then deleting a column? Thank you in advance for your assistance.