Hello Excellers, time for some back to basics today with Excel Macros. Let's take a look at assigning or changing a shortcut key with a Macro. Yes, welcome back to another #MacroMonday blog post in my Excel 2021 series. The Basics Of Excel Macro Shortcut Key. When you start recording a macro with the Macro Recorder, the Dialog Box appears. This has a section or space for a Shortcut Key to be assigned to the Macro. this means it can be run quickly with the keyboard shortcut. See … [Read more...]
Count Cells That Contain Text. Excel Tip
Hello, Excellers. Welcome back to another #FormulaFriday Excel tip in my #Excel 2021 series. Today I will show you how to count cells in your Excel worksheet that contain TEXT. If you need to count how many of your cells in your Excel range contain text then this is a really easy way to do this. By using COUNTIF and a WILDCARD the solution is easy. How about an alternative solution also?. As always in Excel, there are sometimes a number of ways to get to the same solution. I find it … [Read more...]
How To Show or Filter Duplicates In An Excel Pivot Table.
Hello and welcome to another blog post in my 2021 Excel tips series. This blog post is in response to a question by a subscriber. They wanted to use their Pivot Table to filter out duplicates in their data. So, in this simplified sample data set I have some employee records for allocations of charging stations. Some of the records are duplicated. This a small sample replication of the data set. The original was a lot bigger. Also, there are MANY ways to identify duplicates in … [Read more...]
Macro Mondays – Insert A The Number Of Rows Into Excel Worksheet Specified By The User.
Hello Excellers and time for some more #macromondays VBA fun. Today, I will show you how to write a Macro to insert extra rows into your excel worksheet. The number of rows will be variable, determined by how many rows the user types into an Input Box. If you want more Excel and VBA tips then sign up for my monthly newsletter. I share 3 Excel Tips on the first Wednesday of the month and receive my free Ebook, 30 Excel Tips. To see all of the blog posts in the Macro Mondays Series then … [Read more...]
Macro Mondays -Save A Back Up Copy Of Your Excel Workbook With Today’s Date
It's Monday so must be time for some #MacroMonday Excel fun. Today I want to share with you a really handy Macro that will save a backup copy of your workbook with today's (or whatever date it is) date. How cool is that?. I use this a LOT. Making backups of your Excel file should be part of your usual spreadsheet routine. What Does The Macro Do? This Macro will save your Excel workbook to a new file with today's date as part of the filename. I love … [Read more...]
- 1
- 2
- 3
- …
- 98
- Next Page »
Recommended Excel Resources
