0
Add your answer:
Earn +20 pts
How do you freeze the top row of the current worksheet?
In Excel 2003 and earlier, place your cursor in row 2 and click on Freeze Panes. The Freeze Pains command will freeze the rows above the cursor. Excel 2007 offers an option to freeze top row no matter where your cursor is located.
What is excel data in rows with headings in top row?
list
What are titles in Excel?
It could be one in the Header of the file, one at the top of a column or start of a row, the name of the file, or even a title in a chart.
What does the word Excel mean?
To excel is to do very well in something, well above average. It comes from excellent. Experts in things excel in their areas of work. The top athletes excel in their sport. Excel is also the name of the most popular spreadsheet program. It is made by Microsoft.
What is used to create a cell name from column and row titles in Excel?
The following is copied from the Help dialog box in MS Excel 2000. A search for 'name cells' or 'cell label' should get the directions that you're looking for:Name cells by using existing row and column labelsSelect the range you want to name, including the row or column labels.On the Insert menu, point to Name, and then click Create.In the Create names in box, designate the location that contains the labels by selecting the Top row, Left column, Bottom row, or Right column check box.
What is an Excel reference function that looks for a value in the top row of a table or array of values and returns the value in the same column from a row you specify?
hlookup
The best way to resize a column and row of the excel?
Go to Format (at top of page) then click on Row or Column, and Height or Width is first option on the list.
How do you transpose a row of data to a column in Excel?
Select and copy the row data.Go to the top cell of the column where you would like to copy the data.Click on copy - transpose.Observe the data from the row in the column.Go back and delete the row data.
Where does the file name appear when you open an Excel file?
The File name will usually appear at the top of the excel file. It should look something like this: file name - Microsoft Excel...
Where did the insertion point go after you pressed the home key?
In Excel, to the first cell in the current row. in Word, to the start of the current line of text..
What tells Excel that the information in the top row of your selection is the names of the fields?
It is a facility built into Excel that enables it to do it. It is used when typing in data, doing formulas, setting names for values and when creating charts.
Is there a data base that will allow you to put names at the top - not letters like Excel?
You could use a database like Access or Oracle. You could also use the first blank row in Excel for your headings and Excel can work on them like a database.
