快速打开一组Excel文件

Do you have a few Excel files that you usually have open all at the same time? Maybe the files are linked, and you update one and check the results in the other file. Or maybe there are a few files that you open first thing every morning, to enter or update the data.

您是否有一些通常同时打开的Excel文件？ 也许文件已链接，然后您更新其中一个文件并在另一个文件中检查结果。 也许每天早上您首先打开一些文件以输入或更新数据。

After you open the files, you might spend a minute or two arranging the files so you can see everything as you work. Then you make the changes, close everything, and do the same thing again tomorrow.

打开文件后，您可能需要花一两分钟来整理文件，以便在工作时可以看到所有内容。 然后，您进行更改，关闭所有内容，然后明天再次执行相同的操作。

通过工作区节省时间 (Save Time With a Workspace)

To save time, you can use Excel's Save Workspace feature. It remembers which files are open, how you have them arranged, and where the files are located.

为了节省时间，您可以使用Excel的“保存工作区”功能。 它会记住哪些文件是打开的，它们的排列方式以及文件的位置。

The Workspace file doesn't contain the files themselves. You'll still be able to open the files individually, and use the Workspace file when you want to open them together.

工作区文件不包含文件本身。 您仍然可以单独打开文件，并在想要一起打开它们时使用Workspace文件。

准备文件 (Prepare the Files)

1. Open all the files that you want to use.
   打开所有要使用的文件。
2. Arrange the files any way you'd like (Tiled, Vertical, etc.)
   任意排列文件(平铺，垂直等)

创建工作区文件 (Create a Workspace File)

In Excel 2007 / 2010, click Save Workspace, on the Ribbon's View tab.

在Excel 2007/2010中，在功能区的“视图”选项卡上单击“保存工作区”。

In Excel 2003, click the File menu, then click Save Workspace.

在Excel 2003中，单击“文件”菜单，然后单击“保存工作区”。

Type a name for the Workspace file, and click OK. The xlw extension will be automatically added to the file name.

键入工作区文件的名称，然后单击“确定”。 xlw扩展名将自动添加到文件名中。

关闭工作区文件 (Close a Workspace File)

In Excel 2003, hold the Shift key, click the File menu, and click Close All. In Excel 2007, close each file individually, or add the Close All command to the Quick Access Toolbar.

在Excel 2003中，按住Shift键，单击“文件”菜单，然后单击“全部关闭”。 在Excel 2007中，单独关闭每个文件，或将“全部关闭”命令添加到快速访问工具栏。

Or, to close all the files, and Excel, hold the Shift key, and click the X at the top right of the Excel window.

或者，要关闭所有文件和Excel，请按住Shift键，然后单击Excel窗口右上角的X。

打开工作区文件 (Open a Workspace File)

Open a Workspace File, just as you would open any other Excel File. Click the Open button, select the Workspace file, and click Open. __________________

打开工作区文件，就像打开任何其他Excel文件一样。 单击“打开”按钮，选择“工作区”文件，然后单击“打开”。 __________________

翻译自: https://contexturesblog.com/archives/2009/02/12/quickly-open-a-set-of-excel-files/