Consulting

Results 1 to 3 of 3

Thread: it is possible to freeze more than one row in excel?

  1. #1

    Question it is possible to freeze more than one row in excel?

    Hellow

    it is possible to freeze more than one row in excel?

    I would like to freeze the rows ...
    1, 15, 30

    thank you!!

  2. #2
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,814
    Location
    No. But you can fake it by selectively hiding and showing rows and using the info in this link.

    Be aware that it is not easy.
    Last edited by SamT; 05-27-2013 at 07:02 PM.
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

  3. #3
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,728
    Location
    it is possible to freeze more than one row in excel?

    I would like to freeze the rows ...
    1, 15, 30

    Q: does that mean you're trying to 'split' the window vertically into 3 seperately scrollable sections?

    Section 1 = rows 1-14 with row 1 fixed
    Section 2 = rows 15-29 with row 15 fixed
    Section 3 = rows 30-end with row 30 fixed

    Interesting, but as SamT says to fake it will take work.

    What are you trying to accomplish, since there might be other alternatives that would do what you need to accomplish

    Paul

Posting Permissions

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