» Multiplying a Range by -1 in One Operation
CATEGORY - Working with Formulas
VERSION - All Microsoft Excel Versions
To multiply a range of numbers by -1: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:
- Absolute Beginner's Guide to Microsoft Office Excel 2003
- Microsoft Excel 2002 Formulas (With CD-ROM)
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- The New Financial Order: Risk in the Twenty-First Century
- Adventure Capitalist: The Ultimate Road Trip
- Absolute Beginner's Guide to Microsoft Excel 2002
No comments have been submitted.
