Making Column Headers Vertically Wider

Robert notes that his version of Excel (2007) has a very narrow column header line (A, B, C, etc.). It is very difficult for him to even click within the column header. He can expand the height of regular rows, but wonders how he can expand the height of the header row.

There are a number of things to check. The height of the header row is determined automatically by Excel, based on the size of the font used in the program. Thus, you may be able to increase the header size by changing the default font used in Excel. Try these steps in Excel 2007:

1. Click the Office button and then click Excel Options. Excel displays the Excel Options dialog box; the Popular option should be selected at the left of the dialog box. (Click here to see a related figure.)
2. Using the Font Size drop-down list, choose a different size font for the program to use.
3. Click OK. Excel informs you that for your change to take effect you need to restart the program.
4. Restart Excel.

If Excel is not the only program in which you have problems seeing small information, you might check out your settings in Windows itself. Check to see if display configuration for your system has been changed so that small fonts are used in dialog boxes and for screen fonts. It may take some experimentation, but you might find that all your programs are easier to use after some changes.