Spreadsheet Shader

The following are the basics of using Spreadsheet Shader macro


This macro colours alternating lines in a Worksheet selection to aid the user reading the data when it is printed out.

graphic

The result, based on the defaults above:

graphic

The columns can be shaded instead of the rows as shown below using single line groups.

graphic

As the default area is the currently selected range, by selecting different areas and changing the line counts, different patterns can be created. For example, in the picture below, the week column was performed using a 7:7 line pattern, the day column was performed using a 3:4 line pattern.

graphic



graphic

Created with the Personal Edition of HelpNDoc: Easily create EPub books