We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

How can I subtract 500 from all cells in a given selection in Calc? [closed]

asked 2013-10-02 15:27:48 +0200

Bastian gravatar image

updated 2020-08-05 23:47:39 +0200

Alex Kemp gravatar image

i have all these numbers: http://i.snag.gy/7irWj.jpg and I want to subtract 500 from each number. do I have to do this manually or can I get Calc to automate the process for me?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-10 10:23:08.522661

1 Answer

Sort by » oldest newest most voted

answered 2013-10-02 15:56:32 +0200

JohnSUN gravatar image

updated 2013-10-02 15:56:59 +0200

Just insert 500 in any empty cell. Copy this cell (Ctrl+C). Select all cells where you want subtract this value and press Ctrl+Shift+V. Select "Subtract" and "OK". Clear temporary cell. Subtract

edit flag offensive delete link more


Awesome, works perfectly! Thank you so much for the help!

Bastian gravatar imageBastian ( 2013-10-02 16:39:08 +0200 )edit

Question Tools

1 follower


Asked: 2013-10-02 15:27:48 +0200

Seen: 10,415 times

Last updated: Oct 02 '13