Not able to drag the color-coded border to change cell in formula

[cathrinevonhaven]

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

[#2]

@cathrinevonhaven 

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!

[#3]

@Martin_Angosto Thank you so much! That worked and you made my day 🙂

[#4]

@cathrinevonhaven 

Glad it worked! You're welcome