# Quick Question

This is a discussion on Quick Question within the Excel Questions forums, part of the Question Forums category; If I have 5 numbers in a row and want to multiply them all by the same number in cell ...

1. ## Quick Question

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?

2. Copy the cell in XYZ

Highlight the cells you want to multiply by the number.

Edit | PasteSpecial | Multiply

3. ## Re: Quick Question

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.

4. ## Re: Quick Question

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

5. ## Re: Quick Question

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