## Excel multiply formula shortcut

If you want to do multiplication in Excel, you can use the * (asterisk), PRODUCT function and SUMPRODUCT function, but you can also use the shortcut keys or Access key to do multiplication. If you don’t want to enter the formula every time, or if you want to perform multiplication easily, try the following method.

### Multiply formula shortcut

Windows**Ctrl** + **Alt** + **V**

Access Key: **Alt** + **E** + **S**

Mac**option** + **command** + **V** or **option** + **control** + **V** or **control** + **command** + **V**

### Multiply using shortcut keys

Learn how to use shortcut keys and access keys to multiply without creating a multiplication expression. This time, we will multiply the price by the quantity to get the total amount.

Total Time: 1 minute

#### Enter a price

Enter a price in the cell where you want the amount to appear.

#### Copy the value of the quantity

Press **Ctrl** + **C** to copy the quantity.

#### Paste with shortcut keys

Paste the copied quantity into the cells of the amount. Press **Ctrl** + **Alt** + **V** or **Alt** + **E** + **S**.

#### Select multiply

The Paste Special dialog box will appear. Press **M**, and press **Enter**.

#### Multiplication complete

The amount has been calculated.

#### Set the Accounting Number Format

Press **Alt** + **H** + **A** + **N** to open the Accounting Number Format. Use **↓** (Down Arrow key) to select **$ English** and press **Enter** to set the currency unit.