You can use this feature to repeat information or complete a pattern of content in a spreadsheet. Just follow these steps:
- 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. (When you place your cursor over the blue box, the cursor arrow changes to an x-y axis.)
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.
Also, if Auto-Fill doesn't recognize your content, you can try using Google Sets, a Google Labs product, to establish a pattern. For more information about Google Sets and other Google Labs products, visit http://labs.google.com/sets. To use Google Sets with Auto-Fill, complete steps 1 and 2 above, and in step 3, press Ctrl (Windows and Linux) or Option (Mac) while you click and drag the blue box to select additional cells.