+ Post New Thread
Results 1 to 4 of 4
Office Software Thread, [Solved] Excel repeat title row when scrolling down in Technical; I have a fairly deep spreadsheet which is viewed in Excel in both Office 2003 and 2007 how do you ...
  1. #1

    speckytecky's Avatar
    Join Date
    May 2006
    Location
    UK
    Posts
    2,623
    Thank Post
    3,560
    Thanked 300 Times in 228 Posts
    Blog Entries
    3
    Rep Power
    123

    [Solved] Excel repeat title row when scrolling down

    I have a fairly deep spreadsheet which is viewed in Excel in both Office 2003 and 2007 how do you get it to display the title row when you scroll down?
    Last edited by speckytecky; 31st January 2011 at 11:35 AM.

  2. #2
    dwhyte85's Avatar
    Join Date
    Mar 2009
    Location
    Berkshire
    Posts
    1,235
    Thank Post
    162
    Thanked 153 Times in 138 Posts
    Rep Power
    104
    Would freeze frames do this? Windows->Freeze Frames

    I can't remember how to adjust the frame it 'freezes' though.

  3. Thanks to dwhyte85 from:

    speckytecky (31st January 2011)

  4. #3

    Join Date
    Feb 2009
    Posts
    150
    Thank Post
    0
    Thanked 36 Times in 35 Posts
    Rep Power
    18
    select 2nd row

    Office 2003 - Windows > Freeze Panes
    Office 2007 - View > Freeze Panes

  5. Thanks to HilcrRWise from:

    speckytecky (31st January 2011)

  6. #4

    speckytecky's Avatar
    Join Date
    May 2006
    Location
    UK
    Posts
    2,623
    Thank Post
    3,560
    Thanked 300 Times in 228 Posts
    Blog Entries
    3
    Rep Power
    123
    Perfekt - worked a treat. TVM.



SHARE:
+ Post New Thread

Similar Threads

  1. Return the same row more then once
    By fawkers in forum Coding
    Replies: 3
    Last Post: 28th December 2010, 10:08 PM
  2. Lordy !! A Williams on the front row...
    By mattx in forum General Chat
    Replies: 4
    Last Post: 6th November 2010, 08:43 PM
  3. MRBS repeat bookings not saving
    By tonylb in forum Network and Classroom Management
    Replies: 2
    Last Post: 12th May 2009, 05:08 PM
  4. Front Row On Mac Mini
    By russdev in forum Mac
    Replies: 16
    Last Post: 3rd July 2008, 07:16 AM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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