» 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:
Recommended Books:
- Accounting for Dummies
- Microsoft Windows XP Inside Out
- Real Estate Finance and Investments (Real Estate Finance and Investments, 11th Ed)
- Microsoft Word Version 2002 Inside Out
- The Guide to Understanding Financial Statements
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
tranposing
jacyln
this is a very useful tip and especially help those who don't initially properly plan their layout.
