# How do I do this? (Excel Q) **URL:** \ **Category:** Factual Questions\ **Created:** [May 2, 2005, 9:37pm UTC](https://boards.straightdope.com/t/how-do-i-do-this-excel-q/302132 "2005-05-02T21:37:54Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Rick](https://avatars.discourse-cdn.com/v4/letter/r/9f8e36/32.png) [@Rick](https://boards.straightdope.com/u/Rick)\ **Post date:** [May 2, 2005, 9:37pm UTC](https://boards.straightdope.com/t/how-do-i-do-this-excel-q/302132/1 "2005-05-02T21:37:54Z")
I am working on in Excel on a worksheet that is about 12 columns wide by about 150 rows. I want row 1 to remain stationary, and the scroll to start with row 2. Row 1 has tittles for each column and data is filled in below each. (we are talking words in each cell, not numbers if that makes any difference). Anyway I want to lock the first row with all the tittles in place so that when I am editing down around row 100 I don’t have to scroll up to the top to see if I am in the correct column. It is Excel 2002 sp3 if it makes any difference. ---
**Author:** ![Jpeg\_Jones](https://avatars.discourse-cdn.com/v4/letter/j/4bbf92/32.png) [@Jpeg\_Jones](https://boards.straightdope.com/u/Jpeg_Jones)\ **Post date:** [May 2, 2005, 9:45pm UTC](https://boards.straightdope.com/t/how-do-i-do-this-excel-q/302132/2 "2005-05-02T21:45:46Z")
Select all of row 2 (click on the “2” so the whole row is highlighted). Then, choose Window|Freeze Panes. Enjoy. ---
**Author:** ![Myglaren](https://avatars.discourse-cdn.com/v4/letter/m/f1d935/32.png) [@Myglaren](https://boards.straightdope.com/u/Myglaren)\ **Post date:** [May 2, 2005, 9:48pm UTC](https://boards.straightdope.com/t/how-do-i-do-this-excel-q/302132/3 "2005-05-02T21:48:02Z")
Drag the small bar at the top of the vertical scroll bar down to where you need it (on line in your case) Click in the area below the delineation and that area willl scroll with the headers left in place. ---
**Author:** ![Rick](https://avatars.discourse-cdn.com/v4/letter/r/9f8e36/32.png) [@Rick](https://boards.straightdope.com/u/Rick)\ **Post date:** [May 2, 2005, 9:48pm UTC](https://boards.straightdope.com/t/how-do-i-do-this-excel-q/302132/4 "2005-05-02T21:48:38Z")
You sir are a genius. If our paths ever cross at a dopefest, the first round is on me. Thanks! ---
**Author:** ![tiltypig](https://avatars.discourse-cdn.com/v4/letter/t/dbc845/32.png) [@tiltypig](https://boards.straightdope.com/u/tiltypig)\ **Post date:** [May 2, 2005, 9:49pm UTC](https://boards.straightdope.com/t/how-do-i-do-this-excel-q/302132/5 "2005-05-02T21:49:01Z")
Select the cell one down and one to the right of where you want the cells to freeze, and then, from the Window menu in Excel, select the option “Freeze Panes.” For example, if you want all the titles to stay in place, you should select cell A2. If you want the top row to stay in place when you scroll down, and the left-hand column to stay in place when you scroll right, select cell B2. ---
**Author:** ![Dog80](https://avatars.discourse-cdn.com/v4/letter/d/6bbea6/32.png) [@Dog80](https://boards.straightdope.com/u/Dog80)\ **Post date:** [May 2, 2005, 10:09pm UTC](https://boards.straightdope.com/t/how-do-i-do-this-excel-q/302132/6 "2005-05-02T22:09:26Z")
I was too wondering how to do this for years. Thanks! ---
**Author:** ![Richard\_Pearse](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/richard_pearse/32/13144_2.png) [@Richard\_Pearse](https://boards.straightdope.com/u/Richard_Pearse)\ **Post date:** [May 3, 2005, 6:27am UTC](https://boards.straightdope.com/t/how-do-i-do-this-excel-q/302132/7 "2005-05-03T06:27:18Z")
I just wanted to say that I thought you said row 1 had **titties** for each column. Imagine my surprise when I scroll further down the thread and see a poster whose name I’d misread as **Tittypig** in another thread. I see a trend developing.