We have a set of data where department headcounts are displayed by month.
To make the report more attractive, we begin by centering the heading between columns A and G. This is accomplished by selecting the cells you wish to center across (A1 through G1) and press the Merged & Center button.
Resizing Multiple Columns
If you wish to tighten up the space used by the monthly columns (B through G), select the column headings for columns B through G, then double-click one of the highlighted column heading dividers (remember Auto Fit?).
If this is too tight, you can manually expand one of the selected column heading dividers and manually resize to the desired width. This new size will be applied to all selected columns, providing a professional, uniformed look.
Adding Colors and Borders
With the Month cells selected, we can apply any traditional cosmetic changes to the cells, like font style, font size, font color, alignment, etc.
We can also add borders and fill colors to the cells using the Borders and Fill Color features.