If the cell above is a formula, only the value is copied.
Copy value from cell above
This shortcut copies the value in the cell above to the selected cell and leaves the cell in edit mode. If the cell above is a formula, only the value is copied.
If the cell above is a formula, only the value is copied.