I want to subtract a number from an entire row in excel

K

kav

I want to subtract a constant number say 2000 fro an entire row and replace
the same row with the new answer
 
G

Gary''s Student

In an un-used cell, enter 2000.
Copy the cell.

Select the cells you want to modify and then
Edit > PasteSpecial > subtract

All the cells will have the value subtracted
 
S

Sean Timmons

type 2000 into a blank cell.

Copy that cell.

Highlight your desired row.

Paste Special, Subtract
 
D

David Biddulph

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

Suleman Peerzade

you can use this formula also for eg your data is in row A1 and you want your
answer in row A2

=A1-2000
Then you can copy row A2 and right click on row A1 paste special>>values.
This will replace the same row with a substracted value.
--
_______________________
Click "Yes" button if it helps
________
Thanks
Suleman Peerzade
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to remove a bracket that is itallicised for an entire document 1
Subtraction from the lowest number postion wise in Column 3
Removing Line Numbers 4
Excel does not accept text format! 0
Excel --> Word 4
Function in Excel to count and list number of entries of text valuesin a row. 2
I'm sure its an easy answer.... 1
Subtracting first and last values in a row to find net difference 10

Top