Spreadspeed Feature Tour

Excel Worksheet Operations

Spreadspeed offers spreadsheet utilities that operate on the workbook level, the worksheet level, and the range level. This page highlights the utilities that operate on the worksheet level.

Delete Blank Rows and Columns

Spreadspeed offers 4 options for deleting blanks. All the tools will delete rows or columns without content, even if the cells are formatted.

The worksheet-level tools (Delete Blank Rows in Worksheet and Delete Blank Columns in Worksheet) delete only empty rows or columns in the used range of the worksheet. If an empty column, for example, is between other columns with content, the entire columns are shifted.

The selection based tools (Delete Blank Rows in Selected Range and Delete Blank Columns in Selected Range), will delete an entire row or column only if the entire row or column is empty. However, if a row or column of cells within the selection is blank, but other cells in the same row or column outside the selection are not blank, then the tool shifts only the cells within the selection.

Autofit Rows and Columns

the Autofit Rows and Columns tool goes beyond the standard autofit functionality that happens when you double-click a column header's right edge. It provides more control by allowing you to pick the following options:

  • Autofit all rows and columns
  • Reset unused rows and columns to their default sizes
  • Make column widths uniform to the widest autofit column
  • Make row heights uniform to the tallest autofit row
  • Resize all rows or columns to a user-specified, fixed size
Autofit Screenshot

Autofit Rows and Columns

Reset Used Range

Excel tracks which cells have held content, and the used range of a worksheet is the range of cells that have ever contained any content. However, when content is deleted from the worksheet, the used range is not automatically reset. This can lead to memory bloat and affect the operation of some functions. The Reset Used Range tool scans the worksheet for actual content and resets the used range accordingly.