+ Reply to Thread
Results 1 to 10 of 10

Keep Cells on Screen When Scrolling (Not in top row)

  1. #1
    Registered User
    Join Date
    01-02-2018
    Location
    United States
    MS-Off Ver
    Microsoft Office Professional Plus 2010
    Posts
    12

    Keep Cells on Screen When Scrolling (Not in top row)

    Hello,
    I have an excel worksheet with several columns of numerical data. I use SUM to get the total of each column. The totals are currently displayed at the top of the worksheet separate from the main table. The problem is once you scroll down in the worksheet you can't see the totals anymore. The top row of the worksheet is currently frozen using freeze panes. I am looking for a way to keep the totals on screen without having to freeze the top 4 rows of the worksheet. Is there a feature where you can have a selection of cells (that aren't in the top row(s)) stay stationary on screen when scrolling?

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    21,404

    Re: Keep Cells on Screen When Scrolling (Not in top row)

    No, there isn't.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    21,404

    Re: Keep Cells on Screen When Scrolling (Not in top row)

    Having said this, have you ever looked at the camera tool in Excel?

  4. #4
    Registered User
    Join Date
    01-02-2018
    Location
    United States
    MS-Off Ver
    Microsoft Office Professional Plus 2010
    Posts
    12

    Re: Keep Cells on Screen When Scrolling (Not in top row)

    I have not. I am unaware of this tool.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    21,404

    Re: Keep Cells on Screen When Scrolling (Not in top row)

    Have a look at it. You might be able to add a snapshot of the cells in question to the section of the screen you have frozen at the top.

    Have a look here: https://www.extendoffice.com/documen...mera-tool.html

  6. #6
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,081

    Re: Keep Cells on Screen When Scrolling (Not in top row)

    You can also use Excel's native Watch window button on the Formulas tab, though it requires setting up each time.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  7. #7
    Registered User
    Join Date
    01-02-2018
    Location
    United States
    MS-Off Ver
    Microsoft Office Professional Plus 2010
    Posts
    12

    Re: Keep Cells on Screen When Scrolling (Not in top row)

    That should work for what I need. Thank you.

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    21,404

    Re: Keep Cells on Screen When Scrolling (Not in top row)

    Which solution, out of interest?

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

  9. #9
    Registered User
    Join Date
    01-02-2018
    Location
    United States
    MS-Off Ver
    Microsoft Office Professional Plus 2010
    Posts
    12

    Re: Keep Cells on Screen When Scrolling (Not in top row)

    AliGW, I'll be using your solution. The camera tool gives me the basic functionality I needed. The only problem is I'll just have to keep moving the totals down as I scroll down the list but that's only a minor inconvenience.

  10. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    21,404

    Re: Keep Cells on Screen When Scrolling (Not in top row)

    Thanks for letting us know.

+ 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