Hello, Excellers. Welcome back to another #Exceltip, #MacroMonday blog post in my Excel series. Do you need to delete some data from your spreadsheet but keep the formula for future use? Learn how you can do it with a simple Excel tip. This Excel tutorial will show you how to delete data but keep formulas in Excel. Yes, […] The post Delete Data, Keep Formulas with an Excel Macro appeared first on How To Excel At Excel ..read more

Hello Excellers, time for another #macromonday blogpost. In this tutorial we will look at VBA and workbooks in Excel. If you’re like me, you have a ton of Excel workbooks open simultaneously. And it can be tough to keep track of how many are open, especially if you’re working on a project with multiple workbooks. Luckily, there’s […] The post Macro Mondays – An Excel Macro To Count How Many Excel Workbooks are Open appeared first on How To Excel At Excel ..read more

If you have many pivot table with filters, applying changes to them all can be time-consuming. Fortunately, there is an easier way! Using a macro in Microsoft Excel, you can quickly change all the filter settings at once. At the end of this article you be able update your pivot table filters at once with […] The post Macro Mondays – Change All Pivot Table Filters At Once With A Macro appeared first on How To Excel At Excel ..read more

In this blog post, I will show you how to easily remove multiple hyperlinks from an Excel workbook. I recently had this question submitted via email from a subscriber. They had a LOT of hyperlinks in an Excel workbook (with 50+ sheets), and they wanted to quickly remove all of the hyperlinks as they were […] The post Remove Hyperlinks From An Excel Workbook appeared first on How To Excel At Excel ..read more

Do you often feel overwhelmed trying to navigate the vast potential of Excel? You’re not alone! Many Excel users struggle to unlock the full range of capabilities Microsoft Office has to offer. Unlocking these advanced features could help you gain a better understanding and control over your data-driven workflows. But where do you start? One […] The post How To Enable The Developer Tab In Excel appeared first on How To Excel At Excel ..read more

Hello, Excellers. Welcome to another #MacroMonday blog post in my Excel series. Today let’s look at breaking up our VBA code by adding a breakpoint to your Excel VBA code.  If you’re an Excel user, you know that VBA code can be incredibly useful for automating tasks and customizing your spreadsheets. But what happens when […] The post Macro Mondays – How To Add A Break Point To Your Excel VBA Code appeared first on How To Excel At Excel ..read more

Have you ever needed to copy a file from one folder to another? If so, you’re in luck. In this blog post, we’ll show you how to do it using a macro. Stay tuned for our step-by-step instructions! I have to copy files from one folder to another every week. I find this a simple […] The post Copy A File From One Folder To Another – Macro appeared first on How To Excel At Excel ..read more

Hello Excellers,  it is time for some more cool code in the #macromondays series. It can be a pain to remember to protect your worksheets every time you close your Excel workbook. But with a few simple steps, you can automatically protect them for added security. In this post, we’ll show you how to protect a […] The post Macro Mondays – Automatically Protect A Worksheet When You Close Your Excel Workbook appeared first on How To Excel At Excel ..read more

Hello Excellers, time for some Excel Macro fun again.  Today’s Excel Macro tip is one I have been looking forward to sharing with you for a while. Are you looking for a quick way to delete all the rows with specific text in your Excel spreadsheet?. If so, you’ll be glad to know that there […] The post Macro Mondays – Delete All Rows That Contain A Specific Text String appeared first on How To Excel At Excel ..read more

Hello Excellers.  If you’re an Excel user, you know that one of the most tedious tasks is deleting rows if a cell is blank. Well, worry no more! With a simple macro, you can delete any number of rows automatically, based on whether or not a specific cell is blank. In this post, we’ll show […] The post Macro Mondays – How To Write A Macro To Delete Rows If A Cell Is Blank appeared first on How To Excel At Excel ..read more