From the course: Excel 2016 Essential Training

Unlock the full course today

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

Creating a simple macro

Creating a simple macro

From the course: Excel 2016 Essential Training

Start my 1-month free trial

Creating a simple macro

“

- After identifying the steps that you would like to record and turn into a macro, it's time to begin that process. We've got the file open, 15 - Macros, we're on the H.R. list. Let's imagine we want to record a macro that applies a particular set of formatting features. Click a cell. It's your job to indicate which of these cells needs to have some editing done to them and you simply want to apply a format. We'll go to the Home tab here. Click the drop arrow for the Fill Color bucket. Maybe choose an orange-like color there, maybe a different colored font too. Now admittedly, what I'm doing is a bit of overkill. I'm applying multiple features: I'll apply bold, italic... maybe get one of the Border features out here, the Thick Box Border or maybe one of the others. Maybe that one. That's probably enough for now. For whatever reason, I like that. That's the set of steps that I want to use, and I want to use it frequently. Sure, I could copy the format, but I want it available all the…

Contents