#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.
0 Comments
Leave a Reply. |