Switching to Sheets from Microsoft Excel

5. Use macros and add-ons

In this section:

5.1 Automate tasks with macros
5.2 Do more with add-ons

5.1 Automate tasks with macros

" "

Excel: 
Individual messages

Sheets: 
Macros and Google Apps Script

Use macros in a message in 2013 version

Excel 2013 and 2010

Automate repetitive tasks with macros in Sheets. Or, if you need custom functions, menus, or windows, you can create them with Google Apps Script.

Record a macro:

  1. In Sheets, open a spreadsheet and click Toolsand thenMacrosand thenRecord macro.
  2. Select the type of cell reference to use.
  3. Complete the task you want to record and click Save.
  4. Name the macro and click Save.
  5. Click Toolsand thenMacrosand thenyour macro to run the macro.
Find the "Record macro" option  in a sheet by clicking "Macros" under "Tools"


Create a script:

  1. Click Toolsand thenScript editor.
  2. Create your script.

For more information, see Overview of Google Apps Script.

5.2 Do more with add-ons

" "

Excel:
Add-Ins

Sheets:
Add-ons

Add-ins in 2013 version

Excel 2013
 

Add-ins from 2010 version

Excel 2010

Use ready-made add-ons to do more with Sheets. Here’s a few things you
can do:

Download add-ons:

  1. Click Add-onsand thenGet add-ons.
  2. (Optional) To see a description of the add-on, point to it or click it for a full description.
  3. Click the add-on you want to install and click Free.
  4. If needed, review the access message and click Allow.

Get add-ons

Was this helpful?
How can we improve it?