What's the quickest way to multiply multiple cells by another number?

vba excel excel-formula
jonty picture jonty · May 1, 2009 · Viewed 243.9k times · Source

If I have a block of cells such as A1:D5, what's the quickest way of multiplying each cell by another number, 1.1 using Microsoft Excel?

Answer

Joel Spolsky picture Joel Spolsky · May 1, 2009
  1. Enter the multiplier in a cell
  2. Copy that cell to the clipboard
  3. Select the range you want to multiply by the multiplier

  4. (Excel 2003 or earlier) Choose Edit | Paste Special | Multiply

    (Excel 2007 or later) Click on the Paste down arrow | Paste Special | Multiply

Related questions

Excel how to find values in 1 column exist in the range of values in another

I have two columns- column A which extends upto 11027(values) and column I which extends to 42000(values).Both the columns contains some code details. Something like this A B q123 as124 as124 gh456 ff45 q123 dd1 dd2 xx2 xx3 xx4 …

Read More
How can I color dots in a xy scatterplot according to column value?

Consider the following worksheet: A B C D 1 COMPANY XVALUE YVALUE GROUP 2 Apple 45 35 red 3 Xerox 45 38 red 4 KMart 63 50 orange 5 Exxon 53 59 green I have used the scatterplot function in Excel to create the following chart: However, each point in the chart has …

Read More
Set formula to a range of cells

this is simple demo of what i want to do. I want to set a formula to a range of cells(eg. C1 to C10). Range("C1").Formula = "=A1+B1" but how to make formula use dynamic cells like this: …

Read More