• Sections
  • About Nested Sections
  • About Section Formatting
  • About Sections
  • Ambiguous Section Dialog
  • Manual Section Sort Dialog
  • Name Conflict With Section Sort Groups Dialog
  • Section Copy Data Dialog
  • Section Resize Dialog
  • Sections Dialog
  • Specify Section Dialog
  • Assigning Labels to Sections
  • Building and Assigning a Section Header
  • Creating a Box
  • Creating a Shaded Area
  • Creating a Vertical Line
  • Deleting a Section Label
  • Keeping the Lines of a Section Together
  • Locate a Labelled Section
  • Modifying Section Formatting
  • Navigating to a Labelled Section Using Events
  • Removing Boxes or Shaded Areas
  • Removing Section Formatting
  • Resizing a Section
  • Skipping a Section

Creating a Shaded Area

1. Drag the pointer to select the area in which you want to apply shading.
   If you are using this technique to shade a column of cells, drag the pointer and hold Alt to select the area that contains the column you want to shade.

2. On the Home tab, click Section, and then click the Boxes tab.

3. Click New box to design the parameters for the shaded area.
4. Type or select the left and right positions for the shading using the horizontal ruler as a guideline.
5. Type or select the vertical distance from the top of the section to the top of the shading.
6. Type or select the vertical distance from the bottom of the section to the bottom of the shading.
7. To draw an outline around the shaded area, in the Line thickness box, type or select the thickness of the line.
8. To outline all sides of the box, select the Top of box, Bottom of box, Left side and Right side check boxes.
9. Select a color in the Shading color box.

Related Topics

• About Sections