Floating cell containing a "Running Total".

  • Thread starter Thread starter Dantheman
  • Start date Start date
D

Dantheman

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.
 
Put the running total formula in a cell in the top row of the sheet.

Select A2 and Window>Freeze Panes to keep row 1 in view as you scroll down.


Gord Dibben MS Excel MVP
 
You may use a Watch Window.

Go to TOOLS/FORMULA AUDITING?SHOW WATCH WINDOW. Then add the cells you would
like to monitor. This will also enable you to track scattered cells, all at
the same time. You amy also move/resize the window as you please.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Floating block of cells at top of Spreadsheet 3
Floating a Key Range (Excel 2007) 1
Create a floating cell that totals a column of numbers 1
Can you float a chart or table 1
Floating row? 2
"Floating" button 2
floating header 3
How do I add a floating text box in Excel? 1

Back
Top