# [Resolved] Calculate a column of numbers

Discussion in 'Business Applications' started by blueboy75, Sep 24, 2003.

Not open for further replies.

Joined:
Nov 22, 2002
Messages:
78
I have an excel spreadsheet and in 1 column i have a few numbers, (i say a few in fact there are hundreds), now i need to increase all these numbers by 10%

is there anyway i can do this without doing the numbers individually

2. ### RandyG

Joined:
Jun 26, 2000
Messages:
7,762
I would do it by using a formula in another column.

say you have 10 in cell a1, well in b1 I would have =a1*1.1

then I would copy that formula to all the rows in that colum corresponding to the amount of rows you have in your original column. that will give you the increase of 10%.

Next couple the entire colum and the Paste Special, Values in the original colum.

done.

3. ### CastleHeart

Joined:
May 4, 2002
Messages:
743
Go to the column next to it - say D
in D1 enter = C1*1.10 and exit the cell

Go to the bottom corner of that cell till you get the + sign
Click and drag down to copy the formulas

If you want these numbers in the original cells simply click the "D" column heading and copy the column - Then click the "C" column heading and PASTE SPECIAL\ VALUES .

(If the hole column isn't involved then just copy and paste a selection. If there is no vacant column next to C to work with, go to a blank column or insert one next to C and then remove it when you're done)

- C

4. ### XL Guru

Joined:
Aug 30, 2003
Messages:
2,702
>> is there anyway i can do this without
>> doing the numbers individually

For sure. Put 1.1 in a free cell (another sheet if necessary) and copy it.

Select the range to be increased, then Edit -- Paste Special -- Multiply -- OK.

Rgds,
Andy

5. ### RandyG

Joined:
Jun 26, 2000
Messages:
7,762
cool,, much handier!!

6. ### CastleHeart

Joined:
May 4, 2002
Messages:
743
Most efficient XLG

7. ### XL Guru

Joined:
Aug 30, 2003
Messages:
2,702
Cheers guys. Hey CH, glad to see you're acquainted with the Fill Handle. Didya know you can doubleclick it to fill down as far as there's data in the neighbouring column?

,
Andy

8. ### RandyG

Joined:
Jun 26, 2000
Messages:
7,762
I didn't know it!! Cool!

9. ### CastleHeart

Joined:
May 4, 2002
Messages:
743
I think I did!
But it seems that I have the Clear History setting in my brain set to a shorter time period right now and that knowledge may have been deleted!

Actually ... I have double clicked the handle of a cell to copy a formula down THAT column as far as there is data. But never done the 'neighboring cell' thing.

- C

10. ### Anne Troy

Joined:
Feb 14, 1999
Messages:
11,746
First Name:
Anne
"I didn't know it!! Cool!"

Randy!!?? I thought I taught you better!!

11. ### CastleHeart

Joined:
May 4, 2002
Messages:
743
Say...I'm not getting any thread notification Emails. Is it down or did I do something I shunta ?

- C

12. ### Anne Troy

Joined:
Feb 14, 1999
Messages:
11,746
First Name:
Anne
Prolly dun sumpin ewe shunta.

13. ### RandyG

Joined:
Jun 26, 2000
Messages:
7,762
doubl-clicking the little plus dealie bob?? Jeez!! Now I hafta know everthing, huh??

14. ### Anne Troy

Joined:
Feb 14, 1999
Messages:
11,746
First Name:
Anne
Get it straight. It's not "the little plus dealie bob", it's "the blob in the bottom, right corner of the cell"

Oh...and when you copy a cell, the thing that goes around it is called a marquee, and NOT marching ants!

15. ### XL Guru

Joined:
Aug 30, 2003
Messages:
2,702
>> the thing that goes around it is called a marquee,
>> and NOT marching ants!

Excuse me DB? Word 2K? Format -- Font -- Text Effects -- Animations?

,
Andy

As Seen On