Double-clicking Fill Handle to copy cells loses undisplayed data

[vconfused]

If I enter a date and a time into a cell that is only displaying the date and use either Ctrl+C / Ctrl+V or drag the Fill Handle with the right-mouse button and then choose Copy Cells, the original cell is duplicated with the full date and time. However, if I highlight a copy of these cells and simply double-click on the Fill Handle, to fill down, I lose the "hidden" time and am left only with the date. Double-clicking the Fill Handle is time-saving when dealing with a lot of rows.

Is this a "feature"? Is there anyway to get the cells to actually copy when double-clicking the Fill Handle?

Using Excel 2016 and 2013.

 

[Beyond_avarice]

It sounds you like you have a filter on. Double clicking acts on the last cell with data and stops at that point. If you have filtered row, then it treats those rows as though have no data and stops at the last unfiltered row.