Solved

How to change an excel worksheet row color alternately

Posted on 2013-01-19
5
412 Views
Last Modified: 2013-01-20
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
Comment
Question by:alam747
  • 2
  • 2
5 Comments
 
LVL 18

Assisted Solution

by:Raheman M. Abdul
Raheman M. Abdul earned 250 total points
ID: 38797622
0
 
LVL 50

Expert Comment

by:teylyn
ID: 38797643
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
 

Author Comment

by:alam747
ID: 38797749
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
 
LVL 50

Accepted Solution

by:
teylyn earned 250 total points
ID: 38797822
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
 

Author Closing Comment

by:alam747
ID: 38798815
Thanks a lot for your help
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

This very simple solution applies to a narrow cross-section of the "needs to close" variety. In this case, the full message in Event Viewer was in applog, Event ID 1000: Faulting application iexplore.exe, version 8.0.6001.18702, faulting module …
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now