Inside Microsoft Excel

Fill in data gaps automatically – even with blank rows standing in your way

Inside Microsoft Excel

by Kara Hiltz

Data doesn’t always come to you on a silver platter, perfectly laid out the way you need it. And you can’t leave blank cells in your data table, especially if you’re preparing the data for a PivotTable. When you need to swiftly fill in data gaps, Excel’s AutoFill feature doesn’t always get it right. The fill stops once it reaches a blank row. Here’s the fix: Our simple macro fills a value[…]


Subscribe to Inside Microsoft Excel

(get full access to archives and more)