How to Divide Data in Columns/Rows Without a Formula (Excel 2010/2007/2003)

How to Divide Data in Columns/Rows Without a Formula (Excel 2010/2007/2003)

Using “Paste Special” with  “Divide” will allow you to take selected data and divide it by a number in just a few quick steps.  In this example we will take sales figure totals for a product and divide it by the price of the product to determine the quantity of items sold. This process is shown in Excel 2010, but will also work in Excel 2007 and Excel 2003.
 

This post is only available to members.
Related Posts

How to Change Time Increments in Outlook Calendar

You can change the time increments shown in your Outlook calendar to allow for smaller more detailed calendar entries.  This will work in Outlook 2003, Outlook 2007, and Outlook 2010.

This post is only available to members.
Back To Top