I want to add Paste Formulas, but there is no Paste Formulas option in all commands in customize the quick access Toolbar
Version 2208 Office 365
CodePudding user response:
Is this what you are looking for?
(You may have to click on the image to see it clearly in a new window)
CodePudding user response:
As mentioned in my comment, I really don't understand what's wrong with a regular paste, as you can see from this screenshot:
In cell "A2", I had put the value 36.
In cell "B2", I had put the formula =A2*A2
.
In cell "A5", I have put the value 49.
In cell "B5", I copy the content of cell "B2" into "B5", using regular "Paste", and I get the formula pasted and adapted to the other cell's coordinates.