Microsoft Office Tutorials and References
In Depth Information
l The Paste Special dialog
box appears.
8
Click Transpose
(
changes to
).
9
Click OK.
8
9
l The data appears in its new position.
Did You Know?
With the TRANSPOSE function, you can transpose
a grid of cells. Start by selecting an area large
enough to hold the new grid. In the Formula bar,
type =TRANSPOSE( and then click the Insert
Function button. The Function Arguments dialog
box appears. Select the cells you want to transpose
and then press Ctrl+Shift+Enter. Excel transposes
the grid.
Did You Know?
You can avoid rearranging worksheets by designing
them carefully. For long lists of people, things,
transactions, and so on, arrange them in columns
with descriptive column heads. Excel calls this
type of layout a table. For more about tables, see
Chapter 4.
Chapter 3: Copy, Format, and More
61
 
Search JabSto ::




Custom Search