Transpose Excel Rows and Columns [Quick Tip + Video]

Posted on November 18th, 2009 in Excel Howtos , Learn Excel - 2 comments

Transpose Excel Rows and Columns - Howto Transposing rows and columns in a table is one of the most useful tricks when you are pasting data. Yet, it always surprises me that very few people actually know this. So here it is,

To transpose a table of data from rows to columns (or columns to rows)

Select the table, press CTRL+C
Goto an empty cell
Right click and select Paste Special (alternatively press ALT+E followed by S)

Transpose Excel Rows and Columns - using Paste Special

Select “Transpose” check box, it is above the OK button.
Click Ok. Transposed your data is.

I have made a 15 second tutorial on this. See it below:

(Watch the tutorial on youtube, you can also see it in HD)

15 more tips on pasting data in excel | Transpose Charts | More Quick Tips | More Excel Video Tutorials

| More

Posts & Navigation

Tags: 15sectuts, Excel 101, Excel Howtos, Learn Excel, paste-special, spreadsheets, tips, transpose, tricks, using excel, videos

Comments

dave November 18, 2009

Just pressing the underlined letter for each of the Paste Special options will select it. (Some of them will cancel out others, like add or subtract.)

So you can just do:
– Select
– Ctrl-C
– move
– Alt-E, S, E, Enter

And you’re done.

A super snappy way to copy a whole tab to values is along similar lines:

– Ctrl-A
– Ctrl-C
– Alt-E, V, Enter

And Boom! You’ve just copied everything on the current page as a value on top of itself. Useful if you just want to give someone the values, but not the underlying formulae.

Jason December 1, 2009

Very nice! Your explanation was short and to the point. However, the video was a little too fast.

RSS feed for comments on this post. TrackBack URI