Macros in Google Sheets

A major sticking point with moving from Excel to Google Sheets was the lack of ability to use macros. A macro will let you automate calculations and other aspects in sheets. For instance, if you regularly tally up marks, allocate a grade and then draw a graph or chart of the results for your class, then you can create a macro to do this for you. Google Sheets now have the capacity to write and run your own macros. This will improve your efficiency and save you time.

Google Sheets now have the capacity to write and run your own macros Click To Tweet

It is simple to build your first macro and save it in a Google Sheet. The great thing about macros in Google Sheets is that they are accessible whenever you use the sheet as they are cloud-based. They are written using Google Apps Script, but you don’t need to understand how to program using this code because you can record a macro within a Google Sheet. Unfortunately, you are unable to import macros from Excel at this stage as they use VBA as the code to make them run.

To build your first macro, follow these easy steps:

1. Create, or open an existing Google Sheet that has some data in it. For example, you may have a mark book with some marks in it.

2. Decide on what action you want to carry out, in the example here I want to convert the raw mark to a percentage.

3. Click on the Tools tab.

4. Click on Record macro

The macro window will now open and indicate that you are now recording a macro.

Complete the calculations and formatting that you want to have in the sheet.

5. When finished, click on save and name the macro.

Running the macro is just as easy:

1. Click on Tools
2. Choose macro
3. Click on the macro you have just written.

From here, you can also edit the macro by editing the underlying Google Apps Script:
1. Click on Manage macros.

2. Click on the three dots.

The apps script looks like this and you can edit it directly.

This macro will stay with this sheet. If you wish to use it in another sheet, you can download the script and then install it in another sheet.

Macros make your spreadsheet life more efficient and are now included in Google Sheets. Watch this video to see how easy it is to create a macro in a Google Sheet Click To Tweet

Macros make your spreadsheet life more efficient and are now included in Google Sheets. Watch this video to see how easy it is to create a macro in a Google Sheet.


Customise your Chrome Omnibox for efficient searching

Don’t you just love being able to search Google straight from in the Chrome Omnibox? But did you know you can customise this to make searching in your Inbox, YouTube or Google Drive super easy? Actually, anywhere that you can search can be turned into a search engine right there in your Omnibox, and it’s a fast and easy process to set it up.

VIEW POST

One Of My Favourite Quotes

  You could be standing in the midst of greatness… One of my favourite quotes is: Individuals from this generation will surface as leaders in every field.  During this lifetime the future will be shaped by someone – no one knows who it is going to be – so you

VIEW POST
Outclassed Podcast

Fake News and Getting Google Search to Work For You Ep 27

Get Notified Of Future Episodes: Apple Podcasts | Spotify | Google Podcast | Stitcher | TuneIn + Alex | Podcast Addict | Podchaser | Deezer | Listen Notes In this Episode: To see all the OutClassed episodes go to utb.fyi/outclassed Podcast Episode Highlights: Coming Resources and links mentioned: Transcript: Mike

VIEW POST

Here’s What
Our Clients Say

PR Industrya

Client

In 2018, Using Technology Better designed and delivered a two phase post-migration training program for this New Zealand based graphic design firm. The initial goal of the training program was to reduce frustration with G Suite, with the long term aim of facilitating a change in culture and collaboration that can lead to transformative practices

Download your skills checklist to see how you score...

 

Sign Up Now
To Get The Latest Updates

 

Holiday Rescue Maker Camp

Student to agree to and tick:
Guardian to agree to and tick: