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.

Saving a Workbook with a Preview

by Allen Wyatt
(last updated December 10, 2016)

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:

  1. Choose Properties from the File menu. Excel displays the Properties dialog box for your workbook.
  2. Make sure the Summary tab is selected. (See Figure 1.)
  3. Figure 1. The Summary tab of the Properties dialog box.

  4. Select the Save Preview Picture check box at the bottom of the dialog box.
  5. Click on OK to close the Properties dialog box.
  6. Click the Save tool on the toolbar, or choose Save from the File menu.

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.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Noting Inactivity within a Timeframe

There are many times when you are creating a worksheet that you need to analyze dates within that worksheet. Once such ...

Discover More

Controlling Automatic Capitalization

When you start typing, do you ever notice those times that Word starts capitalizing words at the start of what it thinks are ...

Discover More

Configuring Spell Check for Internet Addresses

When writing technical documents, URLs are a common thing to include in your text. Normally Word will mark these as ...

Discover More

Professional Development Guidance! Four world-class developers offer start-to-finish guidance for building powerful, robust, and secure applications with Excel. The authors show how to consistently make the right design decisions and make the most of Excel's powerful features. Check out Professional Excel Development today!

MORE EXCELTIPS (MENU)

Avoiding Scientific Notation on File Imports

When importing information from a CSV file, you may get unintended results from time to time. Here's how to force Excel to ...

Discover More

Finding the Size of a Workbook

Keeping tabs on the size of a workbook can be important when using Excel. You have a couple of options that will allow you to ...

Discover More

Merging Many Workbooks

If you need to combine the contents of a bunch of workbooks into a single workbook, the process can get tedious. Here's a ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments for this tip:

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)

This Site

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.

Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.

Links and Sharing
Share