Ok got a few questions, these questions might seem stupid but i have no clue about excel! I am making a staff rostering program. I am using Excel 2007.

Questions

1) How to a make text spread across a few cells, i have text in a colum that i want to make smaller but the text gets cut off, how do i make it spread across a few cells, tried looking in 'format cells' but havent be able to work it out.

2) I have been using data vailidation to make drop down list for times, the times are 9am - 9pm, 8am - 5pm, etc. Is there anyway of using a formula to calculate these times in excel from a drop down list after the option has been choosen in that list? for example the list is in A1, i have choosen the time 8am- 5pm and i want to calculate the number of hours for the choosen time in A2, is this possible?

3) One of the options in the drop down list is 'not needed' i have another cell made up called 'not required'. Is it possible that when the drop down list is used and 'not needed' is selected make cell A3 = 'not required' so when 'not needed' is selected cell A3 automically brings up 'not required'?

4)What do the blue lines mean around spreadsheets? how do you put them there?

5)Is there a way of stopping duplicates of staff being assigned to the same time on the same day. A warning message or something would be good.

Im sure i will have a few more questions in the future

Thanks for your help.