Skip To Main Content

Menu

Main Content

Excel Tip: Transpose rows and columns.

Nov 16

Written by: Senior Instructor
11/16/2007 2:20 PM

Let’s say you have a column of data that you want to change into a row, or you have a row of data that you want to change into a column. Moving the data manually, one item at a time, would be very time consuming. To save time, you can use the Paste Special command to quickly transpose data from columns to rows and vice versa.

  • Select the data range you would like to transpose.
  • Copy the data to the clipboard by clicking Edit > Copy from the menu.
  • Select a destination cell for your data, then click Edit > Paste Special from the menu.
  • In the Paste Special dialog, check Transpose, and then click OK.

Trackback Print
Location: Blogs Tips, Trips & Traps
Tags: