xlrd关闭excel文件_如何关闭所有Excel文件

xlrd关闭excel文件

In Excel 2013 and later versions, each file opens in a separate window. Unlike earlier single-window versions, there is no Exit button or command, to close all the files, without clicking each window individually.

在Excel 2013和更高版本中，每个文件在单独的窗口中打开。 与早期的单窗口版本不同，没有退出按钮或命令可以关闭所有文件，而无需单独单击每个窗口。

如何关闭所有Excel文件 (How to Close All Excel Files)

Even though the Exit command is missing, there are a few ways to close all open windows in Excel 2013 and later versions.

即使缺少“退出”命令，也有几种方法可以关闭Excel 2013及更高版本中的所有打开的窗口。

Use a workaround, or use one of the shortcuts shown below.

使用解决方法，或使用下面显示的快捷方式之一。

定制QAT (Customize the QAT)

The Quick Access Toolbar (QAT) is a great place to add commands that are missing or hard to get to.

快速访问工具栏(QAT)是添加缺少或难以获取的命令的好地方。

To add Close All and Exit commands, follow these steps:

若要添加全部关闭和退出命令，请按照下列步骤操作：

• Right-click the QAT, and click "Customize Quick Access Toolbar"
  右键单击“ QAT”，然后单击“自定义快速访问工具栏”
• From the "Choose Commands From" drop down list, select "All Commands"
  从“选择命令自”下拉列表中，选择“所有命令”
• Scroll down, and click on Close All.
  向下滚动，然后单击全部关闭。

• Click the Add button, to put that command on the  QAT.

  单击添加按钮，将该命令放在QAT上。

  NOTE: It will be added below the command that is selected in the list at the right.

  注意 ：它将添加到右侧列表中所选命令的下方。

• Scroll down to the Exit command, and add it to the QAT
  向下滚动到Exit命令，并将其添加到QAT
• Click OK, to close the Excel Options window.
  单击确定，关闭“ Excel选项”窗口。

使用QAT按钮 (Use the QAT Buttons)

After you add the Close All and Exit commands to the QAT, use those commands to close all Excel files.

将全部关闭和退出命令添加到QAT之后，使用这些命令关闭所有Excel文件。

• Close All – Closes all the Excel files, and leaves an empty window open

  全部关闭–关闭所有Excel文件，并打开一个空窗口

• Exit – Closes all the Excel files, and closes Excel

  退出 –关闭所有Excel文件，然后关闭Excel

Go to my Contextures site, for more tips on working with the QAT.

转到我的Contextures网站，以获取有关使用QAT的更多提示 。

Excel窗口“ X” (Excel Window "X")

Another way to close all Excel files is with the "X" at the top right of the Excel window.

关闭所有Excel文件的另一种方法是使用Excel窗口右上角的“ X”。

• If you simply click that "X", it will close the active window only.
  如果您仅单击该“ X”，它将仅关闭活动窗口。

• To close all Excel files, press the Shift key, and click the X

  要关闭所有Excel文件，请按Shift键，然后单击X

Excel will prompt you to save any unsaved files, and then all the windows will close.

Excel将提示您保存所有未保存的文件，然后所有窗口将关闭。

文件命令 (File Command)

Another way to close all Excel files is with this sequence of shortcut keys.

关闭所有Excel文件的另一种方法是使用此快捷键序列。

• Press the Alt key, and tap the F key, to activate the File tab.

  按Alt键，然后按F键以激活“文件”选项卡。

• Then, tap the X key, as a shortcut to Exit.
  然后，点击X键，作为退出的快捷方式。

NOT: Even though the X shortcut doesn't appear in the list, the Exit command runs when you tap X.

否：即使X快捷方式没有出现在列表中，当您点击X时，退出命令也会运行。

Windows任务栏 (Windows Taskbar)

Here's one more way to close all Excel files.

这是关闭所有Excel文件的另一种方法。

• Right-click the Excel icon in the Windows Taskbar, at the bottom of your screen.
  右键单击屏幕底部Windows任务栏中的Excel图标。
• Then click the Close All Windows command.
  然后单击“关闭所有Windows”命令。

NOTE: This only works if the Taskbar has "Always, hide labels" as the setting for "Combine taskbar buttons". (thanks J.Woolley)

注意 ：仅当任务栏具有“始终隐藏标签”作为“合并任务栏按钮”的设置时，此方法才有效。 (感谢J.Woolley)

To change that setting, right-click the Taskbar, and click Taskbar Settings.

若要更改该设置，请右键单击任务栏，然后单击“任务栏设置”。

更多Excel技巧 (More Excel Tips)

For more Excel file tips, go to the Excel Application and File FAQs page on my Contextures site.

有关更多Excel文件的提示，请转到Contextures网站上的“ Excel应用程序和文件常见问题解答”页面 。

视频：关闭所有Excel文件 (Video: Close All Excel Files)

Watch this video to see how to add the Close All and Exit buttons to the Quick Access Toolbar.

观看此视频，了解如何将“全部关闭”和“退出”按钮添加到快速访问工具栏。

演示地址

翻译自: https://contexturesblog.com/archives/2018/11/08/how-to-close-all-excel-files/

xlrd关闭excel文件