Excel macro

Find and replace strings in Excel using regular expressions

When it comes to changing one piece of information to another, Microsoft Excel provides a number of options to choose from. Why would one want to complicate things with regexes? Because Excel's standard features can only process an exact string that you specify. Continue reading

Excel Data Validation using regular expressions

When it comes to restricting user input in Excel worksheets, Data Validation is indispensable. It can do anything you can possibly imagine. What if I want to allow entering only valid email addresses or strings that match a specific pattern? Alas, that's not possible. Regex you say? Hmm… that might work! Continue reading

Regex Match in Excel: regular expression matching with examples

When you need to find a certain value in a range of cells, you use the Excel MATCH function. When looking for a specific string in a cell, the FIND and SEARCH functions come in handy. And how do you know if a cell contains information that matches a given pattern? Obviously, by using regular expressions. Continue reading

How to remove first (left) or last (right) characters in Excel

When working with unstructured text data, you often need to parse it to retrieve relevant information. This article will teach you a few simple ways to remove any number of characters from the left or right side of a text string. Continue reading

How to remove text and leave numbers in Excel or vice versa

Imagine this: you receive raw data for analysis and find out that numbers are mixed with text in one column. In most cases, it will certainly be more convenient to have them in separate columns for closer examination. Continue reading

How to highlight duplicate text strings or words in Excel cell

Excel Conditional Formatting makes it possible to highlight duplicates in every possible way you can think of. But, as usual, there is a "but" - conditional formatting rules work on a cell level while you may want to highlight duplicate text rather than entire cells. This can only be done with macros. Continue reading

How to find and replace multiple values at once in Excel (bulk replace)

How do people usually search in Excel? Mostly, by using the Find & Replace tool, which works just fine for single values. But what if you have tens or even hundreds of items to replace? Luckily, there are a few more effective methods to perform mass replace in Excel, and we are going to look at each of them in detail. Continue reading

How to remove duplicates in Excel cell

When it concerns removing duplicate cells or rows, Microsoft Excel offers a number of different options. But when it comes to removing duplicate text within a given cell, Excel provides… nothing. Well, if there is no inbuilt function we need, let's go write our own one. Continue reading

Excel macro tutorial for beginners: how to create and use VBA macros

For Excel newbies, the concept of macros often looks insurmountable. Indeed, it may take months or even years of training to master VBA. However, this does not mean you cannot take advantage of the automation power of Excel macros right away. Continue reading

How to enable and disable macros in Excel

Like almost any technology, macros can be used for both good and evil. Therefore, in Microsoft Excel, all macros are disabled by default. This tutorial covers different ways to enable macros in Excel and explains potential risks associated with that. Continue reading

Personal Macro Workbook in Excel - make macros available in all workbooks

Normally, when you create a macro in Excel, it can only be accessed from that specific workbook. But what if you want to use it in other files too? Store your popular VBA codes in the Personal Macro Workbook. Continue reading

How to run macro in Excel and create your own macro button

Running macros in Excel is a pretty simple thing for experienced users, but it might not be immediately obvious to beginners. In this tutorial, you will learn many different techniques to run a macro, some of which may completely change your way of interacting with Excel workbooks. Continue reading

How to record a macro in Excel

Macros are a great way to automate repetitive tasks in Excel. If you find yourself doing the same things over and over again, simply record your actions as a macro and run it with a keystroke. Continue reading

Excel print area: how to set, change and clear

When you hit the Print button in Excel, the entire spreadsheet is printed by default. But what if you don't really need to print out all the content of a huge worksheet? Then set the print area that includes only your selection. Continue reading

How to delete blank rows in Excel quickly and safely

Empty lines can cause a lot of havoc to your worksheets on different levels and deleting them manually can be a time-consuming and error-prone process. In this article, you will learn a few simple and reliable methods to remove blank rows from your Excel worksheets. Continue reading

How to duplicate sheet in Excel with VBA

Duplicating multiple sheets multiple times manually is boring and time consuming. In this tutorial, you will find a handful of macros to automate this task. Continue reading

How to delete blank columns in Excel

The prospect of reviewing all the columns in your worksheet and removing the empty ones manually is definitely something you'd want to avoid. Luckily, Microsoft Excel provides a great lot of different features, and by using those features in creative ways you can cope with almost any task. Continue reading

How to do subscript and superscript in Excel for text and numbers

In this tutorial, you will learn many different ways to do superscript and subscript in Excel: keyboard shortcuts, custom formats, writing superscripted and subscripted characters with a mouse, and more. Continue reading

How to alphabetize tabs in Excel

There is only one method to rearrange worksheets in Excel - drag them to the desired position on the sheet tab bar. When it comes to alphabetizing tabs in a large Excel file, this may be a long and erroneous way. This tutorial shows a couple of time-saving alternatives. Continue reading

How to strikethrough in Excel

It is super easy to cross out text in Microsoft Word – you simply click the strikethrough icon on the ribbon. Naturally, you'd expect to see the same button on the Excel ribbon. But it's nowhere to be found. So, how do you strikethrough text in Excel? Continue reading