answersLogoWhite

0


Best Answer

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.

User Avatar

Wiki User

13y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you freeze the top row of the current worksheet?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How do you get the symbols to the top row?

This question is not clear. If you have symbols in your worksheet, just copy them from where ever they are on the worksheet to the top row.


How can you scroll through a worksheet while still viewing the top five lines of that worksheet?

You can freeze the top 5 rows. Put the cursor in cell A6. The use the Freeze Panes option and all of the rows above the current cell will be frozen. As you then scroll down, those rows will stay on the screen.


How are rows indentifies in an worksheet?

In a worksheet rows are identified by the row numbers which are displayed at the beginning of each row. These numbers increase incrementally as you move down the worksheet. For example the first row would be labeled as row 1 the second row as row 2 and so on.Rows can also be identified by the letters at the top of the worksheet which correspond to the columns. For example the first row is labeled with the letter A the second row with the letter B and so on. This allows you to easily refer to specific cells in the worksheet by their column and row identifiers such as A1 B2 etc.


When using excel worksheet what happens when you press page down key?

The cursor will be moved down the worksheet. You will usually be moved down to the row that was at the bottom of the screen before you pressed Page Down, which will now become the top row of the screen, and will be in the same column.The cursor will be moved down the worksheet. You will usually be moved down to the row that was at the bottom of the screen before you pressed Page Down, which will now become the top row of the screen, and will be in the same column.The cursor will be moved down the worksheet. You will usually be moved down to the row that was at the bottom of the screen before you pressed Page Down, which will now become the top row of the screen, and will be in the same column.The cursor will be moved down the worksheet. You will usually be moved down to the row that was at the bottom of the screen before you pressed Page Down, which will now become the top row of the screen, and will be in the same column.The cursor will be moved down the worksheet. You will usually be moved down to the row that was at the bottom of the screen before you pressed Page Down, which will now become the top row of the screen, and will be in the same column.The cursor will be moved down the worksheet. You will usually be moved down to the row that was at the bottom of the screen before you pressed Page Down, which will now become the top row of the screen, and will be in the same column.The cursor will be moved down the worksheet. You will usually be moved down to the row that was at the bottom of the screen before you pressed Page Down, which will now become the top row of the screen, and will be in the same column.The cursor will be moved down the worksheet. You will usually be moved down to the row that was at the bottom of the screen before you pressed Page Down, which will now become the top row of the screen, and will be in the same column.The cursor will be moved down the worksheet. You will usually be moved down to the row that was at the bottom of the screen before you pressed Page Down, which will now become the top row of the screen, and will be in the same column.The cursor will be moved down the worksheet. You will usually be moved down to the row that was at the bottom of the screen before you pressed Page Down, which will now become the top row of the screen, and will be in the same column.The cursor will be moved down the worksheet. You will usually be moved down to the row that was at the bottom of the screen before you pressed Page Down, which will now become the top row of the screen, and will be in the same column.


How can you tell your current position in a worksheet?

The cell reference will be in the top left of the spreadsheet, showing what cell is the currently active cell. Also, the column heading and row heading are highlighted.


How do you highlight all the cells in a worksheet in Excel?

Click on the Select All button. It is in the top corner of the spreadsheet, above the 1 for row 1 and to the left of the A for column A, and is a blank button. Clicking on that will select the entire worksheet.


What is the name of the top row in Excel above row 1?

Above row 1 are the column headers, though they are not generally regarded as being a row. It just has the headings for the columns in it. Above that you may have different things like the Formula Bar and other toolbars.


How do you remove duplicate rows from a matrix using C language?

Sort the rows; the duplicates will then be grouped together. Scan from the top row; if the next row is a duplicate of the current row, remove it. If the next row is not a duplicate, make it the current row. Repeat until there is no next row. When complete, all the duplicates will have been removed.


How do you modify a worksheet so the first rows is always visible?

There are two methods to do this: either split the worksheet pane, or freeze the row. To split: if you look on the right side of the pane, next to the column headers (A, B, C, . . .), just above the top scroll arrow, you will see a horizontal bar. You can drag and drop this downwards to open a split screen view. You can also freeze the rows by using the menu option "Freeze Panes". The exact location of "Freeze" on the menu changes in different versions of Excel from the old menus to the new "ribbon" system of versions 2007 and 2010. But look for it - you'll find it! The appearance and behavior of each method is slightly different, so you may want to experiment with both.


How are columns identified in an Excel worksheet?

Columns are identified by letters. After Z the next one is AA, then AB then AC and so on. After AZ comes BA, then BB, then BC and so on. Rows are identified by numbers. Where a row and column meet you get a cell, which is identified by its column letter and row number. So the cell where Column D and row 14 meet would be cell D14.


How do the different parts of the Excel worksheet differ from a word processor?

A worksheet and a word processing document are completely different. A worksheet is a grid and so it has rows and columns. The rows are identified by numbers and the columns by letters. There are row headers down the side and column headers across the top. A word processor has a blank page. It has rulers on the top and on the side and it has margins. It has individual pages with set sizes, whereas a worksheet is a lot larger. You usually type directly into the page of the word processor, whereas you can either type into the formula bar or direct into the cells on a worksheet. It is only when you have a table in a word processing document that it looks a bit more like a worksheet.


In Excel how do you make it so the first row in this case field titles stays visible at the top of the window even when you scroll down?

Use the freeze panes option.