alam747
asked on
How to change an excel worksheet row color alternately
Hi,
I there any way to change the an excel sheet row color alternately,
If there any format option that can be use to change the accordingly.
I want to change the whole sheet light grey and white alternately.
Thanks
I there any way to change the an excel sheet row color alternately,
If there any format option that can be use to change the accordingly.
I want to change the whole sheet light grey and white alternately.
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks to both of you, if there any way to avoid the combo box. I do not want the combo box on the header cells.
If there any way to avoid it ?
Thanks
If there any way to avoid it ?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks a lot for your help
what version of Excel? From 2007 onwards, you can use an Excel Table with Insert > Table, and then select a table style. Most of them have alternating row colors and you don't have to pre-format the whole sheet.
cheers, teylyn