If you always open the same workbooks to do a task in Excel, consider creating a Workspace. First, save each open file. Then, with all workbooks open and arranged how you want them (tiled, horizontal/vertical windows, arranged in various window sizes), click the Save Workspace button in the Windows group of the view tab. Save the Workspace with a name you’ll associate with the task. A Workspace icon has a slightly different appearance than an Excel workbook. Keep in mind when you’re creating your Workspace that if you move the files, the Workspace won’t work correctly.
Get weekly updates on breaking news and business advice to help you advance your career! The week's top stories and resources will be sent right to your inbox. Choose the topics you're interested in:
We value your Privacy.