Excel VBA

How to Count Cells that Contain even or odd numbers in Excel

This post will guide you how to count the number of cells that contain odd or even numbers within a range of cells using a formula in Excel 2013/2016.How do I count cells that contain odd numbers through the use of an Excel VBA Macro. Count Number of Cells that Contain Even Numbers Assuming that… read more »

How to Count Cells Are Not Blank or Empty in Excel

This post will guide you how to count cells that are not blank or empty in a given range cells using a formula in Excel 2013/2016.How do I count the number of cells that are not blank in a particular range with a VBA macro in Excel. You should know that excel offers several count… read more »

How to Count Cells Less Than a Specific Value in Excel

This post will guide you how to count the number of cells less than a particular numeric value in a given range cells using a formula in Excel 2013/2016. How do I count cells that are less than a specific value through VBA Macro in Excel. How to count cells if value is less than… read more »

How to Count Cells Greater Than a Specific Value in Excel

This post will guide you how to count the number of cells greater than a particular numeric value in a given range cells using a formula in Excel 2013/2016. How do I count cells that are greater than a specific value through VBA Macro in Excel. Count Cells Greater Than a Specific Value Assuming that… read more »

How to Prevent Users from Adding New Worksheet in Excel

Sometimes we may want to lock opened workbook and prevent other users from adding, modifying or deleting worksheets, for this instance, we can apply ‘Protect Workbook’ feature to implement this. If you want to just prevent others from inserting a new worksheet, you can also edit VBA code to make others cannot do this operation…. read more »

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 ignore Blank Cells while Concatenating cells in Excel

This post will guide you how to concatenate cells but ignore all blank cells in your worksheet in Excel. How do I concatenate cells but ignore blank cells with a formula in Excel. How to create a concatenate formula to skip blank cells with user defined function in Excel 2013/2016. Concatenating Cells but Ignore Blanks… 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 Save Only One Single Worksheet in Workbook in Excel

Sometimes you may want to save only one worksheet in one workbook, actually there are two ways to implement this. The first one, you can remove the others from current workbook, you must confirm that these worksheets are useless before removing. The second one, you can copy current worksheet to another new workbook, then only… 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 Disable F1 Key in Excel

When pressing F1 key it forth to enable Help pane in excel. In some situations, we can press F1 to enable other actions from other applications, for example, for some tools we can via pressing F1 to capture screen directly. So, we can disable F1 key in some instances. This article will help you to… 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 »

Sidebar