Excel adds both a New Tab (Custom) and New Group (Custom) item to the Main Tabs list while at the same time selecting the New Group (Custom) item.

Excel 2019 enables you to add an optional Developer tab to the Ribbon that contains its own Record Macro command button (among other command buttons that are very useful when doing more advanced work with macros).

To add the Developer tab to the Excel 2019 Ribbon, follow these two steps.

This means that mistakes that you make while taking an action that you rectify wont be recorded as part of the macro; for example, if you make a typing error and then edit it while the macro recorder is on, only the corrected entry shows up in the macro without the original mistakes and steps taken to remedy them.

When you record an Excel macro as part of your Personal Macro Workbook, you can run that macro from any workbook that you have open.

This is because the PERSONAL.XLSB workbook is secretly opened whenever you launch Excel, and although it remains hidden, its macros are always available.) When you record macros as part of the current workbook or a new workbook, you can run those macros only when the workbook in which they were recorded is open in Excel.

When assigning a name for your macro, use the same guidelines that you use when you assign a standard range name to a cell range in your worksheet.

When assigning a shortcut keystroke to run the macro, you can assign.

If youre building a macro that needs to be in a particular cell when its steps are played back, put the cell pointer in that cell.

The Record Macro dialog box opens where you enter the macro name, define any keystroke shortcut, select the workbook in which to store the macro, and enter a description of the macros function.

For this example macro, you replace Macro1 in the Macro Name text box with the name CompanyName.

Just remember that Excel has already assigned a number of Ctrlletter keystroke shortcuts for doing common tasks, such as CtrlC for copying an item to the Clipboard and CtrlV for pasting an item from the Clipboard into the worksheet (see the Cheat Sheet for a complete list).

If you assign the same keystrokes to the macro youre building, your macros shortcut keys override and, therefore, disable Excels ready-made shortcut keystrokes.

Select Personal Macro Workbook on the Store Macro In drop-down list box to be able to run the macro anytime you like.

Select This Workbook (the default) when you need to run the macro only when the current workbook is open.

Select New Workbook if you want to open a new workbook in which to record and save the new macro.

Although this step is purely optional, it is a good idea to get in the habit of recording this information every time you build a new macro so that you and your coworkers can always know what to expect from the macro when its run.

You click this drop-down menu item or command button when you want the macro recorder to record the Excel macro relative to the position of the current cell.

For this example macro, which enters the company name and formats it in the worksheet, you definitely need to click the Use Relative References button before you start recording commands.

Otherwise, you can use the macro only to enter the company name starting in cell A1 of a worksheet.

Next, click the Bold button and then click 12 on the Font Size drop-down list in the Font group on the Home tab.

Finally, drag through cells A1:E1 to select this range and then click the Merge and Center command button, again on the Home tab.

This lets you know that the macro recorder is now turned off and no further actions will be recorded.

This means that you can click or tap this button to open the Record Macro dialog box whenever you need to create new macros rather than having to select the Record Macro option on the View or Developer tab of the Ribbon, as described in the previous steps.

Excel lists the names of all the macros created, both those in the current workbook and those that are saved in the PERSONAL.XLSB workbook, in the Choose Commands From list box.

Excel For Mac Basic Commands New Row