ExcelTip.com
ExcelTip.com
Account Icon Account Icon Account Icon
Google Exceltip.com
JOIN OUR NEWSLETTER
  and receive for joining:
Free eBook Learn More!
Free Excel ADD-IN
Free Weekly Excel Tip
4 e-books in cd-rom
F1 Formulas & Functions
F1 Formulas & Functions
F1 EXCEL
F1 eBook (Spanish)
F1 EXCEL
Financial Statements.xls
 

» Multiplying a Range by -1 in One Operation


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

Multiplying a Range by -1 in One Operation
Rate this tip
12 34 5
  RATING: 3.54
  VIEWS: 13789

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


Convert PDF Files to Excel


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

VIEW ALL BOOKS