谷歌表格_如何使用宏自动执行Google表格

谷歌表格

Google Sheets lets you automate repetitive tasks with macros, and you can then bind them to keyboard shortcuts to execute them quickly. They work using Google Apps Script to capture your actions for later use.

Google表格可以让您使用宏自动执行重复性任务，然后可以将其绑定到键盘快捷键以快速执行它们。 他们使用Google Apps脚本来捕获您的操作以供以后使用。

什么是宏？ (What are Macros?)

A macro—or macroinstruction—is a specific sequence of actions that let you automate a series of steps to increase productivity. They work by recording your actions and saving them into a file that’s bound to the spreadsheet in which they were recorded.

宏(或宏指令)是特定的操作序列，可让您自动化一系列步骤以提高生产率。 它们的工作方式是记录您的操作并将其保存到与记录了这些操作的电子表格绑定的文件中。

When you record a macro in Google Sheets, it automatically creates an Apps Script with all the code to replicate your actions for you. This means you can create complex macros without knowing how to write code. The next time you run it, Sheets will do everything you did when you recorded the macro. Essentially, you’re teaching Google Sheets how to manipulate a document to your liking with a single command.

当您在Google表格中记录宏时，它会自动创建一个包含所有代码的Apps脚本，以为您复制操作。 这意味着您可以在不知道如何编写代码的情况下创建复杂的宏。 下次运行它时，Sheets将完成您在录制宏时所做的所有操作。 本质上，您是在教Google表格如何通过单个命令来按自己的喜好操纵文档。

Macros are a powerful feature that can do basically anything Sheets is capable of doing. Here are just a few examples of its functionality:

宏是一项强大的功能，基本上可以完成Sheets能够执行的任何操作。 以下是其功能的一些示例：

• Apply formatting and styles.
  应用格式和样式。
• Create completely new spreadsheets.
  创建全新的电子表格。
• Use any Google Sheets function, toolbar, menu, or feature.
  使用任何Google表格功能，工具栏，菜单或功能。

The sky is the limit.

天空才是极限。

如何在Google表格中记录宏 (How to Record a Macro in Google Sheets)

Fire up a Google Sheet