There are two ways to fix this cause of the #SPILL! error. First, select the entire spill range (or at least the cell or cells causing the blockage), and drag it to another area in the worksheet. On ...

Users will appreciate a chart that updates right before their eyes. In Microsoft Excel 2007 and Excel 2010, it's as easy as creating a table. In earlier versions, you'll need the formula method.