Save As Workspace
Many times we will find ourselves working with more than one Excel workbook at the same time, and each of these windows are occupying their own separate window. We also know that we will be working with these workbooks for a long period of time, which means that we will have to open these workbooks one by one each time. Process time-consuming and annoying!!!
So what do we do? We save these workbooks as a Workspace.
Once we have saved them as a Workspace, each time that we will be opening the specific file, all the workbooks will appear according to the layout that we had defined.
First of all we must open the workbooks that we are going to use (in my example I will be using three different workbooks).
Once we have opened them, we must arrange them in our screen, so that they all appear at once. In order for us to do that we must select the View tab and from the area of the ribbon named Window, we must select the command Arrange All as shown in the image below.
Once the command is selected the Arrange Windows dialog box appears, where we select the layout of our workbooks to appear and press the OK button. In my example I have selected to arrange the workbooks Horizontal.
In the image below we can see all three workbooks arranged horizontally.
Once we have arranged our windows on our screen, we select again the View tab and from the area of the window named Window we select the command Save Workspace as shown in the image below.
The Save Workspace window appears where we much define the location and name of the file. We notice that the extension of the Workspace file is .xlw (Excel Workspace)
Once we have defined the location and the name of the file we press the Save button. The next time that we will open the saved Workspace, all three workbooks will appear at once according to the layout that we had defined.
In the image below we can see the icon of the Workspace, which is different from the Excel file.
Posted on March 7, 2012, in Excel 2010 English, Microsoft Office 2010 English and tagged Arrange All, Excel 2010 Greek, Office Smart, Save Workspace, xlw. Bookmark the permalink. Comments Off on Save As Workspace.