Possible to "rotate" range of cells so columns are rows and vice versa?

  • Thread starter Thread starter davidmichaelkarr
  • Start date Start date
D

davidmichaelkarr

Is it possible to select a rectangular range of cells and then generate
a copied range of cells that is a rotation of the first range, where
the columns are the rows, and vice versa?
 
Maybe

copy, then paste special and select transpose

Regards,

Peo Sjoblom
 
Never mind, I discovered "Paste Special" and "Transpose".
 
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 do I swap data in columns and rows around? 2
VBA set thick borders around non empty cells in range 0
Convert Decimal fractions to binary and vice versa 1
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Can I rotate excel sheets so columns are rows & vice-versa (i.e.. 3
Trying to run excel vba code when cell value changes from empty to entered value. 1
MACRO RUN random percentage and copy of column values 1

Back
Top