Make the column reference letter absolute by placing a $ in front of it or
pressing f4 with the reference highlighted. (As in $Q1) then paste special
transpose.
--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"Polina" wrote in message
...
I have a list of data in a column and I want to paste the list somewhere
but
I want the paste to work this way I need it to paste the list in column Q
by
row so I want it to paste Q1,Q2,Q3 instead is pastes Q1,R1 and I think its
because I am pasting across and not down, but is there any way I can get
around this