Drag and fill does not work

Occasional Visitor

Hi,

The Fill Handle is option is selected and the handle present, automatic is selected, but if I select a 1-2 series and try to fill down or horizontally to get 1 to 10, or if I select the cells with letters a and b and try to get the 26 letters of the alphabet, or if I select the cells with two consecutive dates (2022/07/01 and 2022/07/02), it will not fill in the next numbers, letters or dates.

 

It will fill in the answers to formulas. Selected cell F2's drag handle and dragged it down to cell F5 and it did the correct calculations.

meta1965_0-1658362973184.png

I've used Excel from the the start, never had any problems. This is with Excel 365

meta1965_1-1658363218187.png

Please help.

Thanks

0 Replies