excel formulas

  • Thread starter Thread starter Brian B
  • Start date Start date
B

Brian B

I am trying to multiply a row of cells by the same number without making an
additional row with the results. For example:
10
10
10
10
10

All multilplied by3%, thus displaying:
..03
..03
..03
..03
..03

Any way to make this happen without creating an additional row? Can I keep
the original data part of the formula?

Hope this makes sense...THX!
 
put .03 in an empty cell
Copy the cell
Select the cells you want to multiply
Use Edit-Paste Special - Multiply
 
You can do it in one operation, but this will permanently change the
value in those cells as it does not use a formula.

Choose a blank cell somewhere and enter 3% (or 0.03) into the cell.
Select the cell again and click <copy>. Then move the cursor to
highlight the cells you want to change, then click Edit | Paste
Special | Multiply (check) | OK then <Esc>.

Then you can delete the contents of the original cell.

Hope this helps.

Pete
 
In some blank cell enter 0.03 (or 3%, as you like)
Copy this cell
Select the row (or column) of numbers to be fixed
Use Edit | Paste Special and put a check in the Multiply box
Now you can delete the 3% in the first cell
best wishes
 
Try this...

Enter 0.03 in a cell
Copy that cell: Edit>Copy
Select the range of numbers you want to change
Then: Edit>Paste Special>Multiply>OK
Delete the 0.03
 
Back
Top