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.
- Open Microsoft Excel 2013.
- Click the File tab at the top-left corner of the window.
- Click the Options button in the column at the left side of the window.
- Click the Advanced tab at the left side of the Excel Options window.
- 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.
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.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.