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.
- Enter your content.
- Highlight the cells. A small blue box appears in the lower-right corner.
- 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.