Hi,

Select the range of interest
Edit | Copy
Select a cell below the range
Edit | PasteSpecial | Transpose | OK
Delete the original data.

---
Regards,
Norman



"Swapping rows and columns" <Swapping rows and
columns@discussions.microsoft.com> wrote in message
news:27E898BB-E70B-4552-AED3-E943893A5C8B@microsoft.com...
> If I create a worksheet with some names in the rows (e.g: months) and some
> other names in the columns (e.g: emoluments), and I wish to have
> emoluments
> in the rows and the months in columns, is there any shortcut for this?
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow
> this
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.
>
> http://www.microsoft.com/office/comm...heet.functions