Microsoft Excel's Data Validation tool lets you add a drop-down list to a cell based on existing data in a column. However, ...

or to leave certain data visible when you collapse other groups, you can use Excel's Ungroup button. First, select the grouped columns you want to ungroup (at any level). Then, click "Ungroup" in ...

The easiest way to alphabetize in Excel is to use one of the simplified sorting buttons located under the Data tab in the menu at the top of the spreadsheet. It is most useful for when you want to ...

If you don't have a keen eye and a perfect memory, you probably can't spot all the differences between two data columns ... radio button and the click "OK" to close the window. Excel highlights ...

Quit the data-search struggle by organizing your raw data into a Microsoft Excel spreadsheet. Rather than manually scrolling through a list of disorganized records, use Excel's built-in tools to ...

Microsoft Excel ... data as different-sized blocks. To add any kind of chart to a worksheet, select the data you want to chart, click the Insert tab in the Ribbon and click the Recommended Charts ...

Sorts are a simple task in Microsoft Excel if all you need is an ascending or descending sort. Excel is smart enough that it can interpret the data range ... add a new sort level.