MrExcel Publishing
Your One Stop for Excel Tips & Solutions

add percentage to sheet

Posted by Paul Zwierzanski on September 12, 2001 11:23 AM

Hi There

Is it possible to add a percentage to ALL the numeric
data cells on a worksheet?

Thanks in advance


Posted by Tom Urtis on September 12, 2001 12:58 PM

You can enter the percentage number in a cell of your choice, copy that cell, then hilite the numeric data cells you mention, and click Edit > Paste special > select "Add" in the Operation section, and click OK.

Tom Urtis

Posted by Juan Pablo on September 12, 2001 1:00 PM

Well, i don't know if this help you, but try this...

First, in another sheet, type 100.
Second, copy this value, go to the sheet that you want, select edition - go to - special, and select constants.

Next, select edition - paste special - operation - divide.

Next, click on the "%" button on the format toolbar.

Now, again, select edition - go to - special, and select formulas and choose ONLY Numbers.

Edition - Paste special - Operation - Divide.

And click on the "%" button on the tool bar...

That should.. i think... do it.

Any help ?

Juan Pablo