Home Screenshots 10 Languages Why use it?

Tip of the Day | Wednesday May 15th, 2024

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

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.

Screenshots

Example screenshot: Example alternate row coloring

Starting this tool

Click ASAP Utilities › Columns & Rows › 3. Color each n'th row or column in selection...
Specify a Keyboard Shortcut: ASAP Utilities › Favorites & Shortcut keys › Edit your favorite tools and shortcut keys...

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

Choose your language preference below

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

Today's Tip

Download

©1999-2024 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands

Empowering Excel Users Worldwide for 25 Years