Thread: linked cells
View Single Post
 
Old 03-30-2012, 08:19 PM
JBeaucaire JBeaucaire is offline Windows XP Office 2003
Advanced Beginner
 
Join Date: Dec 2011
Posts: 51
JBeaucaire is on a distinguished road
Default

The $ symbols are "locks". Remove the "locks" on the part of the reference you want to adjust itself when copied.

$A$1 = locked column, locked row
$A1 = locked column, adjustable row
A$1 = adjustable column, locked row
A1 = adjustable column, adjustable row
Reply With Quote