[Fixed!] Auto Fill Options Not Showing in Excel

Get FREE Advanced Excel Exercises with Solutions!

The Auto Fill Feature is a very handy tool when it comes to automatically detecting a pattern or series and filling the rest of the cells in a column or row maintaining the pattern or series. But sometimes it can happen that Auto Fill options not showing in Excel. In this article, I will show you an easy solution to this problem with very straightforward steps.


Step-by-Step Procedures to Solve If Auto Fill Options Are Not Showing in Excel

In this section, we will try to fix the issue of the Auto Fill option not showing in Excel. But before looking into the solutions, let’s see what the problem looks like. In Excel, when you use the Fill Handle, you are supposed to see the Autofill option just below the filled-up cells. (see the example below.)

Here, we can see the Auto Fill option that has many options such as Copy Cells, Fill Series, Fill Formatting Only, Fill Without Formatting, and Flash Fill. But, sometimes you may find that this Auto Fill option is not showing. (like the illustration below)

excel auto fill options not showing

This time, we can only see the Quick Analysis Tool, but the Auto Fill option has disappeared. Now, to make this vanished Auto Fill Option appear again, we can follow the easy 4 steps below.


Step 01: Go to File Tab

  • From the ribbon, click on the File tab.

excel auto fill options not showing


Step 02: Click on Options

  • From the appeared menu on the left side of the screen, click on Options.

Read more: How to AutoFill from List in Excel


Step 03: Choose the Advanced Option

  • By clicking on Options, a dialogue box should appear.
  • From the menu, click on the Advanced option.

excel auto fill options not showing

Read More: How to Use Autofill Formula in Excel 


Step 04: Enable the Show Paste Options Button When Content Is Pasted

  • On the Advanced option, scroll down below until you see this option.

excel auto fill options not showing

  • Now, check the ‘Show Paste Options button when content is pasted‘ option and click OK.

excel auto fill options not showing

Hopefully, it will solve your problem.


How to Solve If AutoFill of Series Is Not Working While Dragging Only Last Cell

Like the example given above, sometimes, we may have data only on 2 cells in a column and we want to fill up the rest of the cells with Autofill. See the example below.

But we want to Autofill the remaining cells so that the rest of the cells are filled by 15, 20, 25, and so on. But if you try to drag the Fill Handle by selecting only B6, you will get the following result.

Autofill of Series Not Working While Dragging Only Last Cell

You will only get 10 in all those cells. To get a proper arithmetic series, we have to select the range of cells available in the column first. In our example, they are B5 and B6. After selecting the cells, we have to use the Fill Handle option from Cell B6 to drag down to the last Cell B10.

Autofill of Series Not Working While Dragging Only Last Cell

Thus we will be able to get the proper series (5,10,15,20….)

Read More: [Fixed!] AutoFill Formula Is Not Working in Excel Table


Things to Remember

  • You can always use the Fill Option on the ribbon under the Editing group in the Home tab to manually do the task done by AutoFill.

Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


Conclusion

That is the end of this article. If you find this article helpful in solving the problem when the Auto Fill options not showing in Excel. then please share this with your friends. Moreover, do let us know if you have any further queries.


Related Articles


<< Go Back to Excel Autofill not WorkingExcel Autofill | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Aniruddah Alam
Aniruddah Alam

Md. Aniruddah Alam, a graduate of Bangladesh University of Engineering & Technology, Dhaka, holds a BSc.Engg in Naval Architecture & Marine Engineering. Joining Softeko in August 2022 as an Excel and VBA content developer, he has authored 90+ articles, covering fundamental to advanced Excel topics. He actively develops VBA codes for Excel automation and offers solutions in the Exceldemy Forum. Beyond work, he finds leisure in reading books, and taking relaxing walks, showcasing well-rounded blend of professional and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo