Microsoft Office Tutorials and References
In Depth Information
CONVERT A ROW
to a column
When you create a worksheet, Excel gives you
flexibility when working with rows and columns. At
any time, you can insert new rows or columns, delete
rows or columns, and move entire rows or columns
while retaining most of their properties. Sometimes,
however, you may want to transpose a row into a
column — or vice versa.
Transposing comes in handy when you need to create
a table, a special kind of worksheet discussed in
Chapter 4. A table might consist of rows describing
products, with each column describing a feature
of the product: its ID, its price, the quantity in
inventory, and so on. Tables typically have many
rows and fewer columns.
With Excel, you can copy, or transpose, a row into
a column and vice versa by using the Paste Special
dialog box. To ensure you have room for new
worksheet data, you can place the transposed
columns or rows on a different worksheet or in a
new workbook.
2
3
1
Click and drag to select the cells
you want to transpose.
Note: Make sure a series of blank
cells is available to accommodate
the copied data.
1
2
Click the Home tab.
3
Click the Copy button.
4
Click to select the first cell in the
new column or row.
Note: Excel removes existing data
by copying over it.
5
6
5
Click the Home tab.
6
Click Paste.
A menu appears.
4
7
7
Click Paste Special.
60
Search JabSto ::




Custom Search