answersLogoWhite

0

How do you change row to column?

User Avatar

Anonymous

16y ago
Updated: 8/17/2019

You use the TRANSPOSE feature of the PASTE SPECIALcommand ... for details, click on the Related Link shown below.

User Avatar

Wiki User

16y ago

What else can I help you with?

Related Questions

What does a spilt double arrow allow you to do when positioned between two column or row heading?

It enables you to change the width of a column, or the height of a row. It changes the width of the column to the left or the height of the row above.It enables you to change the width of a column, or the height of a row. It changes the width of the column to the left or the height of the row above.It enables you to change the width of a column, or the height of a row. It changes the width of the column to the left or the height of the row above.It enables you to change the width of a column, or the height of a row. It changes the width of the column to the left or the height of the row above.It enables you to change the width of a column, or the height of a row. It changes the width of the column to the left or the height of the row above.It enables you to change the width of a column, or the height of a row. It changes the width of the column to the left or the height of the row above.It enables you to change the width of a column, or the height of a row. It changes the width of the column to the left or the height of the row above.It enables you to change the width of a column, or the height of a row. It changes the width of the column to the left or the height of the row above.It enables you to change the width of a column, or the height of a row. It changes the width of the column to the left or the height of the row above.It enables you to change the width of a column, or the height of a row. It changes the width of the column to the left or the height of the row above.It enables you to change the width of a column, or the height of a row. It changes the width of the column to the left or the height of the row above.


Can you adjust the row and the column?

Yes. You can change the row height and the column width to whatever you like.


In excel 2007 what are the processes of adjusting the row and column portion of cell references?

If you have a cell address H12 and want to change the column, change the H to the letter of the column you want. If you want to change the row, change the 12 to the number of the row you want.


What a row or column caused your cell data to change orientation. Row data will become column data Will become row data?

A row or column may change its orientation if you use a function like "Transpose" in spreadsheet software. For example, if you select a row of data and apply the transpose function, that row will convert into a column. Similarly, if you transpose a column, it will become a row. This feature is useful for reorganizing data for better analysis or presentation.


What formula would be used to add two cells together after the equal sign?

column#row+column#column#row#


What is the cell reference A1 for Microsoft Excel?

A1 is the first cell, in the first column and the first row: Column A, row 1.A1 is the first cell, in the first column and the first row: Column A, row 1.A1 is the first cell, in the first column and the first row: Column A, row 1.A1 is the first cell, in the first column and the first row: Column A, row 1.A1 is the first cell, in the first column and the first row: Column A, row 1.A1 is the first cell, in the first column and the first row: Column A, row 1.A1 is the first cell, in the first column and the first row: Column A, row 1.A1 is the first cell, in the first column and the first row: Column A, row 1.A1 is the first cell, in the first column and the first row: Column A, row 1.A1 is the first cell, in the first column and the first row: Column A, row 1.A1 is the first cell, in the first column and the first row: Column A, row 1.


An alternative to increasing the column widths or row heights is to?

In order to make data in cells to be seen, if you don't want to change row or column sizes you can change the font size of the data.


What are the two parts of the cell identifier in excel?

The column reference, which is one or more letters and the row number. So C20 is column C, row 20. DG321 is column DG, row 321.The column reference, which is one or more letters and the row number. So C20 is column C, row 20. DG321 is column DG, row 321.The column reference, which is one or more letters and the row number. So C20 is column C, row 20. DG321 is column DG, row 321.The column reference, which is one or more letters and the row number. So C20 is column C, row 20. DG321 is column DG, row 321.The column reference, which is one or more letters and the row number. So C20 is column C, row 20. DG321 is column DG, row 321.The column reference, which is one or more letters and the row number. So C20 is column C, row 20. DG321 is column DG, row 321.The column reference, which is one or more letters and the row number. So C20 is column C, row 20. DG321 is column DG, row 321.The column reference, which is one or more letters and the row number. So C20 is column C, row 20. DG321 is column DG, row 321.The column reference, which is one or more letters and the row number. So C20 is column C, row 20. DG321 is column DG, row 321.The column reference, which is one or more letters and the row number. So C20 is column C, row 20. DG321 is column DG, row 321.The column reference, which is one or more letters and the row number. So C20 is column C, row 20. DG321 is column DG, row 321.


How does cells get their address?

It is based on the column and row the cell is in. First the column letter(s) and then the row number. So a cell in Column G, Row 498 for example, is cell G498.It is based on the column and row the cell is in. First the column letter(s) and then the row number. So a cell in Column G, Row 498 for example, is cell G498.It is based on the column and row the cell is in. First the column letter(s) and then the row number. So a cell in Column G, Row 498 for example, is cell G498.It is based on the column and row the cell is in. First the column letter(s) and then the row number. So a cell in Column G, Row 498 for example, is cell G498.It is based on the column and row the cell is in. First the column letter(s) and then the row number. So a cell in Column G, Row 498 for example, is cell G498.It is based on the column and row the cell is in. First the column letter(s) and then the row number. So a cell in Column G, Row 498 for example, is cell G498.It is based on the column and row the cell is in. First the column letter(s) and then the row number. So a cell in Column G, Row 498 for example, is cell G498.It is based on the column and row the cell is in. First the column letter(s) and then the row number. So a cell in Column G, Row 498 for example, is cell G498.It is based on the column and row the cell is in. First the column letter(s) and then the row number. So a cell in Column G, Row 498 for example, is cell G498.It is based on the column and row the cell is in. First the column letter(s) and then the row number. So a cell in Column G, Row 498 for example, is cell G498.It is based on the column and row the cell is in. First the column letter(s) and then the row number. So a cell in Column G, Row 498 for example, is cell G498.


Is excal is formed due to intersectin tof two rows and columns?

Where a column and row intersect, you will get a cell on a spreadsheet.Where a column and row intersect, you will get a cell on a spreadsheet.Where a column and row intersect, you will get a cell on a spreadsheet.Where a column and row intersect, you will get a cell on a spreadsheet.Where a column and row intersect, you will get a cell on a spreadsheet.Where a column and row intersect, you will get a cell on a spreadsheet.Where a column and row intersect, you will get a cell on a spreadsheet.Where a column and row intersect, you will get a cell on a spreadsheet.Where a column and row intersect, you will get a cell on a spreadsheet.Where a column and row intersect, you will get a cell on a spreadsheet.Where a column and row intersect, you will get a cell on a spreadsheet.


Why do they call a column a cell in Microsoft Excel?

A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.A column is not called a cell in Microsoft Excel. A column is a group of vertically arranged cells, a row being a horizontal group of cells. A cell is created where a column and row intersect, and its address is take from the column and row that it is in.


Which column and row is a cell in?

A cell can be in any column and row. The address (e.g. A3) will tell you which column (A) and which row (3).