If you’re a Google Docs user, you know that AutoFill is a great way to fill in data on your spreadsheet. AutoFill lets you fill in data automatically from the Google search results page, and it’s a great way to keep your spreadsheet organized and tidy. Here are some tips on how to use AutoFill on a Google Docs spreadsheet:

  1. Start by opening the Google Docs spreadsheet you want to fill out with AutoFill.
  2. On the left side of the sheet, click on the AutoFill button.
  3. In the next window that pops up, you’ll be able to select which data type you want to use for yourAuto Fill: text or numbers.
  4. Once you’ve selected your data type, click on the OK button to start filling in your data.
  5. When everything is filled in, click on the Close button to close the window and finish filling out your sheet with Auto Fill!

Just type in a couple of numbers in sequence… 1 2 3 works pretty well. You could also put them across a row instead of down a column.

Then move your mouse over the dot in the corner until the pointer changes, then just drag it downward (or if you are filling a row instead, you can drag it to the right).

Let go of the mouse, and your data will be automatically filled in.

You could also make it skip by 1 instead, like 2 4 6 8, etc…

If you want to get really fancy, you can use the tip from reader Andy in the comments below… fill in the cells with something else that would normally be in a set, like the days of the week, then drag the blue dot downward…

And you’ll get a full list of days.

The same thing works for other information, basically anything that can be powered with Google Sets, and you can force Google Spreadsheets to always use Google Sets for the information by holding down the Ctrl key.

For example, if you type in Ford, Honda, Toyota, and hold down the Ctrl key while dragging the dot down…

It all works the same way. Sadly there’s no really advanced options like Excel has, but for most uses, this is good enough. Also, we’re aware this is a very simple tip for most of you, but we’re trying to help the beginners out as well!