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.

01

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.

02

In the image below we can see all three workbooks arranged horizontally.

06

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.

03

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)

05

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.

07

About officesmart

MVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system

Posted on March 7, 2012, in Excel 2010 English, Microsoft Office 2010 English and tagged , , , , . Bookmark the permalink. Comments Off on Save As Workspace.

Comments are closed.