ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Display/formula help (https://www.excelbanter.com/excel-worksheet-functions/96107-display-formula-help.html)

Dantheman

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


John

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




Marcelo

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



Dantheman

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



All times are GMT +1. The time now is 04:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com