Excel VBA Examples

How to Find All & Select All Merged Cells in Excel

We open an excel file and find there are merged cells obviously in it, and if we want to find out all of the merged cells, how can we do? In this article, there are two ways to find merged cells, you can use Find command, or use VBA code to find them out. First… read more »

How to Add Brackets for Cells in Excel

Sometimes we need to add brackets into cells to enclose texts for some reasons. If we only add brackets for one single cell, it is very easy, but if there are a column of cells need to add brackets, how can we do? This article will show you three simple ways to add brackets by… read more »

How to Allow Group Ungroup Rows on Protected Sheet in Excel

This post will guide you how to allow “Group/Ungroup” rows on a protected Worksheets in your Excel. How to group or ungroup rows in a worksheet in Excel 2013/2016. Group/Ungroup Rows Allow Group/Ungroup on Protected Sheet Group/Ungroup Rows Assuming that you have lots of rows or columns and you want to group rows or columns… read more »

How to Stop Formulas Auto Calculation in Excel

Normally we often use auto calculation in excel to do sum or other formulas for convenient. But sometimes we want to stop this after several calculations. In below article you will have two ways to stop the auto calculation. The first way is stop auto calculation by formulas options in Excel directly. The other way… read more »

How to Insert Cell Content into Header or Footer in Excel

This post will guide you how to insert the contents of a paricular into the header or footer cell in your active worksheet in Excel. How do I put a cell value into header or footer in all worksheets in your active workbook using VBA Macro in Excel. Insert cell Content into Header or Footer… read more »

How To Convert Text Case into Uppercase or Lowercase in Excel

This article will introduce two ways to change test case in Excel. You can perform UPPER\LOWER\PROPER functions to convert text into uppercase or lowercase letters in Excel , and you can also use VBA macro to perform the task. Select one you like, and let me show you the methods. You may meet the situation… read more »

How To Set paste Values as Default Paste in Excel

This post will guide you how to set paste values as default paste in Excel. How do I set the default paste special in Excel to paste only values when using Ctrl+v keys. when you want to copy data from a selected range of cells and then pasted it to another range with Ctrl +… read more »

How to Filter Formula in Excel

This post will guide you how to filter your data with an Formula in Excel. How do I filter cells with formulas through a User defined function in Excel 2013/2016. Filter Formula Assuming that you have a list of data in range B1:B5, in which contain some text values and formulas. and you want only… read more »