From the course: Google Sheets: Advanced Topics

Unlock this course with a free trial

Join today to access over 25,200 courses taught by industry experts.

Macros

Macros - Google Sheets Tutorial

From the course: Google Sheets: Advanced Topics

Start my 1-month free trial Buy for my team

Macros

“

Macros in Google Sheets allow you to automate repetitive tasks? A macro is simply a series of steps that can be applied to a sheet and its contents with a click saving time and ensuring accuracy. For example, specific formatting can be applied to a data set to highlight results by changing the header row text to bold, alternating colors for the rows, and making the sums of several columns display in red or green text subject to conditional formatting rules. To create a new macro, open a spreadsheet. The sheet doesn't have to contain data, but the macro is specific to the spreadsheet, so data will have to be entered or copied to it before the macro that is created can be applied. Open the extensions menu. Hover over macros and click record macro. The macro recording panel will open at the bottom of the sheet. Each action will now be saved to the macro for playback later. Before completing an action, choose between absolute and relative references. As you may remember from earlier in…

Contents