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

How to do this in MS Excel...

  • 19-08-2007 5:23pm
    #1
    Trotter
    Closed Accounts Posts: 5,362 ✭✭✭


    Im trying to design a custom organiser in excel and one thing is bugging me. What I want is a column down the left and a row across the top that never move.

    When I use freeze panes I cant get it exactly as I want it. Its pretty much like a website with frames.. with the left hand column and the header staying static.

    Like so..

    excel.jpg


    Can anyone put me out of my misery???


Comments

  • #2
    rockal
    Registered Users, Registered Users 2 Posts: 757 ✭✭✭rockal


    Select cell B2, then Freeze Panes.


  • #3
    Trotter
    Closed Accounts Posts: 5,362 ✭✭✭Trotter


    If I use freeze panes from B2, Row 1 will only stay static if the data is moved up and down..

    I need row 1 to stay static if the sheet is being moved up and down OR left or right.. as in truly static no matter what way I move the sheet.


  • #4
    trout
    Registered Users, Registered Users 2 Posts: 9,957 ✭✭✭trout


    If you select cell O35, select Window/Split, and then select Window/Freeze Panes ... you will get a 15 x 35 grid that will be static. (035 is bottom right on my display).

    It's not exactly what you asked for, as you can move the cursor beyond the grid, but the grid itself will always be on screen. You can format the first row & column to be different to the grid for data.

    Will that help ?

    Failing that, could you use a Word table instead ?


  • #5
    Trotter
    Closed Accounts Posts: 5,362 ✭✭✭Trotter


    trout wrote:
    If you select cell O35, select Window/Split, and then select Window/Freeze Panes ... you will get a 15 x 35 grid that will be static. (035 is bottom right on my display).

    It's not exactly what you asked for, as you can move the cursor beyond the grid, but the grid itself will always be on screen. You can format the first row & column to be different to the grid for data.

    Will that help ?

    Failing that, could you use a Word table instead ?


    Yeah I've tried the split but split and freeze panes doesnt work simultaneously. Word wont help because by the time this is finished, I'll have a load of tabs and a summary tabs showing formula info based on the others.

    (Basically Im making a teacher organiser for the school year.. 3 tabs.. 3 terms.. one summary page so I can see who's absent the most, etc).

    Ya dig? :)


  • #6
    trout
    Registered Users, Registered Users 2 Posts: 9,957 ✭✭✭trout


    Have you thought about an MS Access database ?

    I've been playing with Excel for the last hour, and I can't see a way to do what you need. My boss is bound to get suspicious soon. :rolleyes:


  • Advertisement
  • #7
    trout
    Registered Users, Registered Users 2 Posts: 9,957 ✭✭✭trout


    Have you thought about an MS Access database ?

    I've been playing with Excel for the last hour, and I can't see a way to do what you need.
    My boss is bound to get suspicious soon. :rolleyes:

    What version of Excel have you ? Have you looked at the various freebie templates on the MS website ?

    edit : http://www.getworksheets.com/samples/excel/attendance.html


Advertisement