Hello all,
I have searched and searched but I have not found a thread covering this particular problem.
Historically, when I have double-clicked the lower right corner of a cell, it will automatically autofill the cells below and offer a fill handle option menu (Copy Cells, Fill Series, Fill Formatting Only, etc) so that I can change how Excel autofilled the cells, if needed. Recently (last couple of weeks or so), when I use the fill handle, that option menu is gone and has been replaced by the Quick Analysis menu (Formatting, Charts, Totals, Tables, Sparklines) and I can't get the Fill handle menu back, even when I go to the Options menu to disable the Quick Analysis menu.
Please note that I have already gone to File -> Options -> Advanced to ensure that the fill handle options are enabled. Any advice would be tremendously appreciated. Thank you!
I have searched and searched but I have not found a thread covering this particular problem.
Historically, when I have double-clicked the lower right corner of a cell, it will automatically autofill the cells below and offer a fill handle option menu (Copy Cells, Fill Series, Fill Formatting Only, etc) so that I can change how Excel autofilled the cells, if needed. Recently (last couple of weeks or so), when I use the fill handle, that option menu is gone and has been replaced by the Quick Analysis menu (Formatting, Charts, Totals, Tables, Sparklines) and I can't get the Fill handle menu back, even when I go to the Options menu to disable the Quick Analysis menu.
Please note that I have already gone to File -> Options -> Advanced to ensure that the fill handle options are enabled. Any advice would be tremendously appreciated. Thank you!