- From the menu select Spread | Delete | Empty Rows + Columns.
This deletes any rows in the spreadsheet where all the cells contain missing values (*) or have empty cells. The remaining rows will be renumbered to remain in consecutive order.
Genstat can also remove empty rows and columns automatically whenever you save the spreadsheet.