Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
row placement & alternating highlighting
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
alternating format | Excel Discussion (Misc queries) | |||
Alternating between worksheets | Excel Discussion (Misc queries) | |||
alternating colors | Excel Worksheet Functions | |||
Alternating Margins | Excel Discussion (Misc queries) | |||
Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck. | Excel Discussion (Misc queries) |