This will open up a window where you need to enter. Navigate to the Developer tab, and hit on Record Macro.
Instead of doing this manually every week, you can just create a macro and perform all these actions in just a click. Rename the sheet name as the team name.Insert the Title for every sheet that includes team name and week number, mark it bold, and background yellow.You as a manager have the responsibility of reviewing and sending the sheet to the finance team every week.īut before sending you are asked to make some formatting like:
Add-ins: Allows to Insert an Add-In and can also manage them.Alt+F8 will directly open the list of macros. Macros: Gives the list of all the already recorded macros and is also used to record a new one.Visual Basic: Gives an Editor to write or edit VBA code.Once you enable the Developer tab, it will be displayed on the ribbon list.Įnlisted below are the options that are present under the Developer tab. #4) Under Customize Ribbon enable Developer. Once you enable the Developer Tab, it will always be shown in a custom ribbon for every Excel instance you open, unless you go ahead and disable it explicitly. This tab is hidden by default.įollow the below steps to unhide the Developer tab.
The Developer tab gives us the ability to work with features like Macros, Add-ins, and also allows us to write our own VBA code that will help us to automate anything we wish. Then you can create and run a macro that applies these formatting changes every time you wish to. Suppose every month you create a report that needs to mark the user accounts with the overdue amount in bold and red. Record Excel Macro Using Relative ReferenceĪ macro is a set of actions that you can run to perform the desired task.