Tip Printed from ExcelTip.com

---

Transposing Cells


To transpose cells:

1. Copy a range of cells (see range A1:A6 below).
2. Select a cell.
3. Press Shift+F10.
OR
From the shortcut menu, select Paste Special.
4. Select the Transpose checkbox, and click OK. The list is now presented in horizontal cells.