Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Saving a Workbook with a Preview.
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.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!
You can use Excel for all types of data processing. You may want to work with filenames in a worksheet, but the first ...
Discover MoreIf you've got some older data around your office that started in an old Lotus 1-2-3 system, you may want to open it in ...
Discover MoreWorkbooks can get rather large rather quickly. If you think your workbook has gotten too big too fast, here are some ...
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 © 2024 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here:
Comments