Forum Discussion
Not able to drag the color-coded border to change cell in formula
Hello,
Normally when I want to change a cell reference to another cell reference I double-click the cell containing the formula and drag the color-coded border to the new cell. I am no longer able to do that in excel and need to type in the name of the new cell in the formula. Really annoying. Any hints to how I can reactivate the
Hi, please go to the "File" tab on the ribbon > Options > Advanced > "Enable fill handle and cell drag-and-drop".
Check if that option is selected!
Martin_Angosto Thank you so much! That worked and you made my day 🙂
