mini drop down auto fill

Pablo2000 · #1 03-25-2024, 04:43 AM

This is what is happening. I edit an excel sheet and get a pop up miniture drop down box labeled Auto fill option. The drop down has
(.) Copy Cells
(.) Fill Series
(.) Fill formatting only
(.)Fill without formatting
(.) Flash fill.

Attached JPG.

ArviLaanemets · #2 03-27-2024, 03:50 AM

Quote:

Originally Posted by Pablo2000

This is what is happening. I edit an excel sheet and get a pop up miniture drop down box labeled Auto fill option. The drop down has
(.) Copy Cells
(.) Fill Series
(.) Fill formatting only
(.)Fill without formatting
(.) Flash fill.

This is not a bug, this is newer versions of Excel trying "to be helpful"!

You are lucky it is asking you at all, instead of deciding for you!

I have had a cases, when filling the column with values, which were repeating some earlier entries sometimes, and when I was not following closely what Excel was messaging there, the whole column was filled with some nonsense.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
auto fill up	mare1984	Word	1	06-27-2019 08:09 PM
fill in a drop-down list with filenames	thuriel	Word VBA	12	11-15-2018 02:35 PM
Auto Fill Forms	pgilbert0824	Excel	2	10-30-2016 01:02 AM
Populate Word Drop-down list with Excel column then auto fill form fields with Excel data	Faldinio	Word VBA	7	10-19-2014 06:03 AM
Help, auto select drop down by another drop down value?	skrallemand	Word VBA	3	09-11-2013 11:55 AM