Quickly Transposing Cells

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:

1. Select the range of cells you want to transpose.
2. Press Ctrl+C to copy the data from the worksheet and place it in the Clipboard.
3. Select the cell that will be at the top-left corner of your newly transposed data.
4. Display the Home tab of the ribbon.
5. Click the down-arrow under the Paste tool at the left side of the ribbon. Excel displays some pasting options.
6. Choose Transpose. Your data appears at the point you specified, but it is transposed.