0
In Excel your data is in rows and you really want them in columns instead how would you do this?
Wiki User
∙ 15y ago
To transpose data from a row to a column select all but the first cell and copy it to the clipboard (Control/c or Edit... Copy).
Select the cell immediately below the first entry in the original list and go to the Edit... Paste Special menu.
Put a check mark in the box next to where it says 'Transpose' and click OK.
Select all but the first cell in the original row of data and press Delete on the keyboard.
Wiki User
∙ 15y ago
Add your answer:
Earn +20 pts
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.
How many cells are there in a single Excel sheet?
In the Excel spreadsheet versions prior to 2002 or Office XP there are 65,536 rows and 256 columns , 65,536 x 256 = 16,777,216 cells or 'boxes'. Later versions of Excel have far more - millions of rows and thousands of columns. EDIT The latest version of Microsoft Excel that comes with Office 2007 has 17,179,869,184 cells in all. The columns are letter all the way to XFD and there are 1,048,576 rows.
When a delimited file is imported into Excel fields become?
Different fields will go into columns in the spreadsheet. Records would go into rows in the spreadsheet.
What contains information that is similar to terms in a list in Excel?
You could say data in a table of a database. These would be in fields, which could correspond to columns of a spreadsheet.
How will you import any table from oracle to Excel?
One method would be to use sqlplus, write a select statement to extract the data that you want to import, save it to a file or copy it to the clipboard, then paste the data (or open the file that you saved it to) in Excel and use the "Text to Columns" feature to break each line of data into columns.
What is grid lines in excel?
When you look at a worksheet and see the rows and columns and cells, it is the gridlines that form the grid. Without them the cells would still be there, but your sheet would look blank.
What creates a lower level paragraph in Excel?
Excel does not use paragraphs and is the wrong tool for writing letters or any kind of academic writing. I would recommend MS Excel instead.
When you format a range of cells as a table what does Excel displays in the first row of the table?
Normally it would be headings for the values in the columns below each cell in the row.
What is the use of showing grid lines in Excel?
It makes it easier to see where things are and to pick out cells and their references. It is also easier to see the widths of columns and heights of rows, especially when they have been changed.
When you save a document in Excel what does it save as?
It will save it with the name you specify and as the default type of workbook for the version of Excel you have. You should give the file a name, but if you don't it will call it Book1 and then add the appropriate extension. For the more modern versions, which is Excel 2007 onwards, that would be .xlsx, but if you are using an older version than Excel 2007, then it would be .xls instead.
How do you freeze an excel cell?
You use the Freeze Panes option. When you do it, columns to the left of the active cell and rows above the active cell will be frozen. So if you wanted to freeze just the first column, you would make B1 the active cell before freezing the panes. To freeze just the first row, you would make A2 the active cell before freezing the panes. To freeze both the first column and first row, the you would make cell B2 the active cell before freezing the panes.
Do columns go across?
No that would be rows. Columns go down.
