Page 279 - Excel 2013 All-in-One For Dummies

Working with Multiple Workbooks 261
information about the open workbooks, including the window arrangement, magnification settings, and display settings. (The workspace file also saves the print areas defined in the open workbooks — see Book II, Chapter 5, for information on printing.)
Workspace files contain only such information about the open workbooks, not the actual workbook files. Therefore, you can’t send a workspace file to a co-worker and expect him or her to be able to successfully open the file without also sending the associated workbook files.
To save a workspace, you take the following steps:
1. Open all the workbooks you want opened when you open the work- space file.
2. Arrange the windows for these workbooks as you want them to appear when you first open the workspace file.
To arrange the windows, click the Arrange All button on the View tab and then select the type of arrangement in the Arrange Windows dialog box. (Be sure that the Windows of Active Workbook check box is not selected.)
3. Select any display settings and magnification settings that you want used in the individual workbook windows when you first open the workspace file.
To change the display settings for a workbook, activate its window
and then change the settings on the Advanced tab of the Excel Options dialog box (Alt+FTA). To change the magnification, use the Zoom slider on the status bar.
4. Click the Save Workspace command button on the View tab of the Ribbon or press Alt+WK.
Doing this opens the Save Workspace dialog box, which is just like the Save As dialog box, except that Workspaces (*.xlw) is selected as the default file type in the Save as Type combo box.
5. Select the folder in which you want the workspace file saved in the Save In drop-down list box and then edit the desired filename in the File Name combo box.
If you want the workspace file to open automatically each time you start Excel, save the file in the XLStart folder in your Office 15 folder. This folder is located within the Microsoft Office folder, inside the Programs Folder on your hard drive (usually the C: drive).
6. Click the Save button to save the workspace and to close the Save Workspace dialog box.
Book II Chapter 4
Managing Worksheets