Ask Your Question
0

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

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
0

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

Comments

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

Stats

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

Seen: 6,908 times

Last updated: Oct 02 '13