Skip to main content
Workforce LibreTexts

18.3: Autofill using Formulas

  • Page ID
    13700
  • \( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \) \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)\(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\) \(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\)

    Another benefit of using formulas is the ability to use autofill. Autofill can use a formula previously used in one cell, and copy that formula for use in the cells relative to the new cell. To perform this action, select the specific reference cell you would like to use to copy the formula to the adjacent cells with Autofill. In the lower right-hand corner of the cell will appear as a “+” marker to use the fill handle.

    clipboard_e794c3b43fba8c08c14df4188991c8f79.png

    Click on the marker and drag cursor to select the adjacent cells you wish to copy the formula. When all of the cells are included, release the mouse button and all cells will be auto-filled with the same formula.

    clipboard_e90c15e10c00807863cd2a5297866e2e7.png


    18.3: Autofill using Formulas is shared under a CC BY license and was authored, remixed, and/or curated by Nick Heisserer.

    • Was this article helpful?