Click Customize Ribbon and under Main Tabs, check Developer.

Considering you have already created a spreadsheet on Excel, click File and go to Options.

Now, let us learn how to enable macros in Microsoft Excel.

Simple Methods to Convert PDF to Excel for Free.

That's why it is always advised to enable macros whenever they are needed and naturally you should keep them disabled when not in use. There's always a security risk involved when you turn on the enable all macros setting.

You should understand that a malicious macro can even delete important files stored on your computer. While it should be absolutely fine running a macro that you created yourself, the same can't be said for the ones you download online. Of course, macros are really useful and they make our life easier by automating repeated tasks yet there are huge security risks involved while running macros from unverified sources. Now, instead of calculating the total marks of each student one by one, you can record a macro by performing the task on one student and then you can easily automate the same thing with other students by simply running the macro. For instance, you have a spreadsheet consisting of a list of students with their scores listed in different subjects. In simple terms, a macro lets you automate repeated tasks such as calculating the sum total of marks of students in different subjects. Before we tell you how to enable macros, it is important to know what a macro is in Microsoft Excel.

Enable developer mode in excel for mac