Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dantheman
 
Posts: n/a
Default Display/formula help


How do I get a "running total" to always display on the screen even as
the viewer scrolls down a long spreadsheet? Thanks.


--
Dantheman
------------------------------------------------------------------------
Dantheman's Profile: http://www.excelforum.com/member.php...o&userid=35117
View this thread: http://www.excelforum.com/showthread...hreadid=555610

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John
 
Posts: n/a
Default Display/formula help

Split the Frames?


"Dantheman" wrote
in message ...

How do I get a "running total" to always display on the screen even as
the viewer scrolls down a long spreadsheet? Thanks.


--
Dantheman
------------------------------------------------------------------------
Dantheman's Profile:
http://www.excelforum.com/member.php...o&userid=35117
View this thread: http://www.excelforum.com/showthread...hreadid=555610



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo
 
Posts: n/a
Default Display/formula help

select the row after the total one

Go to Window | Freeze Panels

HTH
Regards from Brazil
Marcelo

"Dantheman" escreveu:


How do I get a "running total" to always display on the screen even as
the viewer scrolls down a long spreadsheet? Thanks.


--
Dantheman
------------------------------------------------------------------------
Dantheman's Profile: http://www.excelforum.com/member.php...o&userid=35117
View this thread: http://www.excelforum.com/showthread...hreadid=555610


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dantheman
 
Posts: n/a
Default Display/formula help


Thanks, Marcelo. It works. Looks great!!


--
Dantheman
------------------------------------------------------------------------
Dantheman's Profile: http://www.excelforum.com/member.php...o&userid=35117
View this thread: http://www.excelforum.com/showthread...hreadid=555610

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 02:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"