+ Reply to Thread
Results 1 to 3 of 3

How do you keep a Table's "Totals Row" always visible while scrolling

  1. #1
    Registered User
    Join Date
    12-13-2020
    Location
    Texas
    MS-Off Ver
    2016
    Posts
    11

    Question How do you keep a Table's "Totals Row" always visible while scrolling

    I have a Table with a couple thousand rows. I right-clicked in the Table and selected Totals Row. Nice feature. There's now a dynamic total that sticks to the last row of the table regardless of what filter criteria I select.

    I want to scroll through the rows above the Totals Row, changing filter criteria at times, and always have that total visible. I used the View > Split feature in an attempt to keep the Totals Row visible at the bottom of the window, but sometimes it gets moved while scrolling. I can't get the Freeze Panes feature to help.

    Any suggestions?

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,602

    Re: How do you keep a Table's "Totals Row" always visible while scrolling

    1. You can copy the totals row, insert a new row above the table and paste the copied totals formulas to the new row.
    2. Use the camera tool. Select the totals row, click the camera. Click in the header row to paste the picture. Adjust the header row height to include the picture. Freeze panes as before...
    Attached Files Attached Files
    Ben Van Johnson

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,380

    Re: How do you keep a Table's "Totals Row" always visible while scrolling

    Or, using Ben's sample file to demonstrate, you could insert a row before the Table and use the formula:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    in cell A1 and copy it across. Copy the formatting from the Total Row.
    Attached Files Attached Files
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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] Need assistance with "Pivot Table", "Slicer", and "Dynamic/Interactive Graph"
    By skydivetom in forum Excel Charting & Pivots
    Replies: 26
    Last Post: 06-27-2020, 11:03 AM
  2. Replies: 1
    Last Post: 04-26-2017, 01:26 PM
  3. Replies: 6
    Last Post: 11-07-2015, 02:03 PM
  4. Replies: 1
    Last Post: 06-06-2013, 06:28 PM
  5. Replies: 2
    Last Post: 06-06-2013, 12:45 PM
  6. [SOLVED] How to Count number of "Error" and "OK" after the word "Instrument" found in table row
    By eltonlaw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2012, 06:26 AM
  7. [SOLVED] Pivot Table "Include hidden items in totals"
    By LizO in forum Excel General
    Replies: 0
    Last Post: 03-14-2006, 03:40 PM

Tags for this Thread

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