Excel VBA Examples

How to Remove Line Breaks (Carriage Returns) in Excel

This post will explain that how to remove line breaks in your data set in Excel. How do I remove carriage returns or line breaks with a formula in Excel. How to remove line breaks with VBA Macro in Excel. How to remove line breaks with find and Replace feature in Excel 2010/2013/2016. Remove Line… read more »

How to Select Every Other Row in Excel

This post will guide you how to select every other row with VBA macro in Excel. How do I select every nth row so that you can delete them in Excel. How to highlight every other row in Excel. Select Every Other Row Video: Select Every Other Row Select Every Other Row Assuming that you… read more »

How to Disable the Research Task Pane in Excel

This post will explain how to disable the research task pane in Excel 2010/2013/2016. How do I stop the research pane appearing in Microsoft Excel. Disable/Stop Research Pane When you press Alt key on your keyboard, and then click a cell simultaneously in your worksheet, a research task pane will appear at the right side… read more »

How to Unmerge Cells and Fill Down Values in Excel

This post will guide you how to unmerge cells and fill with duplicate values in Excel 2013/2016. How do I unmerge multiple cells and copy the content in each previously merged cell in Excel. How to unmerge cells and fill down duplicate values with VBA Macro in Excel. Unmerge Cells and Fill with Duplicate Values… read more »

How to Delete Rows if It Contains Zero in Excel

This post will guide you how to delete rows if it contains zero value in Excel. How do I delete entire rows if one cell is equal to zero with a VBA Macro in Excel. Delete Rows If It Contains Zero with Filter Feature Delete Rows If It Contains zero with VBA Macro Video: Delete… read more »

How to Capitalize First Letter of Each Word in Excel

This post will guide you how to capitalize the first letter of each word in a cell in Excel. How do I capitalize the first letter only with a formula or VBA Macro in Excel. Capitalize the First Letter of Each Word with Formula Capitalize the First Letter of Each Word with VBA Code Video:… read more »

How to Deselect Cells from Selected Range with VBA

This post will guide you how to deselect cells from a selected range of cells in your worksheet. How do I quickly deselect cells from a selected range of cells with VBA code in Excel. Deselect Cells from Selected Range with VBA Video: Deselect Cells from Selected Range with VBA Normally, if you want to… read more »

How to Sum Only Filtered Data or Visible Cell Values in Excel

This post will guide you how to sum only visible cell values in Excel. How do I sum only visible cell values in a selected range with a formula in Excel. How to sum only visible rows when filtering data in your worksheet with VBA code in Excel. Sum Filtered Data Only with Formula Sum… read more »

How to Round a Range of Cells in Excel

This post will guide you how to round a range of cells with a formula in Excel. How do I round a range of cells using VBA macro in Excel 2013/2016. How to round up a range of numbers in a column in Excel. Round a Range of Cells with ROUND Function Round a Range… read more »

Sidebar