Filling in data gaps in Excel – Option 2- Tool

Please sign up for the course before starting the lesson.

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: Data cleanup in Excel > Filling in gaps