Posted to microsoft.public.excel.programming

wcc[_3_]

external usenet poster

Posts: 7

switch rows & columns?

Hello group,

Within a selection of cell ranges, is there a quick way to switch the
rows and columns? For example, change

1 A AA
2 B BB
3 C CC

to

1 2 3
A B C
AA BB CC

Thank you.

- wcc

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Switch from Columns <- Rows	Alain Dekker	Excel Discussion (Misc queries)	5	July 29th 09 02:49 PM
+++Switch Rows & Columns	Ian	Excel Worksheet Functions	1	April 13th 07 12:46 PM
switch rows and columns	tomba545	New Users to Excel	3	June 6th 06 09:48 AM
Switch Rows and Columns	Bonnie	Excel Discussion (Misc queries)	3	March 3rd 05 03:38 PM
Switch Columns for Rows	Annette[_4_]	Excel Programming	1	September 9th 04 10:36 PM

All times are GMT +1. The time now is 09:49 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us