Learn Microsoft Excel Online Free
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 »
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 »
This post will guide you how to find the first value greater than a specified value in a range of cells in Excel. How do I find the last value greater that a given value in a row with a formula in Excel. Find the Last Value Greater Than X Find the First Value Greater… read more »
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 »
This post will guide you how to import multiple .txt files into separate worksheets in the opened workbook in Excel. How do I quickly import multiple text files from a local disk into each worksheets with VBA Macro in Excel 2013/2016. Import Multiple Text Files into Separate Worksheets Assuming that you have opened one workbook,… read more »
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 »
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 »
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 »
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 »
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 »
