[AccessD] Excel Tip of the Day

Keith Williamson Kwilliamson at RTKL.com
Thu Dec 14 14:08:55 CST 2006


Just ran across this...don't know if anyone else knew of it.  When you
want to have static cell references....so you want to put "$"s around
the cell reference...such as:  $C$1.......just click on the cell
reference (in your formula)....and click F4.  It automatically puts BOTH
$'s around the reference.   I never knew that before...so I am passing
that on.  Very handy!

Regards,

Keith E. Williamson | Assist. Controller| kwilliamson at rtkl.com

RTKL Associates Inc. | 901 South Bond Street | Baltimore, Maryland
21231-3305

410-537-6098 direct | 410-276-2136 fax | www.rtkl.com




More information about the AccessD mailing list