If handle is there, but can’t copy.
1.Try the autofill handle and drag the data. Now you can drag it to column side or row side.
2. Try updating the Windows, or Excel to the latest version to set it.
3. Try the copy paste in other applications.
4. Check if all these three options are selected or not.
Go to FILE >ADVANCED>EDITING OPTIONS

SHOW, PASTE OPTIONS BUTTON WHEN CONTENT I SPASTE
SHOW INSERT OPTIONS BUTTONS
CUT, COPY AND SORT INSERTED OBJECTS WITH THEIR PARENT CELLS