➥ Go to the beginning of the free online Excel Course

  • There are several ways to auto-fill cells in Excel, and you should know at least the most basic ones.
  • The program is designed to interpret what we want to write and anticipate the information
  • How to autofill data step by step and what about sequences and data from other sheets?

The possibility that some basic tasks when studying or working are performed by a system and not by us manually can be very interesting in terms of productivity. For example, If you want to autocomplete cells in Excel, you have to know that doing it is very easy. But what are the ways to achieve it and the steps to follow?

This is one of the most common questions from those who are just taking their first steps with spreadsheets. Autocomplete or autofill the cells will allow you to be more efficient and spend less time doing the same tasks.

How does this option work in Excel?

This is an alternative that you should not rule out under any point of view, since all you have to do is fill in a cell or two, so that the program detects what information the rest of them should contain. Identifying this data does not take more than a few seconds, and it will become easier for you to resort to autofill.

  1. In an Excel document, fill in the first cell of a series
  2. Move your cursor to the bottom right corner of the cell to see it turn into a + sign
  3. Grab the corner of the cell and drag it to fill in the rest of the cells
autocomplete cells excel 2

You’ll notice that the process is similar if you want to fill cells with a sequence and not the same value.

  1. In an Excel document, fill in the first two cells of a series
  2. Move your cursor to the bottom right corner of the cell to see it turn into a + sign
  3. Grab the corner of the cell and drag it to fill in the rest of the cells
autocomplete cells excel 3

By having two reference cells, Excel will detect that it is a sequence and not the same value.

In the event that the application has not identified the correct pattern, adjust the autocomplete in the menu. Select the correct option or the one you need at the moment, and Excel will adjust it accordingly.

Autocomplete in Excel from another sheet

In more than one case, you will need to bring a list of items from another sheet to that Excel document in question. Doing it manually can be torture, but Microsoft spreadsheets can be a great help

To auto-complete cells using an existing list, the steps aren’t much more difficult:

  1. In an Excel document, fill in the first cell of a series
  2. Hit Enter and start typing the second entry
  3. Excel will suggest a pattern that should be the same as the list
  4. Press Enter to accept the suggestion and import the data
  5. In an instant, the data from the other sheet will be replicated here

conclusions

As you may have noticed, learning how to autocomplete Excel cells can significantly reduce your workflow. You’ll stop spending so much time on spreadsheets, and you’ll be able to take advantage of one of Office’s best features.

These are just the first steps in autocomplete in Excel, those that you should incorporate from today. Professionals and those with other concerns may consider them insufficient after a few weeks.

Do you usually autofill cells in Excel? In what situations do you resort to this option? Would you like to know more?

Write A Comment