I've seen this question a lot but not an answer that works for me.
All of a sudden, auto fill has stopped working.
I've put A in one cell and B in the next, tried selecting both and dragging down and just the B and dragging down and tried with and without the cntrl key. I just can't get it to carry on C, D, E etc.
I've opened and closed excel
I tried on a new worksheet in a new workbook
I checked that drag and fill is selected in options
I have no hidden rows/columns
I have no filter set.
It usually works OK... what on earth is going on?
All of a sudden, auto fill has stopped working.
I've put A in one cell and B in the next, tried selecting both and dragging down and just the B and dragging down and tried with and without the cntrl key. I just can't get it to carry on C, D, E etc.
I've opened and closed excel
I tried on a new worksheet in a new workbook
I checked that drag and fill is selected in options
I have no hidden rows/columns
I have no filter set.
It usually works OK... what on earth is going on?