Paste Special

S

SJT

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

Gord Dibben

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
 
S

SJT

Thank you very much.

Gord Dibben said:
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
Click to expand...
 
Top