| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to subtract a number from an entire row in excel
Put 2000 in a spare cell, copy, select your row, Edit/ Paste Special/
Subtract/ OK You can now delete the 200 from the spare cell, if you wish. -- David Biddulph "kav" wrote in message ... I want to subtract a constant number say 2000 fro an entire row and replace the same row with the new answer |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I subtract excel cell values that contain both a number a. | Excel Discussion (Misc queries) | |||
| how to set number format for the entire excel sheet | Excel Worksheet Functions | |||
| How do I add the same number/value for an entire column in Excel? | Excel Worksheet Functions | |||
| how can i subtract single integer value from the entire column | Charts and Charting in Excel | |||
| Subtract entire sheet? | Excel Worksheet Functions | |||
![David Biddulph[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
