This tip was printed from the Tips for Spreadsheets website at http://tipsforspreadsheets.com/.

Microsoft Excel 2003 Visual Tweaks - Toggle Display of Row and Column Headers

Normally, when you open a spreadsheet in Microsoft Excel 2003, each row is numbered and each column has a header on top, such as "A", "B", "C", etc. If these are not displayed on your spreadsheet and you wish to turn them on, or if you wish to turn these headings off to display an extra row and column of data onscreen, do the following:

1. Click "Tools" - "Options".
2. When the "Options" multi-tabbed dialog box appears, click the "View" tab.
3. Under "Window Options", check or uncheck "Row & column headers" as desired.
4. Click "OK" to close the dialog box.



Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 Visual Tweaks - Toggle Display of Row and Column Headers.
 
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.