+ 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
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    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!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    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
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    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,085

    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
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    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
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    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)

Similar Threads

  1. [SOLVED] Help creating a continuously scrolling screen update with Excel VBA
    By Andrew Entee in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-15-2017, 02:48 AM
  2. [SOLVED] How to stop the screen scrolling all over the place
    By Muzza86 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-30-2014, 06:15 AM
  3. [SOLVED] Screen Scrolling Macro (VBA) freezes
    By kencoburn in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 03-21-2012, 01:07 PM
  4. Controlled vba screen scrolling
    By buckhunt122 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-06-2011, 01:56 AM
  5. How do I lock a screen to prevent scrolling?
    By raveepoojari in forum Excel General
    Replies: 5
    Last Post: 04-06-2009, 02:12 PM
  6. [SOLVED] How do I keep a text box on the screen when scrolling in excel?
    By Paulm in forum Excel General
    Replies: 4
    Last Post: 07-27-2006, 10:40 AM
  7. [SOLVED] How do I keep a text box on the screen when scrolling?
    By Paulm in forum Excel General
    Replies: 1
    Last Post: 07-27-2006, 08:40 AM

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