You just finished typing a spreadsheet, complete with formulas and formatting; then you realize that the data orientation should be flipped from horizontal to vertical (crucial if you plan to perform database operations). Before you start reentering the data, check out your spreadsheet’s Transpose feature.
In Excel, select the range to be transposed, and choose Edit > Copy. Next, click the upper left cell of the new range and select Edit > Paste Special. In the Paste Special dialog box, select the Transpose option and click OK. Excel automatically adjusts formulas in the original range.