How do I change the default cell reference from absolute to relati JZing 17.07.2006 12:23:02 It is my understanding that cell references, by default, are set up to be all relative. Somehow I've changed my defaults to have my cell references all be absolute. What menu setting do I have to change to get the default back to relative?

Re: How do I change the default cell reference from absolute to relati Dave Peterson <petersod[ at ]verizonXSPAM.net> 17.07.2006 16:15:01 I don't think it was you. If you are creating a formula and you point at a cell within the same workbook, you'll see the relative address. If you use a cell in a different workbook, you'll see the absolute address. I've never seen anything that would change this behavior. But you can select that reference and hit F4 a few times to cycle through all of the relative/absolute addresses. JZing wrote: [Quoted Text] > > It is my understanding that cell references, by default, are set up to be all > relative. Somehow I've changed my defaults to have my cell references all be > absolute. What menu setting do I have to change to get the default back to > relative? -- Dave Peterson

Re: How do I change the default cell reference from absolute to re JZing 17.07.2006 16:42:01 Thanks. I didn't realize the default would change based upon cell location. "Dave Peterson" wrote: [Quoted Text] > I don't think it was you. > > If you are creating a formula and you point at a cell within the same workbook, > you'll see the relative address. If you use a cell in a different workbook, > you'll see the absolute address. > > I've never seen anything that would change this behavior. > > But you can select that reference and hit F4 a few times to cycle through all of > the relative/absolute addresses. > > JZing wrote: > > > > It is my understanding that cell references, by default, are set up to be all > > relative. Somehow I've changed my defaults to have my cell references all be > > absolute. What menu setting do I have to change to get the default back to > > relative? > > -- > > Dave Peterson >

Re: Re: How do I change the default cell reference from absolute to re Dodgester <Dodgester.2b6769[ at ]mail.mcse.ms> 19.07.2006 00:03:34 I never realized the F4 trick. However, I must also agree with Dave, there is no way of being able to change this pattern without having to deal with macros. Even when dealing with macros, there is no real way of having those codes triggered without having to use the WorksheetChange Event on either every single worksheet of every workbook that you touch or on every ThisWorkbook module of every workbook that you touch. If you were to use this method, it could create problems for others that may be modifying thus you must also provide for some sort of trapping mechanism in order to prevent hassles for other users. Sincerely, Ronald R. Dodge, Jr. -- Dodgester ------------------------------------------------------------------------ Posted via http://www.mcse.ms ------------------------------------------------------------------------ View this thread: http://www.mcse.ms/message2422520.html