Thank you Elkar! This solutions brings up another question. Is there anyway
to use this solution to make every other column in a selected row switch
positions. (ie. what was in A1 moves to A2 and what was in A2 moves to A1, A3
switches with A4, A5 with A6... all the way down). If so it would solve a
flash card making problem in which (through a Word mailmerge) the fronts of
the cards (column A = words) do not have the correct back of card (column B =
word definition). I think the problem would be solved by inverting every
other row in excel then doing the mail merge on word.

"Elkar" wrote:

You could use Conditional Formatting.

Select your range of cells to shade
From the Format Menu, choose "Conditional Formatting..."
Change "Cell Value Is" to "Formula Is"
Enter the formula: =MOD(ROW(),2)=0
Select your format (gray background)
Click OK

HTH,
Elkar


"Alan" wrote:

Any suggestions on how to quickly select every other row OR fill every other
row? With large lists I like to color every other row light gray for refrence
purposes.