Excel Examples

How to Sort Columns from Left to Right in Excel

This 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 »

How to Add Arrows to Column Chart in Excel

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 »

How to Change Gap Width in Excel Bar Chart

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 »

How to Remove Duplicates in One Cell in Excel

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 »

How to Add an Axis Title to Chart in Excel

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 »

How to Print the Top Row on Every Page in Excel

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 »

How to Rank Numbers without Repetitive Ranks in Excel

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 »

How to Compare Two Lists in Different Worksheets using VLOOKUP in Excel

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 »

How to Sort Data by Last Character in Excel

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 »

How to Change Negative Numbers to Positive in Excel

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 »

Sidebar