Excel VBA

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 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 »

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