How to record macros in Google Sheets

Introducing G Suite Pro Tips, quick tutorial videos to help you automate simple tasks at work. In this video, a G Suite Developer Advocate explains how to record macros in Google Sheets with Macro Recorder, a tool that lets you record time-consuming actions in Sheets and play them back.

#GoogleWorkspaceProTips
#CustomizingGoogleWorkspace

[adriennemccue]

I'm loving this new way to do the videos. Smart!

[bradcodd]

This is next level magic. We truly live in the Matrix!

[minilobo]

Love the "[LINK to blog here - use shortlink]" part :)

[amycgx]

I've been using macros for years and they're a lifesaver, but today something came up that I can't resolve. The "record macro" window pops up over the top of what I need to do and I can't get either dialogue box to move to be able to make my sheet edits while recording. I'm specifically trying to use the "split text to columns" action, but regardless of my window size, the box where I would normally input my custom splitter is behind the record macro button. Any tips would be much appreciated!

[tanyarathore]

Hi.. can you tell me how to create a macro that selects a range of cells in a workbook and then goes to the file menu and gives a print command using google sheets?

[rakeshbond]

I am not getting the option of Macro in my Google Sheets

[joesb]

i am using macros in google sheets but my macro has to copy data from an excel file on my computer to that in google sheets is that possible

[j.zhanng]

I have a long formula to enter, can I copy/paste or do I have to type it all out? Risk of copy/paste from another sheet I will need to create that sheet each time?

[charbelsleimane]

I need the maco recording to copy the selected cell and past it in the following sheet, in Excel for instance a macro recording copy the selected cell from 1 sheet to another would every time start from difference cells depends where it is selected, however in google sheets it is always copying the same cell where the macro was recorded, how can i solve this problem? thank you

[amo]

I have a google sheets spreadsheet with 172 email addresses. I want to set up a macro to copy all the emails. Then use that macro to past them into an email. Can this be done

[DanielGallegos]

this is awesome! going to save me so much time!

[johnvelella]

Can I make a macro that works with clicks outside of the sheet but still in the drive. An example would be have it create a new folder in the drive when I run the macro and automatically have the folder named per a certain cell?

[CesarPeron]

Good one....I'm trying to use to put a formula into a cell but don't work!

[NileshKantak]

wow that's good to save time and making better then ever love to do that.

[juanpablovidal]

hi Joanna where can find videos like that but in spanish. thanks

[shivamgoyal]

Can I use the same macro for different sheets?

[sankarasaichaithanyarayudu]

Can you explain clearly about something that is said on "collaboration"?

[ecotechagave]

<3 <3 thank you guys, great video!

[HashimWarren]

"your macro will not block my edits" But what does a person who is editing see if the macro is run while she's working?

[hyunbinseo]

He is using a Chromebook. Some-how the Chrome screen capture is all Mac.