Ranges

Extra rows in your ranges are important to prevent extra work and bad calculations. When you insert rows to a spreadsheet, Excel can sometimes behave in an unexpected way. To make things worse, Excel doesn’t make it obvious that it’s doing something weird. If you aren’t paying close attention, you could easily end up with