Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I add a value to entire spreadsheet?
I have a speadsheet with numbers in the columns. I need to add the same value
to each amount in the columns. I know this can be done as I have done it before but I cannot remember how to. Any help would be great! |
#2
|
|||
|
|||
You've a response to your post in worksheet.functions
-- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Brita Jack" wrote: I have a speadsheet with numbers in the columns. I need to add the same value to each amount in the columns. I know this can be done as I have done it before but I cannot remember how to. Any help would be great! |
#3
|
|||
|
|||
In a new worksheet, I would create a formula that simply adds the number you
need to each cell. Copy that formula to all the corresponding cells. The copy all the new numbers back to the original worksheet, and use "Paste Special, Values" to overwrite the original numbers with the new numbers. "Brita Jack" wrote: I have a speadsheet with numbers in the columns. I need to add the same value to each amount in the columns. I know this can be done as I have done it before but I cannot remember how to. Any help would be great! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search should highlight entire row in Excell in red | Excel Discussion (Misc queries) | |||
How do I convert exel spreadsheet to works spreadsheet? | Excel Discussion (Misc queries) | |||
#REF error on linked spreadsheet | Links and Linking in Excel | |||
print entire workbook default | Excel Discussion (Misc queries) | |||
How do I cancel sending a spreadsheet by email? | Excel Discussion (Misc queries) |