Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need to add same value to every cell...Is that doable?
I have a spreadsheet that is like a price list. I need to
add an amount to every cell. Is there an easy way to do that & have it calculated for me instead of manually calculating it & typing it in? |
#2
|
|||
|
|||
Hi Brita
Enter the amount in a empty cell on you sheet Copy this cell Select all the cells Right click on them and choose Paste Special Add -- Regards Ron de Bruin http://www.rondebruin.nl "Brita" wrote in message ... I have a spreadsheet that is like a price list. I need to add an amount to every cell. Is there an easy way to do that & have it calculated for me instead of manually calculating it & typing it in? |
#3
|
|||
|
|||
Thanks. I wasn't clear. My fault. I have cells with
values in them already. I need to add 50 to each one. THANKS! -----Original Message----- Hi Brita Enter the amount in a empty cell on you sheet Copy this cell Select all the cells Right click on them and choose Paste Special Add -- Regards Ron de Bruin http://www.rondebruin.nl "Brita" wrote in message ... I have a spreadsheet that is like a price list. I need to add an amount to every cell. Is there an easy way to do that & have it calculated for me instead of manually calculating it & typing it in? . |
#4
|
|||
|
|||
THANKS SO MUCH RON!!!
I've been trying to get help with this for 3 weeks!!! Brita -----Original Message----- Hi Brita Enter the amount in a empty cell on you sheet Copy this cell Select all the cells Right click on them and choose Paste Special Add -- Regards Ron de Bruin http://www.rondebruin.nl "Brita" wrote in message ... I have a spreadsheet that is like a price list. I need to add an amount to every cell. Is there an easy way to do that & have it calculated for me instead of manually calculating it & typing it in? . |
#5
|
|||
|
|||
THANKS SO MUCH RON!!!
I've been trying to get help with this for 3 weeks!!! Brita -----Original Message----- Hi Brita Enter the amount in a empty cell on you sheet Copy this cell Select all the cells Right click on them and choose Paste Special Add -- Regards Ron de Bruin http://www.rondebruin.nl "Brita" wrote in message ... I have a spreadsheet that is like a price list. I need to add an amount to every cell. Is there an easy way to do that & have it calculated for me instead of manually calculating it & typing it in? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can't move a named cell without breaking a hyperlink to that cell | Links and Linking in Excel | |||
Display cell value on a chart. | Charts and Charting in Excel | |||
How do I set a cell to "Empty" so that it does not display in a ch | Charts and Charting in Excel | |||
make a cell empty based on condition | Charts and Charting in Excel | |||
Transferring cell content between workbooks using cell references | Excel Discussion (Misc queries) |