Design is best, but when you're stuck with an existing data structure, it helps to know how to work around trouble. Susan Harkins explains. Excel sheets grow — sometimes by adding new functionality, ...

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

When you copy a formula, referenced ranges automatically adjust according to the formula's new position unless the ranges use absolute references. Removing the dollar signs in these formulas converts ...