Place a dollar sign, e.g. =B15+$C$15. The dollar sign just indicates that the location is absolute. -----Original Message----- From: Casey Crookston [mailto:casey at thecrookstons.com] Sent: Tuesday, August 26, 2003 5:47 AM To: thelist at lists.evolt.org Subject: [thelist] MS Excel Question When creating a formula in Excel you can, of course, reference other cells: =b15+c15 If you copy and paste that cell, Excel is kind enough to change the cell references relative to where you pasted. But what if I want one of the cell references to remain constant? Example: Original: =B15+C15 Pasted: =B16+C15 Pasted: =B16+C15 Pasted: =B16+C15 Pasted: =E16+C15 How do you specify that C15 is to remain unchanged? TIA, Casey -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt !