importing rows to cols

M

Milco

I have a spreadsheet with dates in row 1, cols A to IV and $ in row 2, cols A
to IV. Obviously I have run out of columns and will switch to rows. How do
I import row 1 to col A and row 2 to col B?
 
J

JudithJubilee

Hello Milco,

Highlight you cells and press Ctrl + X (Cut). Right click A1 and choose
Paste Special. Check the Transpose button and OK.

Judith
 
M

Milco

Thanks for quick reply. Unfortunately Paste Special is grayed out so I can't
select it.
 
Top