Why do we need a macro

Office Excel: create a macro - this is how it works

display

In software development, macros are sequences of instructions that have a specific designation (macro name) and automate a process. This saves time and can make work easier with large Excel files. They consist of a combination of key and mouse clicks that are recorded and saved. There are macros not only in Excel, but also in all other Office applications. In this article, however, we will go into more detail on the use in Excel.

Activate macros in Excel

You want to create macros, but you have the Developer tools not yet shown as a tab? In this article, we'll show you how to unlock the developer tools in Excel so that you can start using the Creation of the macros to start.

Follow our step-by-step instructions or take a look at the quick start guide.

Use macros in Excel

If you've assigned a keyboard shortcut to your macro, you can now easily run it using it. Otherwise, proceed as described in the following instructions.

Follow our step-by-step instructions or take a look at the quick start guide.

Quick guide: Creating macros in Excel

  1. Open Excel and click the tab "Developer tools".
  2. There click on "Record Macro".
  3. Give one Names for the macro and, if desired, also one Keyboard shortcut. Click on "to confirm"OK".
  4. The recording is now in progress. Perform your desired Command sequence by. We have z. B. changed the appearance of the table.
  5. When you are done click under "Developer tools" on "Stop recording".

Brief instructions: Using macros in Excel

  1. Under the tab, clickDeveloper tools" on "Macros".
  2. Select the desired macro and click on "To run".
  3. The macro will now start with the previously recorded one Command sequence run automatically.