Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel training - Transposing

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

advanced excel training - Transposing

Resolved · Low Priority · Version Standard

Reply Wed 21 Feb 2007, 10:04Delegate Gurmit said...

Gurmit has attended:
Excel Advanced course

Transposing

How can I transpose a Spreasheetcolumn headers to appear in the rows instead ?

ie- I have created a spreadsheet with products on the headers and have just realised that there are so many products and I now need to bring these products down into the Rows.

For upcoming training course dates see: Pricing & availability

Reply Wed 21 Feb 2007, 10:19Trainer Garry said...

RE: Transposing

The columns and rows are all wrong, you have to swap all the Excel
books and sheets. All you have to do is:
Highlight the header rows then copy then go to edit on the menu bar
paste Special the select transpose

Excel articles

· Customized Financial Excel Courses in London
· Learn The Secrets Of COUNT Functions In Excel
· Charting Your Success With Excel 2007
· How To Insert, Delete, Format, Hide, Copy And Protect Worksheets In Excel
· Which Is Better, Excel Or Access?

Excel tip:

Shortcut for deleting all comments in a spreadsheet

If you have entered multiple comments into a spreadsheet and wish to delete them all at once, you can achieve this by:

1. Holding down Ctrl, then Shift, then O - this will select all cells containing comments in the worksheet you are looking at.

2. Right-clicking on one of the selected cells, and selecting Delete Comment from the menu that appears.

3. Clicking anywhere else in the spreadsheet to deselect comments - all comments should have disappeared from the spreadsheet.

View all Excel hints and tips