Locking rows, locking columns etc like MS Excel template

[27am_dot_com]

Found a template on Microsoft's site that it perfect for what I want t
accomplish. Onlly thing is, I need to duplicate it to fit my needs.

The template I'm refering to is:
"Job applicant data and comparison table"
found at:
Templates > Microsoft Office Programs > Excel > Business > Huma
Resources
try the following link if interested:
http://office.microsoft.com/en-us/templates/CT011356681033.aspx

This brings about a lot of newbie questions to try to achieve thi
exact layout.
1. how do I lock the top rows (title and column headings) so that whe
I scroll the page, they are still visible (so I can see what field th
data falls under)

2. how do I lock the first few columns (first 5 for my needs) so tha
when I scroll right, the remaining data simply scrolls but my 5 sta
visible

3. how do I create a drop down list or "field arrow" for every colum
(I know this template already has it in place but my data has twice a
many columns and so I need to create new lists but don't know how)

4. how do I create a background pattern so that each row is a
alternating color for easier viewing (ie: first row white, next ro
blue, next row white, next row blue... etc)

As you'll note all the questions relate directly to the template.
would love it if someone could provide some guidance towards puttin
this all together to fit my needs.

One last question... this isn't on the template and I'm not sure if i
can be done. I have one column at the end of each data row whic
contains "notes" or "memo" items. Some of these are very short bu
some are very long. Is there a way that I can create a box or a popu
or something so that the full details display in a neat manner onl
when I want to look at them?

Thank you.
Ro

 

[Angel160]

Right, in order:

1 & 2 - click on the cell that is on the cross-point of the rows an
colums you want to freeze (e.g if you want to freeze rows 1 & 2 an
columns A & B, click in cell C3), go to Window and select Freez
Panes.

3 - for drop-down lists, go to View, Toolbars, Forms and a drop-dow
list button is available. If you need help with this then the Hel
option on Excel is quite good.

4 - Highlight the cell that you want to format, right click your mous
button and select Format Cells. Go to Patterns and select the colou
that you want.

5 - select the cell that you want the comment to appear in, right clic
you mouse button and select Insert Comment. You can either choose t
show this comment all the time or if not, it will only show when yo
hover your cursor over the relevant cell.

Hope this helps

 

[Gord Dibben]

Rob

1 & 2 from Angel cannot be improved upon.

3 from Angel would be easier using Data>Validation drop-down lists.

See Debra Dalgleish's site for DV info

http://www.contextures.on.ca/xlDataVal01.html

4 from Angel will not do what you want. Use Conditional Formatting to achieve
a banded look to the sheet.

See Chip Pearson's site for "color banding" with CF

http://www.cpearson.com/excel/banding.htm

5 from Angel works fine.

Gord Dibben Excel MVP