Automate repetitive data entry and fix broken sorting hierarchies using Excel's powerful, hidden Custom Lists tool.

Your Excel 2013 spreadsheets can benefit from page headers and fixed column titles, also called description rows. They allow readers to follow your pages and understand content easier, because the ...

Impress your coworkers with these nifty tricks.

Have you ever struggled to make sense of a dataset with too many categories or time-based data? It’s a common challenge—how do you present individual contributions while still showing the bigger ...

Drop-down lists in Microsoft Excel (and Word and Access) allow you to create a list of valid choices that you or others can select for a given field. This is especially useful for fields that require ...