Category: Macros

Get the best in Excel® training anytime, anywhere.

Did you ever think to yourself, “There should be a shortcut for that!” Well, even if there isn’t, there can be! All you may have to do is record a macro. A word of caution before we begin: The one thing you can be sure of, as new versions of Excel are released, is that […]

Among the many little-known and perhaps even-less-used hacks one could exploit via Microsoft Office, an Excel macro email can save precious hours on a weekly basis. As a bonus, understanding the nature of these handy little “cheats” provides an incidental beginner’s introduction to some very basic principles of coding. This handy VBA code will send […]

To follow using our example, download MacrosForBeginners.xlsx Once you get comfortable navigating Excel, it won’t be long before you start to hear about this wondrous feature called a “Macro” that can leap tall projects with a single keystroke and make boring tasks go by faster than a speeding bullet. While Macros aren’t really the superman […]

Have you ever lost your macro or decided it is just too useful for only one workbook? You can save your macro in PERSONAL.xlsb to apply the macro to all workbooks that you open and use on your computer. (Macros stored in personal.xlsb will not be available on other computers.) Save a macro to your […]

Excel records Macros in absolute mode by default. In absolute mode, a Macro will start working in the same cell it was in when it was recorded. If, when it was recorded, A1 was the active cell, then it will return to A1 and begin working from there no matter which cell was selected prior […]

Are you looking for the “peanut butter and chocolate” of workplace efficiency: how to combine the power of Macros with the convenience of search? As of Office 2013, Excel does not provide an easy way to include a variable search term in the execution of a series of tasks recorded in a macro. By easy, […]

Do you want a practical way to make repetitive tasks in Excel easier and faster? Say you receive a spreadsheet every week from a reseller that markets your products. You perform the same changes weekly to adjust the format of the sheet to your company’s standards. You also run a series of custom calculations to […]

How much of your time do you spend on spreadsheets? You manually enter line after line of data and then painstakingly format it. This method might be fine for small, infrequent jobs, but imagine the time that could be saved if repetitive steps were automated! There are numerous Excel Macro examples available that simplify common […]

In our fast-paced, technology-driven world, it doesn’t make sense to spend time clicking through rows and rows on a spreadsheet just to delete them. By using the power of Excel Macros, you can automate the process so that Excel will eliminate any and all flagged rows instantaneously. Let’s take a real-world example. Transfiguration, Inc., is […]

If you’ve ever repeated the same actions multiple times in a spreadsheet, you’ll benefit from recording a macro to automate those tasks. But, once you have a macro, how do you access it? The easiest way is to add a macro button to your spreadsheet, for which Excel offers three straightforward methods: Add a button […]