Forum Discussion
Ascari17
Jan 18, 2019Copper Contributor
Delete Millian blank rows in Excel 2016
Dears, I want to delete the million blank rows in one sheet in my excel file to control the size of the file. I have tried to clear all and delete these rows, then save and reope...
Eva Vogel
Jan 18, 2019Iron Contributor
Hi! I suggest , you should start with a new workbook, then go to the Data Tab. Select importing with an excel power query or a power pivot. Import your issued workbook in this query. See the videos how to filter only the populated ( not empty) fields. Export your result to new table/workbook after filtering. Or try out making a database from it with MS Access for future tasks. Millions of rows are not performant content for excel. Go get it into a database, I recommend. Greets, Eva