Data validation drop-down lists in Excel adopt the same order as the source. In this example, to order the nations alphabetically, you would need to sort the source data by column B.

Not all sorts in Excel are alphabetical. Sometimes, you need to sort by an irregular set of terms, and when that happens, you need to create a custom sort. Here's how.

How to add a third column to sort in Excel There are very few repeated dates, but there are a few repeated months. Let’s create a new custom sort on three columns: Date, Personnel and Region.

Microsoft Excel 2013's Home tab includes options in the Cells group to insert a blank sheet column and to delete unwanted sheet columns. The row of alphabetical column headings stay in the same ...

How to Create Graphs in Excel With Multiple Columns. Column graphs offer a visual representation of data that allows easy comparison between multiple values. Typically, these columns are uniformly ...

There are many ways to sort data in Microsoft Excel, and one of the simplest and most convenient is the SORTBY function. It lets you dynamically sort your data by more than one array while ...

How to Create a Column Column Chart in Excel Watch this video on YouTube. Take a look at other insightful guides from our broad collection that might capture your interest in Excel skills.

Are you still putting your data in plain, old spreadsheets? Excel 2013 makes it easy to link tables, create reports and more.

Much of the data that you use Excel to analyze comes in a list form. You might need to sort the data, filter it, sum it, and perhaps even chart it. Excel tables provide superior tools for working ...

Excel has announced a new array-based function called SORT, which can be used to sort data in one or more columns without involving a manual sort process or a complicated macro process.

In this post we show you how to create a Bar Graph or Column Chart in Excel. Bar graphs could be both 2-D or 3-D depending on the editor you use.