Multiply the values in the copy area to the values in the paste area.
Continue reading “Excel Mac 2016 – Paste Special – Multiply”
Advertisements
Tag: Excel Mac
Excel Mac 2016 – Frequently used shortcuts
| To do this | Press |
| Paste |  + Vor CONTROL + V |
| Copy | + C or CONTROL + C |
| Clear | DELETE |
| Save | + S or CONTROL + S |
| Undo | + Z or CONTROL + Z |
| Redo | + Y or CONTROL + Y or + SHIFT+ Z |
| Cut | + X or CONTROL + X |
| Bold | + B or CONTROL + B |
| + P or CONTROL + P |
|
| Open Visual Basic | OPTION + F11 |
| Fill Down | + D or CONTROL + D |
| Fill Right | + R or CONTROL + R |
| Insert cells | CONTROL + SHIFT + = |
| Delete cells | + HYPHEN or CONTROL + HYPHEN |
| Calculate all open workbooks | + = or F9 |
| Close window | + W or CONTROL + W |
| Quit Excel | + Q |
| Display the Go To dialog box | CONTROL + G or F5 |
| Display the Format Cells dialog box | + 1 or CONTROL + 1 |
| Display the Replace dialog box | CONTROL + H or + SHIFT + H |
| Paste Special | + CONTROL + V or CONTROL + OPTION + V or + OPTION + V |
| Underline | + U |
| Italic | + I or CONTROL + I |
| New blank workbook | + N or CONTROL + N |
| New workbook from template | + SHIFT + P |
| Display the Save As dialog box | + SHIFT + S or F12 |
| Display the Help window | F1 or + / |
| Select All | + A or + SHIFT + SPACEBAR |
| Add or remove a filter | + SHIFT + F or CONTROL + SHIFT + L |
| Minimize or maximize the ribbon tabs | + OPTION + R |
| Display the Open dialog box | + O or CONTROL + O |
| Check spelling | F7 |
| Open the thesaurus | SHIFT + F7 |
| Display the Formula Builder | SHIFT + F3 |
| Open the Define Name dialog box | + F3 |
| Open the Create names dialog box | + SHIFT + F3 |
| Insert a new sheet * | SHIFT + F11 |
| + P or CONTROL + P |
|
| Print preview | + P or CONTROL + P |
Excel Mac 2016 – Paste Special – Add
Add the values in the copy area to the values in the paste area.
