Welcome toExcel2007.Tips.Net
Helpful Links
Car Tips
Cleaning Tips
Money Tips
Word2007 Tips
Newest Tips
Using Conditional Formatting to Shade Rows
Making Sure Duplicate Names Aren't Entered
Applying a Conditional Format to a Full Row
Subscribe
Quickly Transposing Cells
Summary: If you want to turn a range of cells by 90 degrees within a worksheet, you need to understand how Excel can handle the transposition for you. Here's the absolute quickest way.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:
- Select the range of cells you want to transpose.
- Press Ctrl+C to copy the data from the worksheet and place it in the Clipboard.
- Select the cell that will be at the top-left corner of your newly transposed data.
- Display the Home tab of the ribbon.
- Click the down-arrow under the Paste tool at the left side of the ribbon. Excel displays some pasting options.
- Choose Transpose. Your data appears at the point you specified, but it is transposed.
Related Tips:
Create and Merge! Using Word's mail merge tool you can quickly and easily combine data from a variety of data sources to create great individualized documents that incorporate your data in ways that you control. WordTips: Mail Merge Magic is an invaluable source for learning how to harness the full power of Word's mail merging capabilities. Check out WordTips: Mail Merge Magic today!