[thelist] MS Excel Question

Resurreccion, Dennis M. RSDN at chevrontexaco.com
Mon Aug 25 19:33:31 CDT 2003


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 ! 




More information about the thelist mailing list