How to Autofill in Google Sheets | Scribe

    How to Autofill in Google Sheets

    • Alai Umerez |
    • 4 steps |
    • 12 seconds
      1
      Open a spreadsheet in Google Sheets on your computer In a *column or row*, enter text, numbers, or dates in at least *two cells* next to each other
      2
      Select the cell(s) with the data you want to extend This could be a single cell or a range of cells
      3
      Locate the fill handle This is the small blue square at the bottom-right corner of the selected cell or range
      4
      Click and drag the fill handle in the direction you want to autofill. As you drag, Google Sheets will preview the auto-filled values Release the mouse button to fill the cells with the predicted values
      information ordinal icon
      Tip! To get the most out of Google Sheets' Autofill, keep these tips in mind: - **Predictable patterns are key:** Autofill is most accurate when your data follows a clear pattern, like dates, numbers, or a mix of text and numbers. The more consistent you are, the better the results - **Don't forget about formatting:** When you autofill from a cell with special formatting (bold, italics, etc.), that formatting will carry over to the new cells. Always double-check and adjust the formatting as needed