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



Note: When dragging the blue box, you can only select those cells that are directly above, beneath, or beside the highlighted cells.


  1. Enter your content.
  2. Highlight the cells. A small blue box appears in the lower-right corner.
  3. Click the blue box and drag it to select additional cells where you'd like your content to repeat.

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.

This feature currently isn't available on mobile devices.

Matt is a Docs & Drive expert and author of this help page. Leave him feedback below about the page.

Was this article helpful?