Excel 2013 Alternate Rows to be highlighted

Posted on 2013-09-11
Medium Priority
Last Modified: 2013-09-12

I have a single excel spreadsheet with rows of data and i wish to highlight every second row for better readability. I can add a numbered control if required as an example BUT can you please provide a method to highlight the alternate row in grey for readability.

Question by:shaunwingin

Accepted Solution

Chris Wong earned 2000 total points
ID: 39485861
How to shade every other or alternate rows in Excel?
LVL 12

Expert Comment

ID: 39485868
You could also turn it into a table which has that by default.

Select all the data (including headers) then go to Insert->Table and make sure My Table has Headers is selected.

You will now have different coloured alternating rows and your ability to sort and filter will also be built into the headers.

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This tutorial summarizes the causes behind"an unknown error prevented access to the PST File”.  It also suggests the various solutions to fix the problem.
Read this tutorial to learn how to fix repeating password error prompts when setting up Gmail IMAP with Microsoft Outlook. The entire process is described with step by step, illustrated instructions. Enjoy...
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

586 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