Hi,

this must be a basic question, but to my surprise I did not find an answer to it just by browsing the web.
Sorry if it is indeed explained elsewhere, but my problem is:

By dragging the formulas written in one or multiple cells via the cross-handle in the right bottom corner of the selection is of course very nice and know feature.
But unfortunately it copies not only the formula but the cell formatting (border or fill) as well, which is really annoying.
Actually I have this problem since years, but I don't need to use Excel so frequently.

I realized how to avoid that by "Paste Special" but that's just so much more inconvenient than dragging.
Sorry again if it's FAQ, but is there any way to set up this drag feature (or, actually normal copy+paste too) to copy only formulas?
I have not find anything in Settings.

I'm using Excel for Mac, 14.0.0

Thank you for your help in advance!