Whole-column references in Excel are silent performance killers, often forcing the program to manage a range of over a million rows. As a result, they can significantly slow your workbook's ...

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, ...