Excel: Performing Mathematical Functions on Data Ranges September 06 2006
This is a quick post to remember how to do math on a range of data. For example: Suppose you have 10×10 area on a worksheet that you need all the data divided by the number 2.
1. Put the number 2 into a cell away from your data range
2. Copy the number 2 into your clipboard (highlight the cell with ‘2′ and Ctrl+C)
3. Highlight all the cells you want to divide by ‘2′
4. From the ‘EDIT” menu, choose ‘Paste Special…’
5. From the pop-up window, select ‘Divide’
This will perform the operation to all the values based on the value in the clipboard.
- Posted in : General
- Author : site admin
Comments»
no comments yet - be the first?