[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