Loading Profile...
How do I add an amount to multiple cells in my spreadsheet?
Jane asked "Here's an Excel question....I'm trying to add an amount(75.00) to say, 60 different numbers, each number in an individual cell in an excel sheet. Isn't there a better way of doing it other than manually adding and typing it in?"
I’m learning too.
1
person has this question
I have this question, too!
Tell me when someone answers.
The more people who ask this question, the more it gets noticed.
The more people who ask this question, the more it gets noticed.
Create a customer community for your own organization
Plans starting at $19/month
-
Inappropriate?already asked and answered: http://getsatisfaction.com/microsoft/...
2 people say
this answers the question
2 Comments Add a comment
This answers the question
-
Thanks Bruce! -
Thanks to Bruce and Chris both! the video clip helped to simplify it:-)
-
Inappropriate?Jane,
type the number you want to multiply all the other numbers by in one cell. copy that number, select all the cells you want to multiply then choose paste/paste special and click the multiply box and then enter.
there are other ways to do this, as usual, but this should work
jeanie -
Inappropriate?Now I'm curious to hear Jane, did this help you out?1 Comment Add a comment
This answers the question
-
I couldn't use the tip about multiplying, but the clip below helped me out and answers the question.
-
Inappropriate?
In case it's not terribly clear in the video, I clicked on the cell I wanted to edit, typed "=", clicked the cell I wanted to add to, and typed "75" and hit enter. Then I dragged the corner down as explained previously to copy the formula to other columns. It automatically changes B1 to C1, D1, E1, etc...
I’m happy
1 person says
this answers the question
1 Comment Add a comment
This answers the question
-
Thanks Chris! Sure appreciate it!
EMPLOYEE
EMPLOYEE
