How to use AutoFill to Automate Repetitive Entries in Excel

  • MORE

 Excel is both complex and wonderful because of its redundancies. No matter what you’re attempting to do, there’s often two, three, or more ways to do it. This is one of those examples.

hero

Let’s say you’re adding a series of dates, or a number of similar titles (photo 1, photo 2, etc.) in a spreadsheet. Rather than sitting down and entering each of these manually, Excel has a tool called AutoFill that can attempt to guess patterns and fill repetitive entries for you automatically. It’s a great time-saver, and once you use it you’ll never go back to the old way.

1. Begin by entering a series of repetitive things in a spreadsheet. Most often, I’d say these are likely to be dates, so we’ll use dates in this example.

dates

2. Move your cursor to the lower right part of the last cell over the square that pops up in each column. You’ll know you’re on it when the + sign turns black. This is called the the fill handle.

handle

3. Once there, just click and drag the column down.

drag

4. In the next row, we’ll do the same thing with similar titles. Try naming three or four columns and adding a number after each.

name

5. Repeat steps two and three to AutoFill the data.

drag2

Add a comment