amansa.blogg.se

I'll record an auto-fill operation where I build a series of days based on typing Sunday in a cell.

Now, I see the DEVELOPER tab and here in the Code group are the Record Macro button and some other buttons I'll go over later. I click the FILE tab > Options > Customize Ribbon, and over here, I select Developer, and then click OK. That's where all of the macro commands are. Now before we get started, I want to make sure the DEVELOPER tab is available on the ribbon. If you are on a Windows RT PC, you'll see Microsoft Office 2013 RT here. To see what version of Office 2013 you are running, click FILE and then click Account. The macro recorder is the easiest way to create a new macro in Excel.Ī quick note: Macros aren't available in Office on a Windows RT PC. You want to automate a repetitive task in Excel, so that you can do the task again with a single click.