Create a floating cell that totals a column of numbers

  • Thread starter Thread starter doffavoffid
  • Start date Start date
D

doffavoffid

The version I'm using is Microsoft Office 2007 for Home and Student. What I
want to do is create a floating cell that always reflects total sum for a
list of numbers that I'm constantly adding to. I want this cell to be
viewable at all times as I add more and move further down the spreadsheet.
Is there a way to do this?
 
hi, !
The version I'm using is Microsoft Office 2007 for Home and Student.
What I want to do is create a floating cell that always reflects total sum for a list of numbers
that I'm constantly adding to. I want this cell to be viewable at all times
as I add more and move further down the spreadsheet.
Is there a way to do this?
Click to expand...

op1: make (i.e.) [A1] "the cell" where your formula resides
select [B2] and use (tab) view / freeze panes (not floating, but fixed)

op2: do a copy for your cell (wherever it is) and paste an image (wherever it be)
and use code to make that shape to follow your window scrolling

hth,
hector.
 
Back
Top