Microsoft Office Tutorials and References
In Depth Information
Cutting and pasting
One of the often-overlooked but extremely useful Paste Special features is Transpose, which
helps you reorient the contents of the copied range when you paste—that is, data in rows is
pasted into columns, and data in columns is pasted into rows. (This option is also available
as a command on the Paste menu.) For example, in Figure 8-5, we copied the data shown
in cells B3:E3, and then we selected cell J3 and clicked Transpose on the Paste menu on the
Home tab. This works both ways. If we subsequently select the range just pasted and click
Transpose again, the data is pasted in its original orientation.
Figure 8-5 We copied cells B3:E3, selected cell J3, and then clicked Home, Paste, Transpose to
redistribute the row of labels into a column of labels.
INSIDE OUT Using paste values with arrays
As with any other formula, you can convert the results of an array formula to a series
of constant values by copying the entire array range and—without changing your
selection—clicking the Home tab, Paste, Paste Values. When you do so, Excel overwrites
the array formulas with their resulting constant values. Because the range now contains
constant values rather than formulas, Excel no longer treats the selection as an array.
For more information about arrays, see “Using arrays” in Chapter 12.