Category: Macros

Excel Template or Macro? When to use each!

A lot of Excel users are confused about when to use macros and when to create templates.  A macro is a recording of formatting changes and other steps that can be replayed quickly. A template is a pre-formatted spreadsheet with headers and formulas – awaiting your data. I find that…
Read More

Making the Most of the Excel Macro Recorder Feature

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…
Read More

Excel Macro Email

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…
Read More

Excel Macro Tutorial for Beginners

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…
Read More

Can You Permanently Save a Macro in Excel for Use in All Workbooks?

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.)…
Read More

Excel Macro: Relative Reference

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…
Read More

Searching for Data in Excel

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…
Read More

How to Record an Excel Macro (Part 2)

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…
Read More

Excel Macro Examples for Use (Part 1)

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…
Read More

Harnessing the Power of an Excel Macro to Delete Rows in a Spreadsheet

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…
Read More