[thelist] MS Excel Question

Christopher Mahan chris_mahan at yahoo.com
Mon Aug 25 18:37:44 CDT 2003


put a $ sign in front of the coordinate that needs to remain
constant:

example:  
  $c$15, for both
  $c15, for C to stay and 15 to be changed
  c$15 for c to be changed and 15 to stay.

Chris


--- Casey Crookston <casey at thecrookstons.com> wrote:
> 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 ! 


=====
Christopher Mahan
chris_mahan at yahoo.com
818.943.1850 cell
http://www.christophermahan.com/

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com


More information about the thelist mailing list