I want columns of worksheet to become rows and vice-versa.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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/com...dg=microsoft.public.excel.worksheet.functions
 
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
(e-mail address removed)> wrote in message
news:[email protected]...
 
You must log in or register to reply here.

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

Convert Decimal fractions to binary and vice versa 1
Hightlighted Worksheets Hard to See 1
Office Excel Worksheet 1
Excel should allow at least 2 vertical and horizontal splits. 1
Ability to sort data in Excel by fill color 2
Scroll tabs 3
DATEDIF FUNCTION NOT LISTED IN HELP 2
On protected Excel sheet users be able to group/ungroup rows/colum 2

Back
Top