Just for info here is another way to Paste values only ( on the same sheet) than using the right click menu

Long explanation, rapidly done

Select the range containing the formulas of which you want to keep the values

Put your cursor against the upper boundary of the selected zone -A cross appears -

Press right button of your mouse and WHILE KEEPING THE BUTTON PRESSED move the selected range to where you need the values. ( It can be the same place you started from but you have to move a little).

Release the button and a menu will pop up.

Select " Copy Here as Values Only" - Done

There are also some other interesting items in this menu

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post