Horizontal Cells changed to Vertical cells

  • Thread starter Thread starter hoffman3
  • Start date Start date
H

hoffman3

I have seen the solution awhile ago when I visited this board frequentl
but I am unable to locate it now. I have a spreadsheet with values i
rows but i want to switch these values into columns.
As so:

abcde


a
b
c
d
e
Thanks in advance,

Hoffman
 
Is there a reason that you can't just use Transpose from Paste Special?

Since you've posted into this programming thread, I guess you're
looking for code, so:
Selection.Copy
Range("D9").PasteSpecial Paste:=xlPasteAll, Transpose:=True
 
Copy the cells and then position the cursor somewhere else and use Paste
Special | Transpose

Regards

Trevor
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to use Sumifs with vertically and horizontally criterias 3
copy formulas from horizontal cells into vertical cells. 1
Vertical Database to Horizontal? 4
Totalling then Averaging subject to Product Code change 3
Search for empty cells and move cells next to 10
change cells contents from vertical to horizontal 2
Excel Vertical to horizontal repeat after 16 rows 3
Range to find matches to copy values 5

Back
Top