September 13, 2013

Excel Tricks: Perform Basic Math Functions Without Creating A Formula

Written by
Excel Tricks: Perform Basic Math Functions Without Creating A Formula
Why is TechnologyAdvice Free?

If your business uses Microsoft Excel to crunch numbers, you’re going to want to know how to use the Paste Dialog box.

This tool allows you “to paste specific cell contents or attributes such as formulas, formats, or comments from the Clipboard into an Excel worksheet. You can also use Paste Special to paste a link to Excel data or data from another program, such as Microsoft Word or a Lotus 1-2-3 spreadsheet.”1

As the video above shows, you can do basic mathematics with this tool without using any complicated formulas. If you have lots of rows and/or columns of data that you with to update in the same way, the paste special tool is the easiest way to accomplish this. For example, say your company is running a promotion that decreases the price of your products by 20 percent. Copy 0.80 from an empty cell on your spreadsheet and use the “multiple” paste special operation. This can show how much all of your products will cost during the sale.

While there are easy ways to find this kind of information in more traditional means — like using a calculator — the Paste Special box can be a tremendous time-saver and can be advantageous to virtually any business.

Source:
“Use Paste Special to insert static or linked data into Excel.” <http://office.microsoft.com/en-us/excel-help/use-paste-special-to-insert-static-or-linked-data-into-excel-HP001108276.aspx>

Subscribe to our Youtube Channel for more tutorials.

Technology Advice is able to offer our services for free because some vendors may pay us for web traffic or other sales opportunities. Our mission is to help technology buyers make better purchasing decisions, so we provide you with information for all vendors — even those that don't pay us.
You may also like...
Max LeBlond discusses the property technology market on the B2B Nation podcast.

How the Proptech Market is Changing the Real Estate Sector
Self checkout lines showing the need for self-service sales.

Using Self-Service to Enable Buyers
API Management Tools & Software.

The Best API Management Software and Tools

0 Comments

  1. Brnfnk

    Just tired this with dates, seems to work though you need to change the cell format. I needed to add one day to each date, so I put the number 1 in general format, copied it and then used paste special. This however changed the dates to numerical values, so you will need to change the format back to date.

  2. AmitSharma3

    Brnfnk
    Hi Brnfnk,
    If you want to add 1 in previous date then you have to first type today() function or you can also type any date in cell A1 then you have to type this formula in next cell =A1+1 then press enter now drag it till target cell address… you will get result like 11/20/2013, 11/21/2013,11/22/2013 ……. and so on… If you have any other query regarding excel you have to logon http://www.eknowledges.com/ this site and submit your query in comment box of any post. Thanks.

  3. Brnfnk

    Just tired this with dates, seems to work though you need to change the cell format. I needed to add one day to each date, so I put the number 1 in general format, copied it and then used paste special. This however changed the dates to numerical values, so you will need to change the format back to date.

  4. AmitSharma3

    If you want to add 1 in previous date then you have to first type today() function or you can also type any date in cell A1 then you have to type this formula in next cell =A1+1 then press enter now drag it till target cell address… you will get result like 11/20/2013, 11/21/2013,11/22/2013 ……. and so on… If you have any other query regarding excel you have to logon http://www.eknowledges.com/ this site and submit your query in comment box of any post. Thanks.