+ Reply to Thread
Results 1 to 5 of 5

Freeze panes or rows that don't move when you scrool down

  1. #1
    Registered User
    Join Date
    11-10-2011
    Location
    Cluj-Napoca
    MS-Off Ver
    Office 2010
    Posts
    17

    Freeze panes or rows that don't move when you scrool down

    Hello,

    I saw another topic where in the example there are a few rows than don't move when you scrool down. How can I make that?
    I have attached the example. I am talking about the first three rows on the Database and Inventory sheets.
    Attached Files Attached Files
    Last edited by kitu_gudu; 12-25-2011 at 11:11 AM.

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Fixed rows or rows that don't move when you scrool down

    This is called FREEZE PANES. To freeze rows 1:3 onscreen:

    1) scroll all the way to the top so you can see cell A1
    2) Click on A4
    3) In the Window group of the View tab, choose Freeze Panes→Freeze Panes.


    The trick to freezing is you must select the cell that represents the first cell to NOT freeze. Everything above and the left will be frozen.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    11-10-2011
    Location
    Cluj-Napoca
    MS-Off Ver
    Office 2010
    Posts
    17

    Re: Fixed rows or rows that don't move when you scrool down

    Wow... That was fast. It works. Thank you very much.

    How can I make multiple freezes? Let's say I freeze the first three rows, then I leave a few empty rows and freeze again. And after that I can insert rows between the first freeze and the second and I have a scrool bar. Can this be made?
    Sorry if my english is wrong. BTW I gave you a star.
    Last edited by kitu_gudu; 12-24-2011 at 05:18 AM.

  4. #4
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Fixed rows or rows that don't move when you scrool down

    No. You can freeze based on one cell on the sheet. Everything above and to the left will freeze.

  5. #5
    Registered User
    Join Date
    11-10-2011
    Location
    Cluj-Napoca
    MS-Off Ver
    Office 2010
    Posts
    17

    Re: Fixed rows or rows that don't move when you scrool down

    OK. Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1