Constants: This is the fastest way to audit a spreadsheet for errors. It finds every cell that contains a manually typed ...

One of the things I don’t like about Excel 2008 is that setting zoom levels is a bit more complex than it need be. If you use Excel’s View -> Zoom menu, this opens a new window, from which you then ...

After spending countless hours navigating spreadsheets, wrestling with formulas, and formatting endless rows and columns, I've found a collection of Excel productivity hacks that have transformed the ...

Shelby Brown (she/her/hers) is an editor for CNET's services team. She covers tips and tricks for apps, operating systems and devices, as well as mobile gaming and Apple Arcade news. Shelby also ...

Microsoft’s updated spreadsheet tool isn’t getting a lot of new, whiz-bang features, but it is becoming more functional. That’s something both new and experienced users will enjoy—especially a new ...

An curved arrow pointing right. Data validation in Excel allows you to create drop-down menus right inside individual cells. You can also restrict the types of values entered into different cells.