how to excel in each cell of data at the same time multiplied by a number of

how to excel in each cell of data at the same time a number of times?
For example:A1, A2, A3, A4, B1, B2, B3, B4 at the same time there's value multiplied by 7 to generate new value.

in any cell with input 7, then copy and then selected a few of these, and then paste – Paste Special – by, Identified.Select the region:C1:D4
enter:
=
select A1:B4
enter * 7
press ctrl + shift + enter
generating array.To show all the product , In C1:D4 years.If you want to take the results also showed that in the region to do so:
first in a blank input Negri 7, and then copied, and then select all the data right to choose And paste, computing the column below the election “by”, OK.
Delete input to the 7.OK to copy the formula.A1, A2, A3, A4, B1, B2, B3, B4 at the same time there's value Multiplied by 7

directly deposited on the function of the line

in the blank cells by the same A1 * 7 return, it can