Results 1 to 4 of 4

Fixing Cells (make them unscrollable)

This is a discussion on Fixing Cells (make them unscrollable) within the Excel Questions forums, part of the Question Forums category; Say I would like to fix rows 1, 2 and 3 so that when i scroll up and down, I ...

  1. #1
    Board Regular
    Join Date
    May 2004
    Posts
    56

    Default Fixing Cells (make them unscrollable)

    Say I would like to fix rows 1, 2 and 3 so that when i scroll up and down, I can always see the three rows.

    How do I go about fixing the 3 rows?

    Thanks!

  2. #2
    New Member
    Join Date
    Nov 2006
    Location
    Reading
    Posts
    47

    Default

    Select cell A4, then select Window=>Freeze Pane

    You can also freeze columns, i.e. if you select cell C4 and freeze pane then when you scroll down the first three rows will be frozen on the screen and also when you scroll right column A and B will be frozen.

    To unfreeze selct Window=>Unfreeze Panes

    Hope that helps.

  3. #3
    Board Regular wilkisa's Avatar
    Join Date
    Apr 2002
    Location
    Decatur IL, USA
    Posts
    560

    Default

    Select the cell in row 4 in the far left column of the range, usually column A. Click on Window, Freeze Panes.
    Thanks,
    Shirlene

  4. #4
    Board Regular
    Join Date
    May 2004
    Posts
    56

    Default

    Thanks geniuses!

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com