Every Other Row Gray Excel Full Site Gannett

Save 90 Local Sports Things to Do Business Travel Politics Opinions Homes Subscribe Archives Nation Jobs More Cars Video Apartments Shopping Classifieds Insider azcentral tickets Lottery Obituaries E-Newspaper Investigations Comics Buy Photos Apps Giving Back New Home Central Monsoons Business Directory Member Guide Traffic Moonlighting Advertise with Us USA TODAY NETWORK Public Notices Subscribe Home Local Sports Things to Do Nation Now Business Travel Explore Politics Opinion Investigations Marketplace Insider Advertise with Us Obituaries Archives Weather Subscribe How to Copy a Table From Word to PowerPoint How to Do a Nested Table in Word How to Alternate White and Gray Cells in Excel by Kathryn Hatashita-Lee Related Articles How to Copy a Table From Word to PowerPoint How to Do a Nested Table in Word How to Change the Color of a Hyperlinked TextBox in PowerPoint The Steps in Writing a Summary in PowerPoint How to Convert Word Tables Into Excel How to Create Vertical Headings in Excel Share on Facebook Microsoft Excel enables you to change your worksheet to a table style to improve readability for you and your clients.

For example, a tables row colors may help your viewers distinguish each row or field of data, especially useful for working with large worksheets.

Excels table styles include alternate shading or banding in various intensities.

Selecting a gray and white combination helps separate each row without the distraction of bright colors.

Step 1 Click and drag to select the cells that you want to format.

Step 3 Mouse over the thumbnails of samples to preview the color changes to your worksheet.

For example, the first column of samples includes gray and white in the Light, Medium and Dark sections.

References Microsoft Office: Excel 2010, Overview of Excel Tables Microsoft Office: Excel 2010, Format an Excel Table, Choose a Table Style When You Create a Table Microsoft Office: Excel 2010.

Convert an Excel Table to a Range of Data Tips To convert the table to a range of data and still keep the color bands, right-click a cell, mouse over Table and click Convert to Range.

Warnings Information in this article applies to Microsoft Excel 2010.

It may vary slightly or significantly with other versions or products.

Every Other Row Gray Excel Full Site Gannett

Services About azcentral.com Contact Republic Media azcentral FAQ Advertise with Us Circulation FAQ and contact Work With Us Terms of Service Privacy NoticeYour California Privacy Rights Community Rules Do not sell my data Cookie policy Ad Choices The Arizona Republic Online Obituaries Video Photos Lavozarizona.com Lottery results Giving Back Advertising Terms and Conditions Archives Member Guide Our Partners Jobs Cars Homes Find and Save Classifieds GO Digital Help Terms of Service Privacy NoticeYour California Privacy Rights Do not sell my data Cookie policy Ad Choices Full Site Gannett 2019.

Every Other Row Gray Excel For Mac