Home |
Search |
Today's Posts |
#1
|
|||
|
|||
once you have an amount in a cell how do you get that amount to i.
How do you get an amount already in a cell that had been formatted to
increase by say 500 |
#2
|
|||
|
|||
Place 500 in a blank cell, edit|copy the cell with 500, edit|past
special|add on the cell you want to change "jillingore" wrote: How do you get an amount already in a cell that had been formatted to increase by say 500 |
#3
|
|||
|
|||
Jill,
You can add 500 to a cell by typing 500 in a blank cell, copying that cell, then selecting your cell that you want to increment and: right-click, select Paste Special, then click "Values" and "Add" and then press OK. You can do this to multiple cells instead of just one. Or, if you have a value in a cell, you can press F2, type +500, then select everything in the cell and press F9. If you have a formula, press F2, then type + 500 and press Enter. HTH, Bernie MS Excel MVP "jillingore" wrote in message ... How do you get an amount already in a cell that had been formatted to increase by say 500 |
#4
|
|||
|
|||
Hi Bernie
What does clicking Values do? I use the paste special Add or Multiply all the time and never had changed All to Values in the top section. "Bernie Deitrick" <deitbe @ consumer dot org wrote in message ... : Jill, : : You can add 500 to a cell by typing 500 in a blank cell, copying that cell, : then selecting your cell that you want to increment and: right-click, select : Paste Special, then click "Values" and "Add" and then press OK. You can do : this to multiple cells instead of just one. : : Or, if you have a value in a cell, you can press F2, type +500, then select : everything in the cell and press F9. If you have a formula, press F2, then : type + 500 and press Enter. : : HTH, : Bernie : MS Excel MVP : : : "jillingore" wrote in message : ... : How do you get an amount already in a cell that had been formatted to : increase by say 500 : : |
#5
|
|||
|
|||
Lady Layla,
What does clicking Values do? Keeps you from pasting (or overwriting existing) colors, conditional formats, comments, borders.... HTH, Bernie MS Excel MVP "Lady Layla" wrote in message ... Hi Bernie What does clicking Values do? I use the paste special Add or Multiply all the time and never had changed All to Values in the top section. "Bernie Deitrick" <deitbe @ consumer dot org wrote in message ... : Jill, : : You can add 500 to a cell by typing 500 in a blank cell, copying that cell, : then selecting your cell that you want to increment and: right-click, select : Paste Special, then click "Values" and "Add" and then press OK. You can do : this to multiple cells instead of just one. : : Or, if you have a value in a cell, you can press F2, type +500, then select : everything in the cell and press F9. If you have a formula, press F2, then : type + 500 and press Enter. : : HTH, : Bernie : MS Excel MVP : : : "jillingore" wrote in message : ... : How do you get an amount already in a cell that had been formatted to : increase by say 500 : : |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
up to 7 functions? | Excel Worksheet Functions | |||
Syntax for inferred cell references | Excel Worksheet Functions | |||
Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |