Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Mar 2009
    Location
    Somewhere Over the Rainbow
    Posts
    232
    Thanks
    0
    Thanked 1 Time in 1 Post
    Hello,

    I would like to select a row of cells and make them not move or be fixed when scrolling down the page.

    Thanks,
    HandyAndy
    Time can fix anything.....even a broken clock. - Handy Andy

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Click in the cell below and to the right of the cells you want to lock in place. For example, if you want to lock the first two columns and the top two rows, click in cell C3. Go to Window / Freeze Panes/

  3. #3
    3 Star Lounger
    Join Date
    Mar 2009
    Location
    Somewhere Over the Rainbow
    Posts
    232
    Thanks
    0
    Thanked 1 Time in 1 Post
    Thank you very much, but what if I wanted only a group of say 5 cells in a row to be frozen?
    Time can fix anything.....even a broken clock. - Handy Andy

  4. #4
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I don't think that can be done.

  5. #5
    3 Star Lounger
    Join Date
    Mar 2009
    Location
    Somewhere Over the Rainbow
    Posts
    232
    Thanks
    0
    Thanked 1 Time in 1 Post
    I didn't think so either. Thanks though, what you gave me before will do the trick.
    Time can fix anything.....even a broken clock. - Handy Andy

  6. #6
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Might the camera tool be able to simulate what you want?
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

Posting Permissions

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