Transposing a Range
Often you set up a spreadsheet and then decide that you would rather have a portion of it transposed. That is, you would like to “turn it on its side,” so that rows become columns and vice versa. This is simple with one of Excel’s Paste options.
To transpose a range:
Select a range that you want to transpose and press Ctrl-c to copy it. Then select the upper left cell of the range where you want the transposed version to go, select the Paste dropdown, and select the Transpose option.
Make sure there is enough room for the transposed version. For example, if the original range has 3 rows and 5 columns, the transposed version will have 5 rows and 3 columns. If you select cell D5, say, as the upper left cell for the transposed version, everything in the range D5:F9 will be overwritten by the transposed version.
Try it! Transpose the range A3:D6 to a range with upper left cell F3.
Dostları ilə paylaş: |
