| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel: hold a reference to a single cell when copying formulas?
Did you remember to use the $ for both Column and Row?
ie $A$5 vs. $A5 HTH, -- Gary Brown "Jim in Texas" wrote: I used to use '$' signs to keep a refererence to a single cell in a formula but that doesn't seem to work in the new version. How should I do that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Does Excel have a "This Cell" reference | New Users to Excel | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Apply a simple formula to multiple rows? | New Users to Excel | |||
| How Can I make a cell flash in Excel | Excel Discussion (Misc queries) | |||
| Excel should allow multiple hyperlinks in a single cell | Excel Discussion (Misc queries) | |||
Linear Mode
