freezing cells

[ttowncorp]

is there a way I can freeze a cell and row that's in the middle of my page. if i have box that is e2-36 to f2-f6 is there a way I can freeze that area? so when i scroll down that area i want to freeze stays in the center


[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]a[/TD]
[TD]b[/TD]
[TD]c[/TD]
[TD]d[/TD]
[TD]e[/TD]
[TD]f[/TD]
[TD]g[/TD]
[TD]h[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]freeze[/TD]
[TD]freeze[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]freeze[/TD]
[TD]freeze[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]freeze[/TD]
[TD]freeze[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]freeze[/TD]
[TD]freeze[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]freeze[/TD]
[TD]freeze[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[mole999]

select the cell then View > Freeze Panes > Freeze Panes. you cant just freeze a visible range on its own.

you might try opening a second window, tiling and then just display that in one window

 

[Haluk]

I have prepared an alternative solution using macros as seen in the link below.

https://drive.google.com/open?id=0Bw38kVQiZJZEaXlBNGZSdnRocms

The range H5:J10 will be shown on a picture on the sheet and will be always visible for you what ever cell is selected on the sheet.

Also, the picture is dynamicaly updated with the cells H5:J10

 

[ttowncorp]

thank you I will see if this will work for me.