CATEGORY: Working with Formulas VERSIONS: 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.

Screenshot // Multiplying a Range by -1 in One Operation

Rate this tip 1 2 3 4 5   RATING: 3.54   VIEWS: 13789 Email Tip Print Tip Add to My Tips

READER COMMENTS (view all comments)

No comments have been submitted.

REGISTERED USERS - Click here to post comments GUESTS (Click here to register) Name Comment Title Comments

The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two Infectious Greed: How Deceit and Risk Corrupted the Financial Markets Now, Discover Your Strengths The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers Microsoft Access 2002 for Dummies PowerPoint® 2002 For Dummies®

RELATED MICROSOFT EXCEL TIPS

Create User Forms in Microsoft Excel Using Loops in VBA in Microsoft Excel The Best Shortcut Keys in Microsoft Excel Writing Your First VBA Function in Excel Add Combo Box to a Sheet in Microsoft Excel Formulas to calculate Loan payments in Microsoft Excel Array variables using VBA in Microsoft Excel Create an Amortization Schedule in Microsoft Excel Find duplicates items in combine columns in Microsoft Excel Vlookup Formula – Organizing the Data Table

• Excel VBA books
• Accounting books
• Business Plans
• MS Office books
• Taxes books