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

a	b	c	d	e	f	g	h
1
2				freeze	freeze
3				freeze	freeze
4				freeze	freeze
5				freeze	freeze
6				freeze	freeze
7

<tbody>
</tbody>

 

[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.