logo ASAP Utilities

You can do this too

Download "The one essential add-in for all Excel users."
Sit down and relax, while ASAP Utilities does the rest!

“Working in Excel will be fun again with all these extra supersmart tools”

ASAP Utilities, description of our Excel tools

English (us) / Nederlands / Deutsch / Español / Français / Português do Brasil / Italiano / Русский / 中文(简体) / 日本語

Columns & Rows » Color each n'th row or column in selection...

Fill every n'th row or column in your selected range with a specified color. This method is also known as 'color-banding' and 'alternate shading'.
This will improve the readability of tables with a lot of data.
You can specify a color, rows or columns and the steps, for example to make every second row in your selection grey.

There are two methods to color the rows or columns:
  • Standard coloring. This has the option to skip hidden rows/columns.
  • Conditional formatting (advanced). With this option the colors will be automatically updated when you insert or remove rows or columns. To remove the color, choose in the Excel menu 'Format' > 'Conditional Formatting' then remove the condition that sets the alternate colors (by default condition 1). If you use this option then the possibly existing conditional formatting will be removed.

    By default you can start this utility with the shortcut Control+Alt+C.


    Example screenshot: Example alternate row coloring
    Example alternate row coloring

    Starting this utility

    In the Excel menu choose: ASAP Utilities » Columns & Rows » Color each n'th row or column in selection...

    « Return to the list of “Columns & Rows” tools.
    « Previous
    Advanced sorting...
     Next »
    Detect and visualize adjacent data/group changes...
    Additional keywords for this tool:
    Colour, colours, colorbanding

  • Home Privacy Policy Cookie Policy EULA Sitemap Search List of all utilities Printer friendly page Contact Us ^ Back to Top
    © 1999-2021 - - - - The Netherlands

    Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
    Follow us on TwitterFollow us on Facebook