The Auto Fill feature in Microsoft Excel 2010 is very useful when you need to fill a series of cells with a series of numbers. In fact, it can be a real time-saver when you need to number rows in a spreadsheet.
But the Auto Fill feature often includes a pop-up Auto Fill Options button that can be a bit of an annoyance, and can even make it difficult to view data in some of your cells. Our guide below will show you the setting to change so that you can disable this Auto Fill Options button in Excel 2010.
Stop the Auto Fill Options Button from Appearing in Excel 2010
The steps in this article are going to stop the Auto Fill Options button from appearing while you are working in Excel 2010. The button that we are talking about is the one shown in the picture below. Note that making the change outlined in the steps below will also stop the Paste Options button from appearing as well.
- Open Excel 2010.
- Click the File tab at the top-left corner of the window.
- Click Options in the column at the left side of the window.
- Click the Advanced tab at the left side of the Excel Options window.
- Scroll down to the Cut, copy and paste section of the menu, click the box to the left of Show Paste Options button when pasted to remove the check mark, then click the OK button at the bottom of the window to apply your changes.
As mentioned previously, this is going to disable both the Auto Fill Options button and the Paste Options buttons.
Do you have an Excel worksheet where you need to make all of your rows the same height, but you don’t want to set individual row heights for every row in the spreadsheet? Learn how to apply the same row height to multiple rows in Excel 2010 and save yourself some time and frustration.
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.