Better Use of Heading Space

You have probably noticed that column headings (the ones you enter) are often wider than the data in the column. This means that the printout may be wider than necessary, or even wider than what can fit on a single piece of paper.

One way to solve this is to change the orientation of your headings, so they are sideways. The following steps will do the trick:

1. Select the cells containing the column headings you wish to change.
2. Select Cells from the Format menu.
3. Click on the Alignment tab.
4. If you are using Excel 95, select one of the vertical orientations for your text using those offered in the Orientation area.
5. If you are using Excel 97 or a later version, use the Orientation section to specify the angle (in degrees) at which the headings should be turned.
6. Click on OK. Your headings are turned as you directed.
7. Format your columns to so their width is better suited to the new text orientation.