View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default Floating cell containing a "Running Total".

Put the running total formula in a cell in the top row of the sheet.

Select A2 and WindowFreeze Panes to keep row 1 in view as you scroll down.


Gord Dibben MS Excel MVP

On Mon, 26 Jun 2006 10:04:10 -0500, Dantheman
wrote:


How do I make a cell that contains a running toal to float on the screen
as a viewer scrolls down a long spreadsheet? Thanks.