Removing Empty Columns and Rows when Saving From the menu select Tools | Spreadsheet Options then click the Sheets tab. Select Remove empty rows and cols on save then click OK. Updated on December 14, 2018 Was this article helpful? Yes No