Multiplying a column by a constant problem

%3CLINGO-SUB%20id%3D%22lingo-sub-2076574%22%20slang%3D%22en-US%22%3EMultiplying%20a%20column%20by%20a%20constant%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2076574%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20inflate%20a%20series%20of%20numbers%20by%203%25%20in%20excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20doing%20this%20by%20multiplying%20by%201.03%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20applied%20this%20formula%20to%20the%20first%20cell%20in%20a%20column%20and%20have%20done%20the%20calculation.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22edimech_0-1611090613664.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F247573iD1819EE4FA63ED3E%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22edimech_0-1611090613664.png%22%20alt%3D%22edimech_0-1611090613664.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22edimech_1-1611090666045.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F247574iB6397CCD1131CEEA%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22edimech_1-1611090666045.png%22%20alt%3D%22edimech_1-1611090666045.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20is%20every%20time%20I%20try%20applying%20this%20formula%20to%20all%20the%20cells%20in%20a%20column%20it%20just%20duplicates%20the%20value%20in%20the%20first%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3EI%20have%20tried%20special%20pasting%20with%20formulas%20only.%20Doesn't%20work.%3C%2FLI%3E%3CLI%3EI%20have%20checked%20the%20Calculation%20Options%20and%20set%20it%20to%20both%20Manual%20and%20Automatic.%20Doesn't%20work.%26nbsp%3B%3C%2FLI%3E%3CLI%3EI%20have%20checked%20advanced%20options%20has%20enabled%20fill%20handle%20and%20cell%20drag%20and%20drop.%20Doesn't%20work.%3C%2FLI%3E%3C%2FUL%3E%3CP%3EThis%20is%20really%20frustrating%2C%20can%20someone%20please%20help%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2076574%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2076587%22%20slang%3D%22en-US%22%3ERe%3A%20Multiplying%20a%20column%20by%20a%20constant%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2076587%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F935227%22%20target%3D%22_blank%22%3E%40edimech%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDo%20it%20like%20this%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EEnter%201.03%20in%20an%20empty%20cell.%3C%2FLI%3E%0A%3CLI%3ESelect%20that%20cell%20and%20copy%20it.%3C%2FLI%3E%0A%3CLI%3ESelect%20the%20target%20range.%3C%2FLI%3E%0A%3CLI%3ERight-click%20in%20the%20selection%20and%20select%20Paste%20Special...%20from%20the%20context%20menu.%3C%2FLI%3E%0A%3CLI%3EAlternatively%2C%20click%20the%20lower%20half%20of%20the%20Paste%20button%20on%20the%20Home%20tab%20of%20the%20ribbon%20and%20select%20Paste%20Special...%20from%20the%20dropdown%20menu.%3C%2FLI%3E%0A%3CLI%3EClick%20Special.%3C%2FLI%3E%0A%3CLI%3ESelect%20Multiply.%3C%2FLI%3E%0A%3CLI%3EClick%20OK.%3C%2FLI%3E%0A%3CLI%3EClear%20the%20cell%20in%20which%20you%20entered%201.03.%3C%2FLI%3E%0A%3C%2FUL%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2076617%22%20slang%3D%22en-US%22%3ERe%3A%20Multiplying%20a%20column%20by%20a%20constant%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2076617%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%20that%20worked%2C%20thank%20you%20very%20much!!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi there,

 

I am trying to inflate a series of numbers by 3% in excel.

 

I am doing this by multiplying by 1.03

 

I applied this formula to the first cell in a column and have done the calculation.

edimech_0-1611090613664.pngedimech_1-1611090666045.png

 

The problem is every time I try applying this formula to all the cells in a column it just duplicates the value in the first column.

 

  • I have tried special pasting with formulas only. Doesn't work.
  • I have checked the Calculation Options and set it to both Manual and Automatic. Doesn't work. 
  • I have checked advanced options has enabled fill handle and cell drag and drop. Doesn't work.

This is really frustrating, can someone please help? 

2 Replies

@edimech 

Do it like this:

  • Enter 1.03 in an empty cell.
  • Select that cell and copy it.
  • Select the target range.
  • Right-click in the selection and select Paste Special... from the context menu.
  • Alternatively, click the lower half of the Paste button on the Home tab of the ribbon and select Paste Special... from the dropdown menu.
  • Click Special.
  • Select Multiply.
  • Click OK.
  • Clear the cell in which you entered 1.03.

@Hans Vogelaar  that worked, thank you very much!!