From the course: Excel 2010 Essential Training

Unlock the full course today

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

Recording and using a simple macro

Recording and using a simple macro - Microsoft Excel Tutorial

From the course: Excel 2010 Essential Training

Start my 1-month free trial

Recording and using a simple macro

We're going to record a basic macro that take cells from one worksheet and deposits them at the bottom of this worksheet. Now because this is an Essential Training course we're only giving light coverage to macros. If you're interested in learning about macros in depth, check out some of the really great macro courses in the lynda.com library. But before we begin recording there is some housekeeping that we need to do first. To record macros we need to display the Developer tab on the Ribbon bar. Now on my computer here, you see there is no Developer tab. If you have the Developer tab on your computer you don't have to go through this step. But I am going to go here to the File tab to go to Backstage View, and down over here let's click Options and we have all the Options categories here on the left and let's click over here where it says Customize Ribbon. Now on the right, we have a list of all the tabs that are visible, Home, Insert, Page Layout and so on, and over here is the…

Contents