ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   is there a way to make floating data blocks on the page (https://www.excelbanter.com/excel-discussion-misc-queries/200647-there-way-make-floating-data-blocks-page.html)

Pat

is there a way to make floating data blocks on the page
 
looking to make a floating data block with the totals follow the page down so
not to have to keep going to top to see data changes. is this possible

Max

is there a way to make floating data blocks on the page
 
"pat" wrote:
looking to make a floating data block with the totals follow the page down so
not to have to keep going to top to see data changes. is this possible


In excel 2003, you could try clicking:
Tools Formula Auditing Show Watch Window
to surface the dialog
Then click Add Watch, and select the required cells ...

The dialog will float/remain visible as you scroll down/to the right
and it'll show the changes

I don't use this feature much, but it might fit what you're after
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500 Files:358 Subscribers:55
xdemechanik
---


All times are GMT +1. The time now is 07:00 PM.

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