You can use this feature to repeat information or complete a pattern of content in a spreadsheet. Just follow these steps:

  1. Enter your content.
  2. autofill

  3. Highlight the cells. A small blue box appears in the lower-right corner.
  4. autofill2

  5. Click the blue box and drag it to select additional cells where you'd like your content to repeat.
  6. Note: When dragging the blue box, you can only select those cells that are directly above, beneath, or beside the highlighted cells.


If Auto-Fill recognizes a pattern in the content of the selected cells, it fills in the remaining items to complete the pattern. In the example shown here, it finished the pattern by auto-filling Thursday, Friday, Saturday, etc. If Auto-Fill doesn't recognize a pattern, it will just repeat the content that was highlighted.