Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 03-30-2012, 08:19 PM
JBeaucaire JBeaucaire is offline linked cells Windows XP linked cells 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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
placing linked Excel cells in Word next to a chart Paul-NYS Word 4 03-16-2012 12:59 PM
linked cells listing linked graphics eng1ne Drawing and Graphics 5 02-28-2012 06:42 AM
Linked graphics eNGiNe Word 2 02-20-2012 10:52 PM
Linked Tables afpapa2 PowerPoint 0 12-01-2011 09:25 AM
Count range cells eliminating merge cells danbenedek Excel 0 06-15-2010 12:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:25 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft