Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: How to hold a row or a column

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    I have got an excel file that the column A and row 1 can be hold when I scroll the the scroll bar. How can I enable this function in excel?

    Bill.

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I think you might be talking about "Freeze Panes"?
    Select row 2, the entire row, then choose the Window menu item or Alt-W, then choose "Freeze Panes"
    Tom

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Sydney/Brisbane , Australia
    Posts
    542
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    if you want to always see column A too then
    click on b2 then goto window/freezepanes

    _________________
    All The Best
    Qroozn
    If I can do It anyone can
    [ This Message was edited by: Qroozn on 2002-05-09 21:01 ]

  4. #4
    New Member
    Join Date
    May 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Problem is solved. Thanks

  5. Some videos you may like

    User Tag List

    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
    •