+ Reply to Thread
Results 1 to 4 of 4

Freezing cells within a page whilst everything else moves

  1. #1
    Registered User
    Join Date
    12-14-2013
    Location
    United Kingdom
    MS-Off Ver
    Home & Student 2013
    Posts
    22

    Freezing cells within a page whilst everything else moves

    Hello and good day to you.

    Is it possible to freeze a set number of cells within a page so that the rest scrolls around it?

    I have a small chart in cells (Y7:AB21) which I would like to keep visible at all times whilst scrolling around the rest of the worksheet.

    Just to add, I already have the top 3 lines froze.

    An alternatiive work around is to freeze the top 3 lines as stated above, and the first 4 columns, then move the chart to the frozen columns if this is possible. I can only manage to do 1 or the other.

    Many thanks in advance ~ D

  2. #2
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,604

    Re: Freezing cells within a page whilst everything else moves

    So, possibly use the camera tool to take a picture of the chart and then use/modify this code: https://www.mrexcel.com/forum/excel-...s-out-way.html
    Pauley
    --------
    If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).

  3. #3
    Registered User
    Join Date
    12-14-2013
    Location
    United Kingdom
    MS-Off Ver
    Home & Student 2013
    Posts
    22

    Re: Freezing cells within a page whilst everything else moves

    Thankyou for the reply Pauleyb. But if this only takes aand displays a picture, then it wont work for me. The chart has active cells which calculate values from the rest of the worksheet. Have given you a rep bump non the less =)).

    Is it possible to freeze vertical and horizontal rows and columns at the same time? This would work, I'd just move the chart to columns (A:D) and freeze them. I already have rows (1:5) froze as they contain column headings etc.

  4. #4
    Registered User
    Join Date
    12-14-2013
    Location
    United Kingdom
    MS-Off Ver
    Home & Student 2013
    Posts
    22

    Re: Freezing cells within a page whilst everything else moves

    Please excuse my lack of Excel knowledge. I've only just found out that it's possible to freeze both horizontal and vertical panes. I shall set this question as solved.

+ 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