How to Put Titles in the Gray Area Box of Microsoft Excel

In Microsoft Excel, there are three types of headers: sheet headers, column headers, and group headers. Sheet headers, inserted using the toolbar, apply to the whole document; column headers appear in row 1 of each column, and group headers appear in row 1 of the group. If you want to add a header in the group, you can't just add a row above the group: that results in adding another row to the group.

Things You'll Need

• Excel 2010

Instructions

1. Click anywhere on the spreadsheet. A gray box will appear to the left of the group line.

2. Right-click the gray box.

3. Click the check box for "Include Group Header."

4. Click "OK."

Tips & Warnings

• If you want to have the group header show on multiple pages, click the "Repeat Group Header" box before you click "OK" in Step 4.

References

• Excel 2010: Product Guide
• Microsoft: Group Header