|
|
#1
05-26-2015, 09:28 AM
|
|||
|
|||
Propagating a formula which references a named cell
Hi ,
I'd like to know if it's possible to propagate a formula which references a named cell but having the formula change reference cells accordingly when propagated. Say for example I had cell A1 named OmegaT and in cell B1 I had =OmegaT+180 then I propagated the equation down column B. It seems that OmegaT is treated as $A$1. Is it possible to make the equation in cell B# reference A# rather than being locked to A1? Thanks 
|
|
#2
05-27-2015, 09:06 AM
|
||||
|
||||
|
Quote:
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
#4
06-03-2015, 08:06 AM
|
||||
|
||||
|
Go to the Name Manager ( formula ribbon), select the name and remove the $ sign from the row reference in the "refer to" field
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Formula in cell b1 using cell a1 if a1 is over certain number
|
pumkinbug87 | Excel | 5 | 12-03-2013 12:34 PM |
| Macro to change cell references | SaneMan | Excel Programming | 6 | 10-01-2013 02:49 PM |
| Change formula cell range based on cell value | Scoth | Excel | 4 | 10-25-2012 07:51 AM |
| Can't use a zero in a named cell | TechEd | Excel | 2 | 10-16-2012 10:06 PM |
| Formula that references cell with text in different workbook | no1texan | Excel | 3 | 07-17-2012 05:58 AM |
Windows XP 
Office 2010 32bit
Linear Mode
