Remove Empty Rows and Columns from Excel Spreadsheet

Published on 13 Feb, 2019 by Milos Gregor

The Reshape.XL add-in has one interesting function  -  Pack. This function is used to remove blank rows or columns.

Its application is very simple and contains only one adjustable property -  Pack Mode. Using this property you can define if you want to delete only empty rows, blank columns or both. Example applications of this function displays the following video-tutorial.

The  Pack function is simple to use and fast. In the case, you want to remove rows containing some empty cells, use the  Drop_NA function.