1. Home
  2. Fill Empty Factors Cells in Columns

Fill Empty Factors Cells in Columns

When reading in data from a foreign spreadsheet source (Excel/Quattro/Lotus) or from the clipboard, having the option Suggest filling in missing factors set on the Tools | Spreadsheet Options | Conversions tab will bring up this dialog if any of the factor columns have a number of missing values.

Column list

The columns marked with a leading F will have their missing values replaced from the last non-missing value above the cell. To specify which columns are to filled, double click the column names, and F is placed at the start of the column’s name.


Alternatively, columns can be selected for conversion to a factor by clicking on them, and then clicking the Fill button. They can be deselected by clicking the Leave button.

Fill all

Select all the columns to be filled.

Leave all

Select all the columns to be left in their initial state, i.e. don’t fill any columns.

See also

Understanding Factors within a Spreadsheet
Spreadsheet Factor Menu
Spreadsheet Options
Spreadsheet Column Fill

Updated on April 2, 2019

Was this article helpful?