September 13, 2013

Excel Tricks: Perform Basic Math Functions Without Creating A Formula

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.

 
Join the discussion

Please login with your social ID above.

4 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.

Looking for software? Try our Product Selection Tool