Quick Question

[jmarcus16]

If I have 5 numbers in a row and want to multiply them all by the same number in cell XYZ, what is the keystroke to make a global formula insert?
Thanks in advance - Jonathan.

 

[DRJ]

Copy the cell in XYZ

Highlight the cells you want to multiply by the number.

Edit | PasteSpecial | Multiply

 

[onlyadrafter]

Hello,

Is this an example of your scenario

A1 = 1
A2 = 2
A3 = 3
A4 = 4
A5 = 5

A7 = 6

in B1 you want A1*A7
in B2 you want B1*A7

Enter the formula for B2 = A1*$A$7, put the cursor in the bottom right hand corner, until you get a black cross, and double click the mouse button.

Is this what you require or are you adamant to use keystrokes,

Put the cursor in the cell below the one with the data in and press CTRL and D together, this will only fill in the one cell though.

 

[AlohaJulio]

If you are trying to take the formula in XYZ and multiply it against all the cells in a range, make sure the cell references in the formula in XYZ are absolute (use $), copy cell XYZ, then highlight the range of cells you want multiplied then paste special>formulas>multiply

If you want the cells in the range to know have *XYZ added to them, then in a different cell, put =XYZ with absolute references, then copy that cell, highlight the range of cells you want multiplied then paste special>formulas>multiply

 

[jmarcus16]

Aloha / DRJ - Exactly what I was looking for - Thanks.

 

[DRJ]

Your very welcome