Page 36 - Excel Timesaving Techniques for Dummies

04_574272 ch03.qxd 10/1/04 10:21 PM Page 21
Unfortunately, Excel doesn’t provide a Browse Opening a Workspace Whenever Excel Launches 21
button here that enables you to locate this folder
visually, so you have to tough it out and type the
folder’s pathname in this text box. Remember
that the pathname consists of the drive letter
followed by a colon and the names of all the
subfolders separated by backslashes, as in
C:\XL Alt Start shown in Figure 3-2.
3. Click OK to close the Options dialog box.

• Figure 3-3: Saving the workspace file in the alternate
startup folder in the Save Workspace
dialog box.

3. Click Save to close the Save Workspace dialog
box.

After you save the workspace file in your Excel alter-
nate startup folder, each time you start Excel the
program opens the file and uses its information to
load your workbook files, arrange their windows,
and invoke their display settings.
• Figure 3-2: Designating the alternate startup folder in the When you finish your work with the workbooks
Options dialog box. opened in the workspace and no longer want to
see them every time you launch Excel, you need
After you designate your alternate startup folder, to move the workspace file out of the alternate
follow these steps to save the workspace file that startup folder into another folder on your hard
you want Excel to automatically open on startup: disk, or, if you’re really sure that you have no need
for the workspace, you can delete it by moving it
1. Choose File➪Save Workspace to open the Save into the Windows Recycle Bin.
Workspace dialog box.
2. From the Save In drop-down list box, select the
folder you designated as the alternate startup
folder, as shown in Figure 3-3.