Question

_option pastes the value in steat of the copied formula​

Answer 1

Answer:

By default when you copy (or cut) and paste in Excel, everything in the source cell or range - data, formatting, formulas, validation, comments - is pasted to the destination cell(s). This is what happens when you press CTRL+V to paste. Since that might not be what you want, you have many other paste options, depending on what you copy.

For example, you might want to paste the contents of a cell but not its formatting. Or maybe you want to transpose the pasted data from rows to columns. Or, you might need to paste the result of a formula instead of the formula itself.

Explanation:

I hope this will help you

Answer 2

Answer:

......................................jwubwjwjaiakak