Please Note: This article is written for users of the following Microsoft Excel versions: 2007 and 2010. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Quickly Transposing Cells.
Written by Allen Wyatt (last updated June 21, 2021)
This tip applies to Excel 2007 and 2010
You probably know the feeling—you start creating a worksheet, get a good way into it, and realize that you should have made your columns into rows and your rows into columns. In other words, you want to turn your data by 90 degrees and continue working with the sheet.
Fortunately, Excel provides an easy way to accomplish this very task. In Excel's terminology, this process is known as transposing data. To transpose your data, follow these steps:
Notice that in step 2 you must use the copy command (Ctrl+C) rather than the cut command (Ctrl+X). This is because you can't choose Paste Special from the Edit menu when you cut information. For this reason, you may want to copy information from one worksheet (steps 1 and 2) and paste it into another (steps 3 through 5). You can play with this method of pasting and select the method that is best for you.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (6248) applies to Microsoft Excel 2007 and 2010. You can find a version of this tip for the older menu interface of Excel here: Quickly Transposing Cells.
Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results. This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables. Check out Microsoft Excel 2013 Data Analysis and Business Modeling today!
Excel's Paste Special command is used quite a bit. If you want to create some shortcuts for the command, here's some ways ...Discover More
If you need to update a bunch of values in a worksheet by a standard amount, you can use the Paste Special feature of ...Discover More
The Paste Special feature in Excel can be used to uniformly adjust values and formulas. This tip shows how powerful this ...Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.