Ask Your Question

how do I copy numbers without the formulas?

asked 2019-03-07 18:09:50 +0200

sagereyn gravatar image

I have a spread sheet and have a row in which I have added the charges for the month. I want to take the totals for each month and add them up to get an annual total. When I copy the row of sums and put it in a summary section the subsequent line are added together to a preposterous number. How can I simply copy the values and then add them up for my annual totals?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-03-07 21:34:42 +0200

Lupp gravatar image

Are you talking of >Edit>Paste Special... -no Formulas, no Formats... ?

edit flag offensive delete link more


It's available also with right-click Paste special - Number

m.a.riosv gravatar imagem.a.riosv ( 2019-03-07 22:30:16 +0200 )edit

...and with Shift+Ctrl+V.

Lupp gravatar imageLupp ( 2019-03-07 23:49:07 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-03-07 18:09:50 +0200

Seen: 31 times

Last updated: Mar 07