How to Turn on Autocomplete in Excel (3 Easy Ways)

In MS Excel, users often need to enter a lot of data. Entering each data manually is a laborious task. The autocomplete feature of Excel lessens their labor. In this article, we will show how to turn on autocomplete in Excel.


Download Practice Workbook

You can download the practice workbook from here.


3 Easy Ways to Turn On Autocomplete in Excel

In this article, we will discuss 3 easy ways to turn on autocomplete in Excel. Firstly, we will talk about turning on autocomplete feature for cell values. Secondly, we will turn on autocomplete feature for formulas. Finally, we will use the Pick From Drop-down List command to autocomplete.


1. Turn On Autocomplete for Cell Values

In this method, we will turn on autocomplete cell values. This will allow us to complete the cell values automatically.

Steps:

  • Firstly, go to the File tab.

go to the file tab to turn on autocomplete

  • Then, select the Options option from the menu.

  • In the Excel Options window, first, select the Advanced option.
  • Then from the Editing options, select the Enable Autocomplete for cell values box.
  • Finally, click OK.

checking the autocomplete box to turn on autocomplete

  • As a result, when we will type M in the C10 cell, Excel will autocomplete as Marketing.

turn on autocomplete for cell values

Read More: How to Autocomplete Cells or Columns From List in Excel


2. Turn On Autocomplete for Formulas

In this instance, we will turn on autocomplete for formulas. This will enable us to complete the formulas automatically.

Steps:

  • Firstly, select the File tab from the ribbon.

  • Then, choose the Options option from the menu.

  • In the Excel Options window, first, select the Formulas option.
  • Then from the Working with formulas section, select the Formula Autocomplete box.
  • Finally, click OK.

checking formula autocomplete box to turn on autocomplete

  • As a result, when we will type SU in the D11 cell, Excel will show autocomplete formulas.

turn on autocomplete for formulas

Read More: How to Use AutoComplete in Excel (4 Easy Ways)


3. Using Pick From Drop-down List Command

In this example, we will use the Pick From Drop-down List command to get the job done.

Steps:

  • Firstly, select the C10 cell and right-click.
  • Then, from the available options, select the Pick From Drop-down List option.

applying pick from drop down list command to turn on autocomplete

  • Consequently, Excel will automatically show the available data options in that cell relative to the column.

Read More: Autocomplete Data Validation Drop Down List in Excel (2 Methods)


How to Autocomplete for Formulas Using Keyboard Shortcuts

We often use double-click to autofill the entire column according to a formula. This is a bit time-consuming. In this method, we will use simple keyboard shortcuts to autocomplete formulas in a column.

Steps:

  • Firstly, choose the E5 cell and write down the formula you need.
  • In our case, the formula is,
=D5*C5
  • Then, hit Enter.

  • As a result, we will get the result for that cell.
  • Then, press Shift+Down Arrow to select each cell in the column.

  • After that, press Ctrl+D.
  • As a result, the formula will be copied down to the last data cell.


Conclusion

The Excel autocomplete feature saves a lot of time and effort for users. After going through this article, they will have a clear understanding of how to turn on the autocomplete feature in Excel. If you find it useful, please let us know in the comment section below and share any recommendations and thoughts regarding this or any other content of ours. Thank you for your time. Follow ExcelDemy.com for more articles like this.


Related Articles

Adnan Masruf

Adnan Masruf

I am an engineering graduate. I graduated from Bangladesh University of Engineering and Technology(BUET), one of the top universities in Bangladesh from department of Naval Architecture & Marine Engineering with a major in structure. I am an avid reader of fiction especially fantasy. I also keep myself abreast of the recent developments in science and technology. I believe diligence will eventually pay off and luck tends to favor those who work hard.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo