"freeze" row #300 in an Excel document

**foodpantrymike** · 06-05-2012, 06:52 PM

I've got a workshhet with 7 sheets, and each one carries different data that I combine on the 7th sheet. I've got another file that I have to use to report each month. Both files have a different header row. On the dominant document I have "frozen" the top row. Is there a way to also "freeze" the top row of the other document, which is row 300?

**TMS** · 06-05-2012, 07:05 PM

You could maybe split the window and view from row 300 in pane 2.

Regards, TMS

**foodpantrymike** · 06-05-2012, 09:21 PM

Thanks TMShucks, also I sussed out I could "unfreeze" line 1 and scroll down to 301 and "freeze". It would be a bit of a pain, but it works. Thanks

**TMS** · 06-05-2012, 11:50 PM

I didn't think you'd want to freeze 300 lines.

To get to line 300: press F5 (Go to); type in A300; press OK

**foodpantrymike** · 06-06-2012, 06:02 AM

In an attempt at brevity I omitted than lines 290:299 are numeric values. I need to transfer some of the cell contents onto the "copied" form, but I can't remember from one page to the next and for me, printing it out was feasable. So I copied one and "attached' it to my worksheet(s). As I scroll down to...I think you understand. Yes, I'm new to the use of a computer, at least today's versions, and my 62 year old mind likes to go on trips. Thanks for the additional.