2.129 FAQ-1144 How do I Autofill my rows or columns with data?

Last Update: 9/1/2022

Origin provides several ways to auto-populate columns and rows with data.

Cell formulas and column formulas can be set and then dragged to fill other cells.

You can switch between numeric view and formula view in the worksheet by

  • Show Formula button Popup Show Formulas.png on the worksheet level mini toolbar, or,
  • Edit: Edit Mode (Ctrl + Alt + B) main menu.

Cell Formulas

Origin supports diagonal drag filling a block of cells.

See also: How do I auto fill cells with data?

  • Use the $ notation to fix either the column or row when drag filling.
DragFill.gif
  • Double-click the bottom-right corner of the cell to autofill to the column end with the selected cell formulas.
CellFormula.gif
  • Use the workbook and sheet reference syntax to combine data from other workbooks or sheets in cell formulas.
BookSheetReferenceCellFormula.gif
  • Column label cells also supports autofill. Hold Ctrl while dragging or double-clicking to fill without incrementing.
ColLabelCellAutoFill.gif
  • When you use syntax of row references in square brackets, column[row], like sum(A)[1] or A[1], to auto-adjust the row references to be relative while autofill, press Ctrl when dragging.

Column Formulas

  • Double-click the bottom-right corner of the formula cell (F(x)) to automatically fill all cells to the right. Hold Ctrl while dragging or double-clicking to fill without incrementing. Use the $() notation to fix a constant.
ColumnFormula.gif
  • Use the workbook and sheet reference syntax to combine data from other workbooks or sheets in column formulas.
    For the column formulas, $(j) is the column index of the current column.
BookSheetReferenceColFormula.gif
  • If you use column ShortName in the syntax, press Ctrl key while dragging to auto fill with incrementing.
BookSheetReference.gif
ColumnSetFill.gif



Keywords:show categorical number, category index, category value