Excel VBA Macro

How to Move Every Other Row to a New Column in Excel

This post will guide you how to move every other row to a new column in Excel. How do I move every odd row to another column with formula in Excel 2013/2016. How to move every even row to other column in Excel with VBA Macro in Excel. Move Every Other Row to New Column… read more »

How to Save a Range Selection to Text File in Excel

This post will guide you how to Copy a Range of Selection to a Text file in Excel. How do I copy/paste a range from the current worksheet to a notepad text file with VBA Macro in Excel 2013/2016. Assuming that you have a list of data in range B1:B5 in your worksheet, and you… read more »

How to Set Default Values for Drop Down List in Excel

This post will guide you how to set the default value in the dropdown list with VBA Macro in Excel. How do I create a drop down list with pre-selected value in Excel 2013/2016. Set Default Values for Drop Down List with VBA Assuming that you have many data validation cells with drop-down list in… read more »

How to Change Multiple Pivot Table Fields in Excel

This post will guide you how to change the format of all pivot table fields at once in Excel. How do I change multiple pivot table fields from the default sum of function to the count of function at once with VBA in Excel. Change Multiple Pivot Table Fields by Manually Change Multiple Pivot Table… read more »

How to Show Full File Path in Title Bar in Excel

This post will guide you how to show full file path in title bar in Excel. Is there a setting in Microsoft Excel that allows the display of the full path to the opened file in the window title bar? Or How to display an workbook’s full location in the Quick Access Toolbar in Excel… read more »

How to Select Only Bold Cells in Excel

This post will guide you how to select only bold cells in a range of cells in Excel. How do I select all bold cells in a given range using VBA Macro in Microsoft Excel 2013/2016. Select Only Bold Cells Using Find And Replace Select Only Bold Cells Using VBA Assuming that you have a… read more »

How to Replace Zeros with Blank Cells in Excel

This post will guide you how to replicate zeros with blank cells in a selected range in Excel. How do I convert cells containing zero with blank cells  in selected range in an Excel Worksheet. Replace Zeros with Blank Cells with Find and Replace Function Replace Zeros with Blank Cells with VBA Macro Assuming that… read more »

How to Clear or Disable the Recent Workbook List in Excel

This post will guide you how to clear or disable the recent workbook list in Excel 2013/2016. How do I clear Recent Document lists with VBA macro in the Microsoft Excel. Clear Recent Workbook List Using Excel Options Clear Recent Workbook List Using Unpinned Workbooks Clear Recent Workbook List Using VBA Macro When using Excel… read more »

Sidebar