Excel's ascending and descending sort options are powerful tools, but they won't always sort values in a familiar and meaningful way. When this is the case, you might need a custom sort. Sorting is a ...

I select columns A-H in my spreadsheet and use the filter. I can now sort and filter the data by the various columns: This dialog box lets me sort the data by rows, or display only some rows to look ...

Small databases of a few rows, to a few thousand rows, can often be created more quickly and easily in Microsoft Excel, than by using a dedicated database system. Excel is available as a stand-alone ...

Whether you’re using Microsoft Excel 2008 ( ; $400 as part of Office 2008) or 2004, you need some tricks up your sleeve for easing day-to-day tasks, such as entering data or custom sorting, as well as ...

Excel spreadsheets can often contain large amounts of data ranging across broad categories. For example, a sales spreadsheet might record sales of products across multiple departments, or within ...