How do I set different colors to alternate rows?
How do I set different colors to alternate rows?
Another thread said "go to the sheet properties and set alternate shading for the whole worksheet" where exactly is that?
Re: How do I set different colors to alternate rows?
Classic menu: Worksheet > Worksheet > Properties...
Ribbons: Insert > Sheet > Properties...
At "Background", check "Alternating shade" and choose colours for shade 1 and shade 2.
Ribbons: Insert > Sheet > Properties...
At "Background", check "Alternating shade" and choose colours for shade 1 and shade 2.