» Multiplying a Range by -1 in One Operation
CATEGORY - Working with Formulas
VERSION - All Microsoft Excel Versions
1. In any cell, type -1.
2. Select the cell and press Ctrl+C to copy.
3. Select the range to be multiplied by -1.
4. Press Shift+F10 or right-click, and then select Paste Special from the shortcut menu.
5. Select the Multiply option button, and then click OK.
Note: *-1 and parentheses are added in any cell with a formula.
Book Store:
Recommended Books:
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- Windows XP All-in-One Desk Reference For Dummies
- Business Analysis with Microsoft Excel (2nd Edition)
- Microsoft Windows XP Inside Out
- Definitive Guide to Excel VBA
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
No comments have been submitted.
