Skip to main content
Overview of Excel macros
Updated over a week ago
  • How to build macros?

If you need Excel to automate a repetitive task in Excel you may need to create a macro. A macro is a way in Excel, to record steps and replay them at your convenience.

  • Macros can be very simple: changing a date format for a column.

  • Macros can be also very complicated and involve coding and web access etc.

  • All macros are first recorded, then saved, and finally replayed when you need them.

  • The official Microsoft documentation can be found here.

In the video below, we show how to create, save and replay a simple macro. The macro changes the format of dates for a given column.

Note: On YouTube, you can find tons of videos on macros for specific use cases.

Did this answer your question?