[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