How To Drag Cell References Within Formulas - Excel 365

Hello Excel Helpers!

When my computer was updated from Excel 2010 to Office 365, I can't click into a formula and drag the reference cell to a new location anymore. I've seen that functionality still working on other people's computers with Office 365. Does anyone know where maybe there is an option menu to set it back to allow me to drag cell references again?

For example, I could drag these two cells to the appropriate columns when updating this report previously. Now I can't do that and I have to type in the new column letter into the formula. I hope this image helps.

Thanks for the help!

Keith


Formula Cell Reference.jpg

Hmm? That's pivot table that you are using as reference point (U9 & T9). I don't think pivot table allowed drag & drop of individual fields.

That's probably the cause. Try doing it on regular range and see what happens.

So what do you mean by drag? As Pivot Table does not support it. I assume you drag whatever the cell that contains =U9-T9 ?

If that's the case, check Options->Advanced. Specifically in Editing Options.

It should look like below:
0.JPG

Pinging who? The thread is open to all, and all can see any responses to it.

Your screencasts require Flash, which has been deprecated in modern browsers.

As Ali mentioned, I'm unable to open your screen grab, as I've ditched Flash player years ago.

If I understood what you describe right, it still works in Office 365.

First go into edit mode. And then go to corner of U9 cell and drag. It will adjust reference to that cell with extended range.

However, your sample is a bad example As you don't normally subtract range from range (only cell from cell).

With new Office 365 update, Excel will automatically treat it as array calculation if you subtract Range from range.
(i.e. gives array of {Range(1).Cell(1) - Range(2).Cell(1), Range(1).Cell(2) - Range(2).Cell(2)} )
See sample screenshot.

0.JPG