• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 449
  • Last Modified:

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
0
alam747
Asked:
alam747
  • 2
  • 2
2 Solutions
 
Raheman M. AbdulSenior Infrastructure Support Analyst & Systems DeveloperCommented:
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

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
0
 
alam747Author Commented:
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
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

I assume with "Combo Box" you refer to the drop-down tools for sorting and filtering a list. You can turn these off in the Data ribbon. Select any cell in the table, then click Data > Filter

cheers, teylyn
0
 
alam747Author Commented:
Thanks a lot for your help
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now