Filling in data gaps in Excel – Option 2- Tool

The GOTO Special trick works well for filling in data gaps in Excel but there are times where Excel cannot remember that many blank cells. Perhaps when you hit 100 000 rows. So there is another way to do it and you probably already use this tool everyday.

Back to: