If you want to run the macro, click the Run button. Our macro, Example, is now shown in the list. To make sure your macro recorded or to access your macro, go to the Developer tab again. Click the Macros button. Record your macro, then press Stop Recording. That said, it's important that you take your time. Excel does not record the time it takes for you to enter your macro though. Take your time when you record your macro. If you make a mistake, even if you undo it, Excel records that mistake. Now, you can start recording your macro by performing the actions we listed. You can click either one of these things to stop recording your macro. To the right of the word Ready, you will see a white square that looks like a Stop button on a tape recorder. If you look at the ribbon under the Developer tab, you can see that it says Stop Recording where the Record Macro button was before you clicked it. When you click OK, the recorder starts to run. Next, enter a description for your macro. If you send the workbook via email to someone else, the macros will be there for them to use. This Workbook stores the macro with your current workbook. Personal Macro Workbook stores the macro with your machine. Out of these three choices, there are only two that you need. In Store Macro In, you have three choices. We aren't going to fill that in right this second. Instead, let's move on to the next field. Next, we can tell Excel what keyboard shortcut to use. You can name your macro anything you want however, the name cannot contain spaces. You will then see the Record Macro dialogue box.įirst, give your macro a name in the Macro Name field. To record a macro, you can go to the Developer tab and click Record Macro, or you can go to the bottom of your worksheet and click the button to the right of the word Ready. It looks like this: This is important. You record a macro. Just as with anything you record, you must tell it to stop. Notice that #5 is telling the macro to stop. We are going to create a macro that selects sell A1, enters our name into it, makes the font italic and increases the size to 14, then uses autofit to determine the column size. In the worksheet below, we've simply listed the tasks that we want our macro to perform.
#HOW TO USE MICROSOFT EXCEL 2013 HOW TO#
The best way to teach you how to create and run a macro is to walk you through it step by step. Use absolute or relative references in macros Set the security settings for a workbook with macros In this article, we're going to explore macros in Excel 2013, including how to: However, instead of taking multiple steps to give Excel those instructions, you only take one. Macros are stored in Excel and can be restored to use again and again. When you use a macro, you are giving Excel instructions for what you want it to do.
#HOW TO USE MICROSOFT EXCEL 2013 SERIES#
A macro is a series of instructions or commands that can be triggered by a keyboard shortcut, button in the toolbar, or by an icon that you can stick in a worksheet.
0 kommentar(er)
