» 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:
- The Basics of Finance: Financial Tools for Non Financial Managers
- Financial Peace: Revisited
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Accounting and Financial Fundamentals for Nonfinancial Executives
- The 22 Immutable Laws of Branding
- Microsoft Windows XP Registry Guide
tranposing
jacyln
this is a very useful tip and especially help those who don't initially properly plan their layout.
