Open Office remove empty rows

How to remove empty rows in an Open Office spreadsheet document. Select all (Ctr+A) in the spreadsheet document Go to last cell (Ctr+Shift+End) From the main menu, navigate to Data>Sort, then select value for ‘Sort by’ and ‘Then by’ Done