hi,

select the range, copy , right click, paste special, tranpose

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Paula" escreveu:

How can I change the direction the sheet is filled from rows to columns?