answersLogoWhite

0

How do you change a row from a column in Excel?

Updated: 8/21/2019
User Avatar

Wiki User

8y ago

Best Answer

You use the TRANSPOSE feature of the PASTE SPECIAL command, having just copied a row of data. You can also use the TRANSPOSE function.

User Avatar

Wiki User

8y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you change a row from a column in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

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.


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.


What is the intersection of a column and row in Excel called?

The intersection of a column and row in excel called "cell"


How many intersection of row and column in ns Excel?

Each intersection of a row and column is a cell. So it will depend on which version of Excel you have There are 16,777,216 cells in Excel 2003 and earlier. There are 17,179,869,184 cells in Excel 2007 and after.


What headings do you reserve a row for in excel?

column headings


What is the insection of a column and row in an Excel spreadsheet?

cell


How does a cell form in Microsoft Excel?

It is formed where a column and row intersect on a worksheet. This is what gives the cell its address, the column and row references. Where column C and row 7 intersect forms cell C7 for example.


What is the refernce name of the last cell in the first row in excel 2007?

XFD1 is the cell reference at the end of the first row in Excel. Column XFD is the 16384th column.


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.


What is the last column letter in Excel 2010?

That depends on the version. Up to version 2003, it was row 65,536. From Excel 2007 onwards, it is row 1,048,576.


What is the name of individual box in Microsoft Excel 2007?

Each individual box on a worksheet in Excel is a cell. Each cell has an address consisting of the column and row identifiers. So cell B34 is the cell in column B and row 34.Each individual box on a worksheet in Excel is a cell. Each cell has an address consisting of the column and row identifiers. So cell B34 is the cell in column B and row 34.Each individual box on a worksheet in Excel is a cell. Each cell has an address consisting of the column and row identifiers. So cell B34 is the cell in column B and row 34.Each individual box on a worksheet in Excel is a cell. Each cell has an address consisting of the column and row identifiers. So cell B34 is the cell in column B and row 34.Each individual box on a worksheet in Excel is a cell. Each cell has an address consisting of the column and row identifiers. So cell B34 is the cell in column B and row 34.Each individual box on a worksheet in Excel is a cell. Each cell has an address consisting of the column and row identifiers. So cell B34 is the cell in column B and row 34.Each individual box on a worksheet in Excel is a cell. Each cell has an address consisting of the column and row identifiers. So cell B34 is the cell in column B and row 34.Each individual box on a worksheet in Excel is a cell. Each cell has an address consisting of the column and row identifiers. So cell B34 is the cell in column B and row 34.Each individual box on a worksheet in Excel is a cell. Each cell has an address consisting of the column and row identifiers. So cell B34 is the cell in column B and row 34.Each individual box on a worksheet in Excel is a cell. Each cell has an address consisting of the column and row identifiers. So cell B34 is the cell in column B and row 34.Each individual box on a worksheet in Excel is a cell. Each cell has an address consisting of the column and row identifiers. So cell B34 is the cell in column B and row 34.


How do you print a row and column headings on excel window?

to get column number, we can use =COLUMN(Reference) to get Row number, we can use =ROW(Reference) For example =COLUMN(A1) will return 1 and =ROW(A3) will return 3