If you have tried to move a cell from one sheet to another sheet by dragging it to the Sheet tab, you would be frustrated it just keeps you (going) DOWN. 😛
Alternatively, you may need a new window displaying the other sheet. Then moving cell by drag and drop is easy. However, to make a new window and then arrange the two windows is quite tedious for a simple task like this.
(For how to arrange two different sheets of the same workbook side by side, please visit HERE.)
The key for this trick is Alt. 🙂 Simply hold Alt key when you move to the tab of Sheet2.
How do I know this? Please pay attention to the hint that appears on the leftmost of the status bar when you click on the border of a cell. You will see “Drag to move cell content, use Alt key to switch sheets”.
Hints are all around on Excel itself, waiting for us to discover!
Honestly, I would prefer Ctrl+X (cut) and Ctrl+V (paste) for such action to using mouse’s drag and drop.