[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


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?



* * Please support the community that supports you.  * *

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