From the course: Excel: Macros in Depth (Microsoft 365)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Recording a simple macro
From the course: Excel: Macros in Depth (Microsoft 365)
Recording a simple macro
- [Instructor] We're looking at a workbook called Expand Code. And in addition to recording a macro here that's going to apply a certain kind of underlining feature we want to show how you can expand a macro by copying code from another macro. And we also want to use the macro here in the following movie, and introduce the idea of a programming like statement called the if statement, similar to the function in Excel. So, as we look at this file, take a look at the different kinds of underlining that we see in rows 14, 15, 17, and 18. Four different kinds, let's imagine that we like Double Accounting and we want to be able to get to it relatively quickly. Right now, if we approach this manually we've got some cells highlighted. How do we get to Double Accounting? We have to go to Format Cells. We could right click Format Cells or Press Ctrl + 1, either way. And we have to choose the font tab, if it's not already…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.