+ Reply to Thread
Results 1 to 2 of 2

how can i keep the headings of a table (one row) to continue to be displayed when i scroll

  1. 02-20-2014, 10:47 AM #1
    elliottt
    elliottt is offline
    Registered User
    Join Date
    02-20-2014
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    20

    how can i keep the headings of a table (one row) to continue to be displayed when i scroll

    When i scroll down in my table, I want the headings to stay displayed (the whole of row B).
    Can anybody please help?
    Last edited by elliottt; 02-21-2014 at 05:40 AM.
    Reply With QuoteRegister To Reply
  2. 02-20-2014, 10:53 AM #2
    elliottt
    elliottt is offline
    Registered User
    Join Date
    02-20-2014
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: how can i keep the headings of a table (one row) to continue to be displayed when i sc

    Never mind, I have found the solution.

    View > Freeze Panes
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to make headings change as I scroll through data?
    By novice2430 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-28-2009, 01:34 AM
  2. Scroll worksheet with userform displayed
    By naeem76 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-21-2009, 07:23 AM
  3. How do I lock the top 2 rows (headings) so that they are always displayed when moving around the spreadsheet?
    By Clubsprint in forum Excel General
    Replies: 1
    Last Post: 05-04-2006, 08:40 PM
  4. Column Headings Scroll out of view
    By Grd in forum Excel General
    Replies: 1
    Last Post: 07-05-2005, 03:05 PM
  5. [SOLVED] How to hide the column headings displayed by Excel at the left of.
    By pc300 in forum Excel General
    Replies: 1
    Last Post: 01-28-2005, 04:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1