Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.

Adding a search field to your spreadsheet can greatly improve data navigation and usability. In this guide, you’ll learn how to create a dynamic search box that filters data based on your input, using ...

When I was using Excel 2003, I could easily adjust which direction the cursor would move—either to the right or down—after I entered data in a cell. But Office 2007 doesn’t seem to give me a choice.

If you see the error “This value doesn’t match the data validation restrictions defined for this cell” when entering a value in an Excel cell, the solutions ...