Microsoft Office Tutorials and References
In Depth Information
Opening Your Workbooks for Editing
files, and macro sheets). To display all the files, whether or not Excel can
open them directly (meaning without some sort of conversion), click the
drop-down button that appears next to the drop-down list box that currently
displays All Excel Files and then click All Files on its drop-down menu.
Figure 4-2:
Selecting
the
workbook file
to open for
editing in
Excel in
the Open
dialog box.
When the icon for the workbook file you want to work with appears in the
Open dialog box, you can then open it either by clicking its file icon and then
clicking the Open button or, if you’re handy with the mouse, by just
doubleclicking the file icon.
You can use the slider attached to the Change Your View drop-down list
button in the Open dialog box to change the way folder and file icons appear
in the dialog box. When you select Large Icons or Extra Large Icons on this
slider (or anywhere in between), the Excel workbook icons actually show a
preview of the data in the upper-left corner of the first worksheet when the file
is saved with the preview picture option turned on:
To enable the preview feature when saving workbooks in Excel 2013,
select the Save Thumbnail check box in the Save As dialog box before
saving the file for the first time.
To enable the preview feature when saving workbooks in Excel 97
through 2003, click the Save Preview Picture check box on the Summary
tab of the workbook’s Properties dialog box (File Properties) before
saving the file for the first time.
Search JabSto ::




Custom Search