To make a quick change to numbers in Excel, you can use the Paste Special feature, instead of using formulas.
For example, quickly add a specific amount, such as $1.50 to all the prices in a list.
Or increase all the prices by 5%, with just a couple of steps.
Download the free Excel workbook from my Contextures website:
http://www.contextures.com/xlDataEntry04.html
Instructor: Debra Dalgleish, Contextures Inc.
Get Debra’s weekly Excel tips: http://www.contextures.com/signup01
More Excel Tips and Tutorials: http://www.contextures.com/tiptech.html
Subscribe to Contextures YouTube: https://www.youtube.com/user/contextures?sub_confirmation=1
#ContexturesExcelTips