Microsoft Excel's Data Validation tool lets you add a drop-down list to a cell based on existing data in a column. However, how this works depends on whether the source data is part of a formatted ...

With Microsoft Excel's powerful sorting capabilities, you can enter unsorted data and let the software sort your data numerically, alphabetically or chronologically. You can sort all the rows in a ...

Splitting the contents of a cell into more than one column manually in Microsoft Excel would take too much time and likely result in errors. Fortunately, the program offers many ways—from built-in ...

There are two situations in which you might need to merge two columns of data in Excel 2013. If you've imported two columns of data from separate sources, you might want to combine them into a single ...