Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cell Formatting
I am trying to take and copy a format in a cell to another cell, but when I
do that it want to change the vaules to include the cell next to it. Example: Cell D5 =A1+B1+C75 when I copy & paste in D6 I get =A2+B2+C76 I want D6 to be =A2+B2+C75 How can I do this? |
#2
|
|||
|
|||
Take a look at "The difference between relative and absolute references"
in XL Help: Then try: =A1 + B1 + $C$75 In article , "jmaulsby" wrote: I am trying to take and copy a format in a cell to another cell, but when I do that it want to change the vaules to include the cell next to it. Example: Cell D5 =A1+B1+C75 when I copy & paste in D6 I get =A2+B2+C76 I want D6 to be =A2+B2+C75 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Display actual contents of cell | Excel Discussion (Misc queries) | |||
conditional formatting blank cell | Excel Discussion (Misc queries) | |||
Formatting Cell problem | Excel Discussion (Misc queries) | |||
copy a cell value not its function | Excel Discussion (Misc queries) |