How to Use the Paste Special Command in Excel

Switching Rows of Cells to Columns or Columns to Rows
1. Select the cells that you want to switch.
2. Open the Edit menu and select Copy.
3. Select the upper left cell of the paste area. The paste area must be outside the copy area.
4. Open the Edit menu and select Paste Special.
5. Select the Transpose check box.
6. Click OK.
Pasting Only Values, Formulas, Comments, or Cell Formats
7. Select the cell or range of cells you want to copy.
8. Open the Edit menu and select Copy.
9. Click the cell you want to paste the information into, or click the upper left boundary of the cell range you want to paste the information into.
10. Open the Edit menu and select Paste Special.
11. Select Formula to copy only the formula of the cell.
12. Highlight Values to copy only the outcome of the formula you copied into the cell and not the formula itself.
13. Select Format to copy just the format of the cell (font, alignment, and so on).
14. Choose Comments to copy only annotations for the cell.
15. Click OK to accept the option you selected.