cómo crear un espacio de trabajo en MS Excel y sus beneficios?
Let’s consider that in your day to day activities on reporting you need to open multiple excel spreadsheets available in different locations to compile data at one report file. So every day while starting, you need to take the pain of opening these files from different location and then start your work.
To avoid the repetition of opening multiple files from multiple location; you can create a workspace file (*.xlw) and save it at a known location. So every day when you open this file you will get all your desired files opened at one place and at the same position where you want them to be available for your report creation.
To create the workspace file you need to open all your files and keep them in the way you want to get this open every day. Go to the View tab. There you click “Save Workspace” option. This will provide you the dialog box of saving the *.xlw file at your desired location.
Post that whenever you want to open these files together you can directly click the *.xlw file and this will allow you to get all the spreadsheets which you want to open to accomplish your work.
For more information on how to do this, please get in touch with me at Samrat.biswaas@gmail.com.
Friends, Now Excel in MS Excel is available in Facebook as well. You can quickly raise your MS Excel related queries in its platform. I will try to resolve them.
Visit Other MS Excel Tips and Tricks
Samrat Biswas, Six Sigma (Green Belt), MOS Excel Expert 2013, ITIL 2011 Foundation
Advanced MS Office (Excel, Word, PowerPoint, One Note, Outlook), and MS Visio
---------------------------------------------------------------------------------------------------------
Be a part of regular Weekend Knowledge Sharing Sessions
Reach me @ +91 8095039316/ +91 8095039315
https://www.facebook.com/Samrat.Biswas
