+ Reply to Thread
Results 1 to 6 of 6

"freeze" row #300 in an Excel document

  1. #1
    Registered User
    Join Date
    06-05-2012
    Location
    Hookerton NC
    MS-Off Ver
    Excel 2003
    Posts
    4

    Post "freeze" row #300 in an Excel document

    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?

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    38,172

    Re: "freeze" row #300 in an Excel document

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


    Regards, TMS
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    06-05-2012
    Location
    Hookerton NC
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: "freeze" row #300 in an Excel document

    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

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    38,172

    Re: "freeze" row #300 in an Excel document

    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

  5. #5
    Registered User
    Join Date
    06-05-2012
    Location
    Hookerton NC
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: "freeze" row #300 in an Excel document

    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.

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    38,172

    Re: "freeze" row #300 in an Excel document

    You're only a year or so older than me ... but I have to admit I'm not new to computers

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1