Q. I have an Excel spreadsheet that contains errors because some of the numbers that are part of the calculations are blank or zero. Is there a way to have Excel automatically return something instead ...

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