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

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

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

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