I'm trying to make a fancy Excel spreadsheet, but there's a few things that I don't know how to do, and since I also don't know the proper names for the function I'm struggling to find how to do them in the Excel Help - so if someone even just knows the proper name for the following then that would probably help me a heap.

Basically, I've got a workbook open and in it I have a list of a whole bunch of people and some details about them, so there is a column for first name, one for last name, one for employee number, allocated section etc.
So at the top above all this I have the headings for each of the columns. Now I want to make so that when I scroll down the page these headings scroll down with, so I don't have to keep scrolling up to figure out what a particular column is for.

The other thing I'm trying to do relates to how they have been divided into sections. Is there a way that I can make options so that it just displays people from a particular section. So someway that I can sort it to show everyone, or if I select a different option it'll just display the people from 1 section.

EDIT: Just found the answer to my first question, it's called 'Freeze or lock rows and columns'.

Hey mate,

Each of your columns have headings yeah? So hightlight that whole row, then go to the data menu, select filter, then the option "auto filter" this brings up a drop down menu for each column. Select the column heading realting to your allocated section and it will then bring up a list of all you sections. Select the section you want, and then only those people will appear. You want to see everyone again you say? Select all from the drop down menu.

If you have any more questions, let me know. Im somewhat handy with Excel.

Also,

If your planning on printing this data, and you want the headings to go onto each page you can set this up in the page setup section. Let me know if you dont know how, ill can talk ya through it.

doddea i know how to do formula and get the answer to another cell, like in a3 youd type =a1-a2.
is there a way of putting times into boxes a1 and a2 and having the time span inbetween calculated to a3? eg work start times to a1, work end times to a2, and time spent at work worked out in a3?

Hey,
It's not that difficult well the easiest way is it do this:
Let say:
A1 = Start Time
A2 = End Time
A3 = Total Time

In A3 you will have this formula:
=(A2-A1)*24

Look at the screen shot. Column B is another example with the same principle.
There are other ways i just showed you an easier way.

You do not have the required permissions to view the files attached to this post.

PhatBa.. Pretty much what asizzy said!

Except personally i'd work across the screen as opposed to down... you could even put in a column for your break time. Then work your formula to deduct the break column at the end.

ok so pretty much its the same formula just add *24

Yes that is the formula.
On which ever cell is going to be your total type "=(A2-A1)*24" without the the quotation marks.
Just to clarify,
A1 refers to your Start Time
A2 refers to your End Time

You can also add in a Break Time also, that will also require you to modify the formula.