Tips, Tricks, and Answers

The following articles are available. Click the article's title (shown in bold) to see the associated article.

Saving a Workbook Thumbnail. When you save your workbooks, Excel can also save a preview image (thumbnail) that can be displayed in the Open dialog box. Here's how to configure Excel to save that preview.

Sorting Files when Opening Workbooks. When opening a workbook from within Excel, it can be helpful to have the workbooks available in a folder be sorted. This tip shows how easy it is to get those workbooks in the desired order.

Specifying Where Excel Saves AutoRecover Files. Excel, by default, periodically writes information to AutoRecover files that can help protect your data in case Excel is ended abnormally. You can specify where you want these AutoRecover files stored by using the information in this tip.

Unwanted Files Loading when Starting Excel. Imagine how painful it would be if every time you started Excel it tried to load all the files in your root directory? That is what was happening to Stephen, and here's how to fix it.