Floating Row/column?

[bpflyr]

I have about 200 rows of data and add more everyday. Is there a way to make a "floating row" so that I can see a running total at the bottom. Also would like to apply to same to column headings.

An example would be the column and row designations in Excel. As you scroll, they are always visible. Is there a way to do this with "user defined" rows and columns?

If it's not possilble or REALLY complicated please tell me so I don't post the same question again. Thank you all.

 

[erik.van.geit]

bpflyr,
take a look at freeze panes in the menu window

select row, select freezepanes
OR
select column, select freezepanes
OR
clicking in a single cell and then choosing freezepanes gives you froozen columns at the left AND froozen rows on top

you can't apply this to the bottom

a workaround would be the cameratool
To find the Camera tool
go to |Tools|Customize|Commands| …
then in the 'Categories' pane choose the 'Tools' category,
in the 'Commands' pane look for the Camera icon and drag it up to your Excel toolbars area.
OR
use splitwindow

kind regards,
Erik

 

[bpflyr]

Thank you so much. You guys are truely wizards at Excel!!

 

[erik.van.geit]

you're welcome
how did you solve it ?