From the course: Excel 2013 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Creating a simple macro

Creating a simple macro - Microsoft Excel Tutorial

From the course: Excel 2013 Essential Training

Start my 1-month free trial

Creating a simple macro

After you have identified a certain sequence of actions that you would like to automate in the form of a Macro, it's time to learn how to actually record a Macro. The process has begun already because you've either written down or you know those steps you want to take. For example, we've decided that it's really handy to be able to click on a cell here and when it's questionable, we want to apply a special format. A format that might include using some of the features on the HOME tab like a background of yellow, a red font and a few other features as well, we don't want to go through those steps manually each time. So, the process of recording a macro also begins with this thought. Is the macro we are about to record, designed only for this workbook or might we want to use it elsewhere? Let's imagine for the moment that we're only going to use this macro in the current workbook. A bit later we might change our minds about that. It is something we need to think about though because…

Contents