HOW DO I APPLY A FORMULA FOR AND ENTIRE ROW?

J

jcpayne

I am trying to enter a formula to calculate an entire row.

example: i want to take the total in each cell and multiple it by a new price.
 
A

a7n9

If you're saying there are numbers from cell A1 to A10 and you want to
multiply each cell by let's say 10, then a single formula won't do it.
But you could drag the formula that would automatically calculate the
expected formula.
 
G

Gord Dibben

Enter your new price in an empty cell.

Copy that cell.

Select the date range and Paste Special>Multiply>OK>Esc.

Delete the contents of the new price cell.


Gord Dibben MS Excel MVP
 
Top