Flipping columns to rows

  • Thread starter Thread starter Hinojosa via OfficeKB.com
  • Start date Start date
H

Hinojosa via OfficeKB.com

Is there a way to flip the current columns that you have, so that they will
be rows?
 
No, but you can "flip" cell contents using either the function TRANSPOSE
or COPY followed by Paste Special with Transpose selected.
best wishes
 
Hi there,
Highlight the area to be changed from Columns to Rows.
Right-click in the highlighted area and select "Copy" from the menu options.
Go to another area of the worksheet... a blank area.
Right-click on that empty cell and select "Paste Special" and select
"Transpose" and then "OK".
You will now see a copy of your columnar data displaying in a row format.
Hope this helps,
Joe
 

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

Flipping numeric values 3
Excel Fit to page print options in Excel 1
columns to rows flip 3
IS there a way to invert rows? 2
Flip template slide 180 degree? 0
how to flip an excel table? 1
Flipping data - columns to rows and visa versa 2
Can I flip a symbol? 1

Back
Top