Can I freeze different rows? Can anyone help?

[starlet]

Hi Everyone, My excel skills are basic so hopefully you'll understan
what I want to do... I have created a sheet with headers/titles at th
top of the columns on a sheet and at the bottom of the sheet (all o
one page) are the totals. I wish to freeze the top 4 rows so they don
move and the bottom 3 rows so when you use the scroll bar only th
middle part of the sheet moves. This is so you can see the headers fo
each column and the totals at the bottom of the screen at all times. I
this even possible? Hope someone understands what I mean. I have trie
using the freeze pane function but it seems I can only freeze either th
top or the bottom not both.

Any help would be greatly appreciated.

Thanks
Gran

 

[VBA Noob]

Hi,

Could you move the totals to the top of the screen above headings an
then just select the 4 row and use Windows > Freeze Panes or Spli
Panes

VBA Noo

 

[starlet]

Thanks for your suggestion. I have given that a go and it just look
way too busy with headers and totals all at the top of the sheet. I'l
keep workin on i guess..

Cheers

Gran

 

[broro183]

HI Grant,

This isn't exactly what you want but have a look & see if "watch
window" exists in your version of Excel (I'm using 2002) under View -
Toolbars - Watch Window.

This can be moved around the screen & means the value of the "watched"
cell/cells is always visible.

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...

 

[starlet]

Thanks for your help but it doesnt really look that great and doesnt
show the headers etc when you use this function.

Cheers

G

 

[broro183]

hi,

You're right, it's not the prettiest layout but if used in conjunction
with freezing the header rows it should be functional & will allow you
to see both...

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...