» Transposing Cells
CATEGORY - Excel Editing
VERSION - All Microsoft Excel Versions
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.
Book Store:
tranposing
jacyln
this is a very useful tip and especially help those who don't initially properly plan their layout.
