+ 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,564
    Thank Post
    3,469
    Thanked 286 Times in 215 Posts
    Blog Entries
    3
    Rep Power
    116

    [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 10:35 AM.

  2. #2
    dwhyte85's Avatar
    Join Date
    Mar 2009
    Location
    Berkshire
    Posts
    1,226
    Thank Post
    161
    Thanked 150 Times in 135 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
    149
    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,564
    Thank Post
    3,469
    Thanked 286 Times in 215 Posts
    Blog Entries
    3
    Rep Power
    116
    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, 09:08 PM
  2. Lordy !! A Williams on the front row...
    By mattx in forum General Chat
    Replies: 4
    Last Post: 6th November 2010, 07:43 PM
  3. MRBS repeat bookings not saving
    By tonylb in forum Network and Classroom Management
    Replies: 2
    Last Post: 12th May 2009, 04:08 PM
  4. Front Row On Mac Mini
    By russdev in forum Mac
    Replies: 16
    Last Post: 3rd July 2008, 06: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
  •