Checking Workbook Statistics

Excel keeps track of a wide range of statistics about your workbooks. These statistics include such mundane and obvious items as the file name, directory, and title. But you can also find out who last worked on the workbook, what keywords are associated with the workbook, and the total editing time spent on the workbook. (This last statistic is nothing more than the time the workbook has been open.)

If you want to view the statistics for the current workbook, follow these steps:

1. Click the Office button, then click Prepare, and finally Properties. Excel displays some of the properties just above the worksheet on the screen.
2. Click the Document Properties drop-down list and then choose Advanced Properties. Excel displays the workbook's Properties dialog box.
3. Click on the Statistics tab. The dialog box then displays the statistics for your workbook, as already described.
4. Click on the Summary tab to see other statistics for your workbook.
5. Click on OK when you are done reviewing the statistics.
6. Dismiss the properties above your worksheet by clicking the small X at the upper-right of the properties area.