Results 1 to 6 of 6

column always visible when scrolling

This is a discussion on column always visible when scrolling within the Excel Questions forums, part of the Question Forums category; Hello all, Anayone knows how to keep a column always visible when using horizontal sroll? For example i have certain ...

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    25

    Default

    Hello all,

    Anayone knows how to keep a column always visible when using horizontal sroll?

    For example i have certain projects listed in colomn B. To the right all columns represent dates to a calendar. When selecting the final weeks of the year column B is however not visible anymore and inputting the right date with the right project becomes harder.

    Any solutions so that B2 will be always visible even when scrolling to the right?

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,579

    Default

    Hi Frisco
    You need to freeze panes.
    Look at the horizontal scroll bar at the bottom of your sheet. Immediately to the right of the right scroll arrow is a thin bar. Click on this and drag it left to the border between columns B and C. Now go to your toolbar, Window, Freeze Panes.
    regards
    Derek

    ps Alternatively, select Column C then go to your toolbar, Window, Freeze Panes.


    [ This Message was edited by: Derek on 2002-04-08 04:29 ]

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    25

    Default

    thanks dereck! it did the trick.

    Is there by the way also a way to freeze column B but not also column A??

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,579

    Default

    Hi frisco
    No you can't do that, you would need to change column B to the A position, and then freeze column A.
    By scrolling before freezing you can have only B showing in the freeze pane (or just simply hide column A).
    Incidentally, a similar process allows you to freeze rows so that your headings remain stationary as you scroll down the rows. You can have both at the same time too.
    regards
    Derek

    [ This Message was edited by: Derek on 2002-04-08 04:51 ]

  5. #5
    New Member
    Join Date
    Apr 2002
    Posts
    25

    Default

    ok i'll use a macro instead for hiding a then, thanks for answering the questions!


  6. #6
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582

    Default

    Hi friso


    As Dereck has said this would not be possible directly. You could however play about with Window>Split



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