Excel VBA Macro

How to AutoFilter a Table based on a Cell Value in Excel

This post will guide you how to auto filter a given range of cells based on a certain cell value in Excel 2013/2016. How do I use VBA Autofilter function to filter the data based on a cell value in Excel. For example, you wish to quickly filter the data in range A1:B5 based on… read more »

How to Extract Bold Text from A List in Excel

In our daily work we may mark some texts in bold to make them to be noticed clearly. And if we want to extract them from original list, we need to know the ways to find them and then move them to another range. This free tutorial will introduce you two ways to extract bold… read more »

How to Delete Entire Rows if Blank Cell Exists in Excel

Sometimes we need to delete the entire row which contains blank cell from a table. Though we can delete them by right click on row index and just ‘Delete’ them manually, if they are not adjacent or the table is very long, to delete rows manually is very troublesome. As there are a lot of… read more »

How to Sum All Digits in A Cell in Excel

If we enter a number 1234 in a single cell and we want to get the sum of all digits like 1+2+3+4=10 in another cell, how can we do? As there is no function like SUM to sum all digits in a cell, we need to use a formula with some functions together to do… read more »

How to Highlight All Non-Blank Cells in Excel

Suppose we have a table with some blank cells, if we want to highlight all non-blank cells how can we do? Though we can press ctrl and pick each non-blank cell one by one, this way is very bothersome. We need a convenient way to highlight all non-blank cells immediately. Actually, we can implement this… read more »

How to Change Cell Value by Clicking on It in Excel

If we want to change cell color by clicking on it, we can implement this via editing VBA code. Don’t be afraid of code editing, this article will show you some short VBA codes directly for changing cell color by double clicking/right clicking on it, you can just copy and paste them into VBA code… read more »

How to Disable Update Link Message in Excel

When we launching excel workbook with external links exist in opened worksheet, update link message will pop up and ask us to update links, and we can click on ‘Update’, ‘Don’t Update’ or ‘Help’ to do more operations, or we can click close button to close it directly. Anyway, we have to close this message… read more »

How to Dynamically Extract Unique Values from A Column List in Excel

Suppose we have a list of some objects in one column, and some of them are duplicate, they also can be replaced by typing different object name, here’s the question, how can we dynamically extract unique values from this list in time if they are changed frequently? This article will show you two methods to… read more »

How to Name Worksheet Name with Specified Cell Value in Excel

When we launching Excel and create a new workbook, we can find that some worksheets are already created and the default sheet name is sheet1 for example. Actually, we have to rename worksheet name in most situations depends our requirement. And in our daily life we often rename worksheet name by right click or double… read more »

How To Force Text String to Upper,Lower, or Proper Case in Excel

This post will guide you how to force test strings to uppercase or lowercase or Proper cases through an Excel formula or data validation in your Excel 2013/2016. How to convert text to upper, lower, or proper case in Excel. Assuming that you want to force text strings to Upper case when you type words… read more »

How to Auto Fill Formula When Inserting New Rows/Data in Excel

Sometimes we create a table with formula applied to specific column. And when we editing the table, for example inserting a new row with data into the table, we want the new data lists in the specific column is also applied with this formula as well. Normally we can drag down the upper cell applied… read more »

How to Split Data in Long Column into Multiple Columns in Excel

Sometimes we need to split data from a long column into a table with several columns based on some criteria like X rows or X columns. If we split data by manual, it is very complex and troublesome. So, we need a simple way to split data into multiple columns. This article will introduce you… read more »

How to Search and Locate Worksheet in Excel

If there are multiple worksheets exist in excel, there will be a lot of worksheet tabs in tab bar. And it is difficult to find a worksheet we want. Though we can search worksheet by right click in worksheet bar to activate worksheet, a simple and convenient way will be better especially there are a… read more »

How to Delete/Remove Hidden Worksheets in Excel?

If there are some hidden worksheets exist in excel and you want delete them as they are not useful, you can unhide all worksheets and remove them one by one. This way is quite annoying and complex. If we can remove all hidden worksheets by only one step or a simple way, it will be… read more »