My Boss had me type up an updated Price Book for our Company, which I did in
Excel. This took me over a week to do as it is many, many pages long. She
came back from a meeting yesterday & said her Boss informed her that he wants
every price in the Book increased by 5%!!!!!!!!! Somebody please tell me
there's an easy way to somehow apply a formula to the entire document that
increases each cell by 5%. If I have to address each cell individually I
think I'm going to cry!!
-Thanks

Don't worry, you can put the tissue box away.

In an empty cell type: 1.05

Now copy that cell

Next, highlight all the cells you want to increase by 5%

Now click on Edit Paste Special and in the "Operation" area choose
Multiply

Now click OK

All done, no crying. Now delete the 1.05 that you typed in that empty
cell


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=511356

THANK YOU SO MUCH!!!!!!!!!!!!! :0)

"Cutter" wrote:


Don't worry, you can put the tissue box away.

In an empty cell type: 1.05

Now copy that cell

Next, highlight all the cells you want to increase by 5%

Now click on Edit Paste Special and in the "Operation" area choose
Multiply

Now click OK

All done, no crying. Now delete the 1.05 that you typed in that empty
cell


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=511356

You're very welcome.

Tell your boss it took a long time to change all the prices and ask for
a raise.


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=511356