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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Use the freeze panes option.