Learn Microsoft Excel Online FreeThis post will guide you how to sort columns from left to right in Excel. How do I sort rows horizontally from left to right in Excel. Sort Columns from Left to Right by Transpose function Sort Columns from Left to Right by Using Sort Command You can use sort values in one column by… read more »
This post will guide you how to add arrows to the existing Colum chart in Excel. How do I make arrow chart in Excel. Add Arrows to Column Chart When you create a column chart in your worksheet, the column bars are shown in the column chart, and if you want to change the current… read more »
This post will guide you how to change gap width for an existing bar chart in Excel. How do I change the width of charts columns in Excel. Change Gap Width in Bar Chart When you created a bar chart based on data in your worksheet, it will have gaps between their bars by default…. read more »
This post will guide you how to remove duplicate characters from a text string in one cell in Excel. How do I remove duplicate words from a cell with a User Defined Function in Excel 2013/2016. Remove Duplicate Characters Remove Duplicate Words Remove Duplicate Characters Assuming that you have a list of data in range… read more »
This post will guide you how to add axis title to a chart in Excel 2013/2016. How do I add horizontal axis title or labels to chart in Excel. By default, when you create a new chart in your worksheet based on some data, and it will display a chart title automatically and do not… read more »
This post will guide you how to print with column headers on top of every page in Excel 2013/2016. How do I repeat specific rows or columns on Every printed page in your worksheet in Excel. How to print out table headings at the top of every page in Excel. Print Top Row on Every… read more »
This post will guide you how to rank range numbers with unique ranking in Excel. How do I use Rank function to get the unique ranking of values for a range with duplicate values in Excel 2013/ 2016. Ranking without Repetitive Ranks Assuming that you try to use the RANK function to sort values in… read more »
This post will guide you how to compare two lists in different worksheets in Excel. How do I compare two lists in different worksheets with VLOOKUP function in Excel 2013/2016. Comparing Two Lists in Different Worksheets Assuming that you have two lists of data in the different worksheets, and you want to compare those two… read more »
This post will guide you how to sort cells by last character in Excel. How do I sort data by the last character with a formula in Excel. How to sort cells based on the last character with User Defined Function in Excel. Sorting Data by Last Character with Formula Sorting Data by Last Character… read more »
This post will guide you how to change all negative numbers to positive in Excel 2013/2016. How do I remove negative sign to a number in cells with a formula in Excel. Change Negative Numbers to Positive with a Formula Change Negative Numbers to Positive with Find and Replace function Change Negative Numbers to Positive… read more »
