Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Keeping Excel Headings

  • 18-12-2006 8:22pm
    #1
    ublinia2
    Closed Accounts Posts: 114 ✭✭


    When you are looking at a spread sheet in excel how do you keep the headings when you are scrolling through the data

    e.g.

    04. Population of each Province, County, City, urban area, rural area and Electoral Division, 2002 and 2006

    Population Persons 2002 Persons 2006 Males 2006 Females 2006 Actual change 2002-2006 Percentage change 2002-2006
    Geographic Area
    Leinster 2105579 2292939 1140052 1152887 187360 8.9
    Carlow County 46014 50471 25639 24832 4457 9.7
    Carlow Town 13218 13898 6909 6989 680 5.1

    I want to keep the headings population etc so i can see them all the time even when i scroll down through the page of data.


Comments

  • #2
    dudara
    Registered Users, Registered Users 2 Posts: 33,518 ✭✭✭✭dudara


    Highlight the row under the one with the headings. Go to Window -> Freeze Pane


  • #3
    ublinia2
    Closed Accounts Posts: 114 ✭✭ublinia2


    thanks !


Advertisement