Earlier I was able to hold the bottom right corner of a call and was able to drag and drop it.
Now, I am, no longer, able to do it.
To solve this –
1. Go to Office Button > Excel Options > Advanced
2. Click Enable fill handle and cell drag-and-drop to mark it tick. Now, you will be able to drag and drop a cell.