Excel Hack

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

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

Copy the value of the quantity

Copy the value of the quantity

Press Ctrl + C to copy the quantity.

Paste with shortcut keys

Paste with shortcut keys

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

Select multiply

Select multiply

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

Multiplication complete

Multiplication complete

The amount has been calculated.

Set the Accounting Number Format

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.

Comments

Please send us your comments on this article.

0 comments
Inline Feedbacks
View all comments