Excel VBA Examples

How to Extract First Letter from Each Word in a Cell in Excel

This post will guide you how to extract first letter from each word in a given cell in Excel. How do I extract the first letter of each word in a range of names in your current worksheet in Microsoft Excel 2013/2016. Assume that you have a range of First, Second and third names and… read more »

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 Send Current Workbook Directly through Outlook in Excel

After editing current worksheet (workbook) we often want to send this workbook to others to share information or assign task directly by email. Though we can launch our Outlook mailbox, add it as attachment and then send it. Actually, we have other ways to send it through Outlook in excel directly. This article will introduce… 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 »