Excel Examples

How to Filter Data with Strikethrough Format in Excel

This post will guide you how to filter or delete rows with strikethrough format in your selected range of cells in Excel. How do I Filter by strikethrough formatted text with Find and Replace function in Excel 2013/2016. Or how to find cells with strike through formatting in Excel. Filter Data with Strikethrough Formatting Using… read more »

How to Smooth the Angles of Line Chart in Excel

This post will guide you how to smooth the angles of line chart in your current worksheet. How do I make a smooth line chart based on your data in Excel 2013/2016. Smooth the Angles of Line Chart When you created a line chart based on your data in Excel, the angles of line chart… read more »

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 Delete All Named Ranges in Excel

This post will guide you how to remove all named ranges from your workbook in Excel. How do I quickly delete all named ranges with VBA in Excel 2013/2016. Method1: Delete All Named Ranges Method2: Delete All Named Ranges with VBA Assuming that you have created lots of named ranges in your workbook, and you… read more »

How to Filter Even or Odd Rows in Excel

This post will guide you how to filter even rows or odd rows from your data in Excel 2013/2016. Assuming that you have a list of data in range A1:C7, and you want to filter out even rows or odd rows from those data in your worksheet. How to do it. You need to use… read more »

How to Copy Chart Format to Another Chart in Excel

This post will guide you how to copy formatting from one chart to another chart in Excel. How do I copy chart formatting to anther chart in Excel 2013/2016. Copy Chart Formatting with Paste Special Copy Chart Formatting with Short keys Copy Chart Formatting with Creating A Template Assuming that you have a chart in… read more »

How to Reverse Axis Order in Excel Chart

This post will guide you how to reverse the order of a chart Axis in your current worksheet in Excel 2013/2016. Assuming that you have created a column chart based on your data in your worksheet, and you may want to reverse the Axis order in this chart. How to do it. And his post… read more »

Sidebar