 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / March 2006locking formula cell references
I have a cell that references B2 i need the reference to stay at B2 even if i insert a row at row 2. Currently the reference moves to B3. Is there any way around this? You must reference B$2 HTH -- AP > I have a cell that references B2 i need the reference to stay at B2 even if > i insert a row at row 2. Currently the reference moves to B3. Is there any > way around this? Tried that already....Cell reference changes to B$3 > You must reference B$2 > [quoted text clipped - 6 lines] > > i insert a row at row 2. Currently the reference moves to B3. Is there any > > way around this? Use the INDIRECT function =INDIRECT("B2") > Tried that already....Cell reference changes to B$3 > [quoted text clipped - 8 lines] > > > i insert a row at row 2. Currently the reference moves to B3. Is there any > > > way around this? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.