Excel VBA Macro

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 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 Insert a comment into Multiple Cells in Excel

This post will guide you how to insert a comment into two or multiple cells in Excel. How do I add comment to multiple cells with VBA Macro in Excel 2013/2016. Insert Comment into Multiple Cells Assuming that you have a list of data in range B1:B5, in which contain some text values, and you… read more »

How to Select Only Cells with Data in Excel

This post will guide you how to select all cells with data in Excel. How do I select only cells with data using VBA Macro in Excel 2013/2016. Select Only Cells with Data Assuming that you have a list of data in range A1:B5, in which contain text values and blank cells, and you want… read more »

Sidebar