Hello, I have a matrix of numbers, each in a separate cell, now I need to do a correction to these numbers, i.e. add some constant value to all of them. How to do it?

The easiest way is to save a new one 1. select a range equal to the source in a different place on the sheet or on a different sheet 2. write = 3.Select the source range 4. enter by how much is to be increased. For example +2 5.confirm with Ctrl + Shift + Enter (array formula) 6. Ctrl + c (copy) 7. Ctrl + Alt + v (paste special), select: 'values' 8. copy and paste in place of old

Good evening, You can also like this: 1) enter into an empty sheet cell what is to be added and copy it to the clipboard (e.g. Ctrl + C) 2) select the range to which we want to add something 3) choose Paste / Paste Special / Add from the menu - the results will be constants, not formulas. Regards

Hello, that's what i did, but thought there was a pre-built function for that. greetings

How to Add a Constant Value to Multiple Cells in Excel 2007?

konrad_gom 21474 4

Treść została przetłumaczona

Zobacz oryginalną wersję tematu

Reply | New topic

#1 13952535 11 Sep 2014 18:25

konrad_gom konrad_gom

Level 18

» |

Post #1
13952535 11 Sep 2014 18:25

Hello,
I have a matrix of numbers, each in a separate cell, now I need to do a correction to these numbers, i.e. add some constant value to all of them. How to do it?
ADVERTISEMENT
Helpful post

#2 13952597 11 Sep 2014 18:47

adamas_nt adamas_nt

Moderator of Programming

» | Helpful post? (+5)

Helpful post
Post #2
13952597 11 Sep 2014 18:47

The easiest way is to save a new one

1. select a range equal to the source in a different place on the sheet or on a different sheet
2. write "="
3.Select the source range
4. enter by how much is to be increased. For example "+2"
5.confirm with Ctrl + Shift + Enter (array formula)

6. Ctrl + c (copy)
7. Ctrl + Alt + v (paste special), select: 'values'
8. copy and paste in place of "old"
ADVERTISEMENT
#3 13952727 11 Sep 2014 19:26

konrad_gom konrad_gom

Level 18

» | Topic author Helpful post? (0)

Post #3
13952727 11 Sep 2014 19:26

Hello,
that's what i did, but thought there was a pre-built function for that.
greetings
ADVERTISEMENT
Helpful post

#4 13956306 13 Sep 2014 02:16

Maciej Gonet Maciej Gonet

VBA, Excel specialist

» | Positive voted Helpful post? (+9)

Helpful post
Post #4
13956306 13 Sep 2014 02:16

Good evening,
You can also like this:
1) enter into an empty sheet cell what is to be added and copy it to the clipboard (e.g. Ctrl + C)
2) select the range to which we want to add something
3) choose Paste / Paste Special / Add from the menu - the results will be constants, not formulas.
Regards
#5 13964105 15 Sep 2014 22:56

konrad_gom konrad_gom

Level 18

» | Topic author Helpful post? (0)

Post #5
13964105 15 Sep 2014 22:56

Subject solved. Thank you.
Create an account, log in and become active in a forum and ads will not appear. You will receive points by participating in discussions.
Join this discussion.

Install the application

Didn't find an answer? Ask Artificial Intelligence

*I agree to send the question to OpenAI, Anthropic PBC, Perplexity AI, Inc., Kagi Inc., Google LLC - owners of language models in order to prepare the best response. The companies may monitor and log information entered into the form.

*I agree to publicly display my question and answer. The question and answer will be publicly available to everyone. The process may take a few minutes. Upon completion, you will be redirected to the page with the answer.

Wait...(2min)

Reply | New topic

Report a violation of the law

Home page
/
Forum
/
Computer Service
/
Computer Software
/
How to Add a Constant Value to Multiple Cells in Excel 2007?

How to Add a Constant Value to Multiple Cells in Excel 2007?

Didn't find an answer? Ask Artificial Intelligence