Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a lot of data in Excel cells. However, the first row in my Excel file contains cells which represent titles of each cell beneath it. Now, if I'm in row number 100 and I'm filling information and every time I want to know which type of info the cell the cursor is highlighting at the moment I have to go the the top of the file to know that.

Is there a way that can let me know or see the first row while I'm far away beneath it?

share|improve this question
Panel division. I'll post an answer with screenshots briefly. – Doktoro Reichard Sep 20 '13 at 16:59
freeze pane is how I'd do it – Raystafarian Sep 20 '13 at 17:05
up vote 2 down vote accepted

You should use Freeze Panes.

1 -Position the cell cursor based on what you want to freeze:

Columns: Select the column to the right of the columns you want to freeze. For example, click any cell in column B to freeze column A.

Rows: Select the row below the rows you want to freeze. For example, click any cell in row 4 to freeze rows 1, 2, and 3.

Columns and rows: Click the cell below the rows and to the right of the columns you want to freeze — essentially, the first cell that isn't frozen. For example, click cell B2 to freeze both column A and row 1.

2- In the Window group of the View tab, choose Freeze Panes→Freeze Panes.

3- In the Window group of the View tab, choose Freeze Panes→Unfreeze Panes to unlock the fixed rows and columns.

You can click the Freeze Top Row or Freeze First Column command in the Freeze Panes drop-down menu to freeze just the top row or first column in the worksheet, without regard to the position of the cell cursor in the worksheet.

enter image description here

share|improve this answer
That's great. I love Microsoft and I love you :) – miami Sep 20 '13 at 17:19

This is called Freeze Panes.

I'm using Excel 2003 but I know this functionality exists on later versions. To access it on Excel 2003, do the following:

  1. Assuming you had a data set like the following:

    First point

  2. Select the cell immediately below the cells (header) you want to lock.

  3. Go to Window > Freeze Panes.

    Freeze Panes location on Excel 2003

  4. You now notice the black line dividing the data's header form the respective data.

    End Result

@Lorenzo stepped up with a good answer for Excel 2010 (and I'm not going to copy the work he made) so I'm keeping this here for information/curiosity purposes.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .