Computer Forums Anyone with knowledge of MS Excel...

 01-09-2007, 11:54 AM #1 Baseband Member   Join Date: Jan 2007 Posts: 66 Anyone with knowledge of MS Excel... I would like to change a whole bunch of cells, in a 64 x 11 rectangle. The values in each cell are dollar amounts, and I would like to increase each of these values by 5%. That is, if a dollar amount is \$1325.00, and increase in 5% would have it equal \$1391.25. Is there a very fast way to do this? __________________ __________________
01-09-2007, 12:05 PM   #2
Daemon Poster

Join Date: Oct 2006
Posts: 806
Re: Anyone with knowledge of MS Excel...

Quote:
 Originally Posted by wally222 I would like to change a whole bunch of cells, in a 64 x 11 rectangle. The values in each cell are dollar amounts, and I would like to increase each of these values by 5%. That is, if a dollar amount is \$1325.00, and increase in 5% would have it equal \$1391.25. Is there a very fast way to do this?
you could write a macro to do it...ill make a quick one and post it just tell me the range of cells like A1 to like J11 or something

ill write a macro or something that does that......or you could make a new box at the bottem

and write something like this: =A1 * 1.05
then drag that equation system over and down then cut that and paste special
the values in the top boxes to replace them...either way let me know
__________________

__________________
New Desktop: Core i7 860, EVGA P55 SLI, 2x PNY GTX260s in SLI, Antec Quattro 1kW PSU,4GB XMS3 DDR3-1600, Antec 300 Case, 2xSeagate 500GB, 1TB Samsung
Old Desktop: Intel E8400, Seagate 7200.11 500GB HDD, 320GB WD, 250GB Seagate, Asus 9800GTX+,4GB Corsair Ballistix, Asus P5Q Pro, Antec 500W PSU, 2 19" WS
Laptop: HP dv4-1155se
Car~07 Mazda 3s 5spd 2.3L: Simota CAI, Borla Cat-Back, Cat Delete, Lower Engine Mount, 1.5" Drop...and more...haha

 01-09-2007, 12:08 PM #3 Baseband Member   Join Date: Jan 2007 Posts: 66 Re: Anyone with knowledge of MS Excel... It is a rectangle with cell dimensions of M8 x W69 __________________
01-09-2007, 12:09 PM   #4
Daemon Poster

Join Date: Oct 2006
Posts: 806
Re: Anyone with knowledge of MS Excel...

Quote:
 Originally Posted by wally222 It is a rectangle with cell dimensions of M8 x W69
try that second method I said
__________________
New Desktop: Core i7 860, EVGA P55 SLI, 2x PNY GTX260s in SLI, Antec Quattro 1kW PSU,4GB XMS3 DDR3-1600, Antec 300 Case, 2xSeagate 500GB, 1TB Samsung
Old Desktop: Intel E8400, Seagate 7200.11 500GB HDD, 320GB WD, 250GB Seagate, Asus 9800GTX+,4GB Corsair Ballistix, Asus P5Q Pro, Antec 500W PSU, 2 19" WS
Laptop: HP dv4-1155se
Car~07 Mazda 3s 5spd 2.3L: Simota CAI, Borla Cat-Back, Cat Delete, Lower Engine Mount, 1.5" Drop...and more...haha

 01-09-2007, 12:11 PM #5 Baseband Member   Join Date: Jan 2007 Posts: 66 Re: Anyone with knowledge of MS Excel... I tried that earlier on, however when I cut and paste them where the original boxes were, I get an error because it is those original boxes that I'm referencing in the equation. Hence my problem... __________________
01-09-2007, 12:30 PM   #6
Daemon Poster

Join Date: Oct 2006
Posts: 806
Re: Anyone with knowledge of MS Excel...

Quote:
 Originally Posted by wally222 I tried that earlier on, however when I cut and paste them where the original boxes were, I get an error because it is those original boxes that I'm referencing in the equation. Hence my problem...
use the paste special command...it should be right under past when you right click
__________________
New Desktop: Core i7 860, EVGA P55 SLI, 2x PNY GTX260s in SLI, Antec Quattro 1kW PSU,4GB XMS3 DDR3-1600, Antec 300 Case, 2xSeagate 500GB, 1TB Samsung
Old Desktop: Intel E8400, Seagate 7200.11 500GB HDD, 320GB WD, 250GB Seagate, Asus 9800GTX+,4GB Corsair Ballistix, Asus P5Q Pro, Antec 500W PSU, 2 19" WS
Laptop: HP dv4-1155se
Car~07 Mazda 3s 5spd 2.3L: Simota CAI, Borla Cat-Back, Cat Delete, Lower Engine Mount, 1.5" Drop...and more...haha

 01-09-2007, 12:39 PM #7 Baseband Member   Join Date: Jan 2007 Posts: 66 Re: Anyone with knowledge of MS Excel... Thank you very much __________________
 01-09-2007, 12:51 PM #8 Daemon Poster     Join Date: Oct 2006 Posts: 806 Re: Anyone with knowledge of MS Excel... np __________________ __________________ New Desktop: Core i7 860, EVGA P55 SLI, 2x PNY GTX260s in SLI, Antec Quattro 1kW PSU,4GB XMS3 DDR3-1600, Antec 300 Case, 2xSeagate 500GB, 1TB Samsung Old Desktop: Intel E8400, Seagate 7200.11 500GB HDD, 320GB WD, 250GB Seagate, Asus 9800GTX+,4GB Corsair Ballistix, Asus P5Q Pro, Antec 500W PSU, 2 19" WS Laptop: HP dv4-1155se Car~07 Mazda 3s 5spd 2.3L: Simota CAI, Borla Cat-Back, Cat Delete, Lower Engine Mount, 1.5" Drop...and more...haha