0
How do you convert rows to columns or columns to row in Excel while using formulas?
Wiki User
∙ 9y ago
You can use the TRANSPOSE function, entering it as an Array function. So if you have something in A2 and A3, you could select C2 and D2 and type the following function:
=TRANSPOSE(A2:A3)
Instead of pressing Enter, press Ctrl-Shift-Enter and it will enter the formula into the two cells, C2 and D2, and transpose the values. You can apply the same principle to larger ranges. There are also other ways of doing it, like using the INDIRECT function to reference a cell and get its value.
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
What is a sentence using the word columns?
Microsoft Excel makes perfect columns. She took a picture of the building's granite columns.
What do you use to widen columns and rows instead of leaving blank rows or columns using excel?
alignment
Switch rows and columns in Excel?
Columns and rows can be swapped by transposing them. You can copy a row of cells and using Paste Special and the Transpose option the data can be put into columns. You can do the same with data in columns and transpose them into rows. There is also a Transpose function in Excel.
When using spreadsheet software what are the rows and columns collectively are called?
Cells
How do you get answer to your questions when using Excel?
You use formulas to do calculations and get a result. For problems you have using Excel, you can go to classes to learn more or learn from books or post questions to Excel websites where experts can answer.
Are rows identified using numbers in Excel 2010?
Yes. Rows are identified with numbers. Columns are identified with letters.
What is maximum number of columns available in Excel?
It depends which Spreadsheet program you're using. The maximums in Open Office are 65536 rows and 1024 columns. Microsoft Works limits you to 16383 rows and 282 columns.
The order of precendence in Excel formulas can be changed by using?
By using the round brackets, also known as parentheses. ( )
List command to turn on columns?
There is no list command in Excel to turn on columns. All Excel columns are always on, they just may be hidden. If this does not answer your question, please ask again using words that make it clear what you would like to know, and ensure the question is in the correct category, so you can get a meaningful response.
What is a table or worksheet of data arranged in rows and columns using formulas to calculate data?
array
How do you convert 120 kilo to pounds using Microsoft Excel?
=(120*0.45359237)
When you a worksheet Excel enlarges the view of the characters on the screen but displays fewer columns and rows?
You can zoom in to do that, using the Zoom option.
