Written by Allen Wyatt (last updated June 15, 2021)
This tip applies to Excel 97, 2000, 2002, and 2003
When you use the Open dialog box in Excel, you can configure what you see in the dialog box. One of the settings you can make is for Excel to display a preview of whatever workbook you select in the left side of the dialog box. (Click on the drop-down arrow next to the Views tool, then choose Preview.)
You may have already noticed that some of your workbooks do not have a preview available in the Open dialog box. If this is the case, and you want to have a preview available, you need to make sure that the workbook is saved with the preview enabled. If the workbook is loaded in Excel, follow these general steps:
Figure 1. The Summary tab of the Properties dialog box.
At this point you can close the workbook. Now when you display the Open dialog box, and you have the preview feature turned on, the workbook displays a preview in the dialog box.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3351) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Saving a Workbook with a Preview.
Excel Smarts for Beginners! Featuring the friendly and trusted For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. Check out Excel 2019 For Dummies today!
If you need to change the same data in a large number of workbooks, the task can be daunting. Here are some ideas (and ...
Discover MoreWorkbooks can get rather large rather quickly. If you think your workbook has gotten too big too fast, here are some ...
Discover MoreIf you need to combine the contents of a bunch of workbooks into a single workbook, the process can get tedious. Here's a ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments