Ask Your Question

how do i paste absolute values, like paste special > values

asked 2019-08-15 14:32:56 +0200

rudgeworks gravatar image

When i use a formula - how do i paste absolute values, as i would useing "paste special" > "values" in MS excel?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-08-15 14:40:17 +0200

Opaque gravatar image

updated 2019-08-15 15:39:40 +0200


  • Copy your source cell (CTRL-C or Right click - Copy)
  • Move to your target cell
  • Right click -> Paste special and make your selection what to paste (plenty of options) -- or -- use Edit -> Paste Special...

I assume this doesn't differ much from Excel.

Update - see screenshot (copying cell A3, moving to target A5 and Paste Special -> Number will add value 3 to A5

image description

edit flag offensive delete link more


There is no obvious way of pasting the resultant value of a formula - ie cell contains =a1+b1 in excel I can copy the cell and use paste special .. values to past the result of the formula ( but not the formula it’s self) or am I missing something.

rudgeworks gravatar imagerudgeworks ( 2019-08-15 14:54:12 +0200 )edit

Did you even try what I wrote - The procedure in my answer pastes the result of a formula and not the formula itself. That's why it is called Paste special as it does in Excel. Please see Update in my answer.

Opaque gravatar imageOpaque ( 2019-08-15 15:04:06 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-08-15 14:32:56 +0200

Seen: 27 times

Last updated: Aug 15