1) Highlight the area you want to format. Go to Format-Conditional
Formatting. Change the drop-down to Formula Is, and type the following in the
space provided:
=Row()=Even(Row())
Next select Format button, click the pattern tab and select the color you
want, hit OK twice and you're done.

2) Select the entire second row by clicking the 2 on the left, go to
Window-Freeze panes.

Thats it
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"RSteph" wrote:

It's been a while since I've done much with Excel besides making quick &
dirty spreadsheets, so I'm a little out of practice.

I'm trying to make a spreadsheet that shows a list of what version of our
software each individual is on, to help with support questions based on
version. I have the names in a column on the right, and the version #'s
listed above, with all the data listed. Now I'm trying to do two things to my
sheet to make it more readable.

1) I'd like to shade the rows in an alternating pattern (even # rows grey,
odd # rows white) to make it more readable.

2) I'd like to make the top row (the header row) appear at the top of the
page at all times. I know how to make it do this in printing, put it at the
top of each page, but I'm not sure how to get it to stay there on the actual
spreadsheet file.

I could probably do some of this with a macro if I sat down and through
through the steps, but I was curious if there was an easier way of doing
this? I was going to use conditional formatting for the highlighting, but
there is no even/odd option. And I thought there was a quick way to place a
row always at the top of the page, but I can't remember what it is.

Any help would be greatly appreciated. Thank you.