Home > Back-end >  Is there an option to paste the formula in Office 365?
Is there an option to paste the formula in Office 365?

Time:09-12

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)

enter image description here

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:

enter image description here

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.

  • Related