How to Disable AutoComplete for Cell Values in Excel 2013


Excel 2013 has some features that are meant to improve the way you use the program. One of these features is called “AutoComplete”, and it will allow you to quickly fill in cell data with a previously-entered value. You can see this when you start typing data into a cell, and Excel provides a string of characters that are outlined in gray. While this can be helpful if you are repeatedly entering the same values into your cells, it can be difficult if you are entering a series of data that is slightly different.

Fortunately the AutoComplete function is not something that you need to accept, and you can turn it off entirely. Our guide below will show you where to find this setting so that you can disable it.

 

Turn Off AutoComplete for Cell Values in Excel 2013

The steps in this article will show you how to turn off the AutoComplete option for Microsoft Excel 2013. This is a program-wide setting, so it will affect every spreadsheet that you open in the program. If you decide later that you preferred to work with the AutoComplete function enabled, then simply follow these same steps to turn it back on.

 

  1. Open Microsoft Excel 2013.
  2.  

  3. Click the File tab at the top-left corner of the window.
  4. open the file menu in excel 2013

     

     

  5. Click the Options button in the column at the left side of the window.
  6. open the excel 2013 options menu

     

     

  7. Click the Advanced tab at the left side of the Excel Options window.
  8. click the advanced tab

     

     

  9. Click the box to the left of Enable AutoComplete for cell values to remove the check mark. You can then click the OK button at the bottom of the window to apply your changes and close the window.

disable autocomplete in excel 2013

 

 

Are the cells in your Excel worksheet filled with a color that makes them difficult to read, or is distracting? Learn how to remove cell fill color in Excel 2013 to adjust the way that your cell background color is displayed. If there are more formats that you need to remove from your cells, then it may be easier to just clear all of the cell formatting. This option may be preferable, as it allows you to start from scratch with unformatted data.

solveyourtech.com newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.