Results 1 to 7 of 7
  1. #1
    Join Date
    Apr 2004
    Posts
    9

    Unanswered: make some columns static (no scrolling)

    hey all,

    I'm trying to set up a table where the far left column will stay completely still, and I can scroll all the other columns when needed. The left column will be categories, and the right columns will be different sets of measurements for those categories.

    Does anyone know how to do this? Thanks in advance

  2. #2
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    windows -> freeze panes

    or drag the small bar next to the scroll bars to split your windows with each bit being scrolable

    is this what you mean
    Dave

  3. #3
    Join Date
    Apr 2004
    Posts
    9
    hmm freeze panes is about what I'm looking for but I can't implement it just the way I want..


    I need to make column A be completely static. Then when I scroll down, all the other columns will move but column A will stay the same.

    freeze panes is close because I can scroll the panes separately.. so I guess I need to make column A be it's own frame somehow..

  4. #4
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    Mike

    what you are after is to do this

    highlight cell b1

    go to the Menu Window then choose option Freeze panes

    this will allow you to freeze column A and not be able to move it,

    if you want to have some rows at the top frozen as well just select cell B?
    where ? is the cell below where you wan't to freeze

    i know ths works cause ive just tried it

    David

  5. #5
    Join Date
    Apr 2004
    Posts
    9
    Hey david,

    that worked perfectly, however it doesn't freeze column A vertically as well as horizontally. do you know if there's a way to freeze it for vertical scrolls as well?

  6. #6
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    not sure what you mean if you mean scrolling down then probably not but if you want to replicate the behaviour vertically select the cell below where you wan't to freeze then freeze panes again otherwise it would probably have to be a macro

  7. #7
    Join Date
    Apr 2004
    Posts
    9
    ok cool, yep I meant scrolling down, but this should be fine, thanks for the help!

Posting Permissions

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