Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Flipping columns to rows
Is there a way to flip the current columns that you have, so that they will
be rows? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200709/1 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Flipping columns to rows
No, but you can "flip" cell contents using either the function TRANSPOSE
or COPY followed by Paste Special with Transpose selected. best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Hinojosa via OfficeKB.com" <u27679@uwe wrote in message news:77c5847d20003@uwe... Is there a way to flip the current columns that you have, so that they will be rows? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200709/1 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Flipping columns to rows
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 "Hinojosa via OfficeKB.com" wrote: Is there a way to flip the current columns that you have, so that they will be rows? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200709/1 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Flipping columns to rows
Perfect!!!! exactly what i needed thanks both of ya'll!!
JoeAdidas21 wrote: 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 Is there a way to flip the current columns that you have, so that they will be rows? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200709/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
Flipping a Spreadsheet | Excel Worksheet Functions | |||
flipping a spreadsheet | Excel Worksheet Functions | |||
Flipping the order around? | Excel Discussion (Misc queries) |