Forum Discussion
cathrinevonhaven
Oct 01, 2024Copper Contributor
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 abl...
Martin_Angosto
Oct 01, 2024Iron Contributor
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!
- cathrinevonhavenOct 01, 2024Copper Contributor
Martin_Angosto Thank you so much! That worked and you made my day 🙂
- Martin_AngostoOct 01, 2024Iron Contributor