如果您曾经在Excel中处理过多个工作簿，您就会知道，如果所有工作簿都在同一个Excel实例中打开，有时会导致问题。例如，如果您重新计算所有公式，它将对同一实例中的所有打开的工作簿执行此操作。
如果您不希望这种情况发生，或者您只是想在两个不同的窗口中并排查看两个电子表格，那么创建多个Excel实例是有意义的。您仍然可以在单个Excel(Excel)实例中拆分多个电子表格，但我发现它很麻烦且不直观。
Excel 的版本
在我们详细介绍之前，您应该确定您使用的是哪个版本的Excel 。如果您安装了 Office 2016 或Office 2013，则不必担心，因为每当您打开新工作簿时，它都会自动创建一个新的Excel实例。
只有在Office 2010及更早版本中，您才会遇到单个Excel 实例(Excel instance)问题。在本文中，我将提到让Excel在不同实例中打开不同工作簿的不同方法。
Excel 的多个实例
通常，您可以通过在Explorer中双击它们或从Excel中导航到它们来打开Excel电子表格。使用这两种方法中的任何一种都会导致电子表格在Excel的单个实例中打开。
方法 1 – 开始菜单
解决此问题的第一种方法是简单地打开“开始”菜单(Start Menu)，然后单击Excel 快捷方式(Excel shortcut)。这将自动打开一个新的Excel(Excel)实例。请注意，这适用于Windows 7、Windows 8 和Windows 10。
如果Excel 图标(Excel icon)没有出现在最常用的应用程序列表中，您可以转到所有程序(All Programs)或所有应用程序(All Apps)并从那里打开它。
方法 2 – 任务栏
如果您已经打开了一个 Excel 实例并且Excel图标(Excel icon)位于Windows 任务栏(Windows taskbar)上，您只需按住SHIFT 键(SHIFT key)，然后单击任务栏图标(taskbar icon)，它就会打开另一个实例。
请注意，您实际上并没有将Excel 图标(Excel icon)固定到任务栏。您需要做的就是打开一个Excel实例，以便它显示在任务栏中。到达那里后，您可以按住SHIFT，然后单击图标。
方法 3 – 中间按钮
如果您使用的是带有中键或可点击滚动按钮(scroll button)的鼠标，您也可以直接单击该按钮来获取新实例，而无需按住任何键。如果您还不知道，滚动按钮(scroll button)也可以像几乎每只鼠标上的按钮一样单击。
还值得注意的是，您也可以简单地右键单击任务栏中的Excel 图标(Excel icon)，然后单击Excel 20xx，它将打开一个新实例。
方法 4 – 运行命令
如果您的桌面、开始菜单和任务栏(Start Menu and taskbar)缺少Excel ，您仍然可以使用运行命令打开一个新的(Run command)Excel实例。只需单击(Just click)Start ，(Start)输入Run并按Enter。
现在只需在运行框中输入单词excel并单击OK。
这些几乎是我可以找到的打开多个Excel实例的所有方法。现在您已经在Excel的不同实例中打开了工作簿，您可以将它们捕捉到屏幕的不同部分。
幸运的是，我已经写过如何在Windows XP、7 和 8 中拆分屏幕，以及在Windows 10中新的(Windows 10)拆分屏幕和快照功能(split screen and snap features)。
同样，如果您使用的是Office 2013(Office 2013)或Office 2016 ，则无需担心任何这些，因为它们不再在单个Excel实例中打开多个工作簿。如果您一直坚持，这也可能是升级到更新版本的Office的一个很好的理由。(Office)如果您有任何问题，请随时发表评论。享受！
How to Open Multiple Instances of Excel
If you have ever worked with multiple workbooks in Excel, you know that it can sometimes cause issues if all of the workbooks arе opеn in the same instance of Excel. For examplе, if you reсalculate all formulas, it will do that for all open workbooks in the same instance.
If you don’t want that to happen or if you simply want to see both of your spreadsheets side by side in two different windows, then creating multiple instances of Excel makes sense. You can still split screen multiple spreadsheets within a single instance of Excel, but I find it cumbersome and not intuitive.
Versions of Excel
Before we get into details, you should determine which version of Excel you are using. If you have Office 2016 or Office 2013 installed, you don’t have to worry because whenever you open a new workbook, it automatically creates a new instance of Excel.
Only with Office 2010 and earlier do you have the single Excel instance issue. In this article, I’ll mention the different ways you can get Excel to open different workbooks in different instances.
Multiple Instances of Excel
Normally, you open Excel spreadsheets by either double-clicking on them in Explorer or by navigating to them from inside Excel. Using either of these two methods will result in the spreadsheets opening in a single instance of Excel.
Method 1 – Start Menu
The first way to get around this is to simply open the Start Menu and then click on the Excel shortcut. This will open a new instance of Excel automatically. Note that this will work in Windows 7, Windows 8 and Windows 10.
If the Excel icon doesn’t show up in the list of most used apps, you can just go to All Programs or All Apps and open it from there.
Method 2 – Taskbar
If you already have one instance of Excel open and the Excel icon is on your Windows taskbar, you can just press and hold the SHIFT key and then click on the taskbar icon and it’ll open another instance.
Note that you don’t have actually have the Excel icon pinned to your taskbar. All you need to do is open one instance of Excel so that it shows up in the taskbar. Once there, you can hold down SHIFT and then click on the icon.
Method 3 – Middle Button
If you are using a mouse with a middle button or clickable scroll button, you can also just click that button to get a new instance without having to hold down any key. If you didn’t already know, the scroll button can also be clicked like a button on pretty much every mouse.
It’s also worth noting that you can simply right-click on the Excel icon in the taskbar too and then click on Excel 20xx and it’ll open a new instance.
Method 4 – Run Command
If Excel is missing from your desktop, Start Menu and taskbar, then you can still open a new instance of Excel by using the Run command. Just click on Start, type in Run and press Enter.
Now just type in the word excel into the run box and click OK.
Those are pretty much all the ways I could find for opening multiple instances of Excel. Now that you have your workbooks open in different instances of Excel, you can snap them to different parts of the screen.
Luckily, I’ve already written about how you can split your screen in Windows XP, 7 and 8 and about the new split screen and snap features in Windows 10.
Again, you don’t need to worry about any of this if you are using Office 2013 or Office 2016 because they no longer open multiple workbooks in a single instance of Excel. It might also be a good reason to upgrade to a newer version of Office if you’ve been holding out. If you have any questions, feel free to comment. Enjoy!
