‘壹’ excel涓濡备綍寮旷敤缁濆瑰崟鍏冩牸锛
鍏辨湁锲涚嶅紩鐢ㄥ舰寮忥细
A1 鏄鐩稿瑰紩鐢
$A1 缁濆瑰紩鐢ㄥ垪锛屾槸娣峰悎寮旷敤
A$1 缁濆瑰紩鐢ㄨ岋纴鏄娣峰悎寮旷敤
$A$1 缁濆瑰紩鐢ㄨ屽拰鍒楋纴鏄缁濆瑰紩鐢
$鏄缁濆瑰紩鐢ㄧ﹀彿锛$鍦ㄨ皝镄勫墠闱㈠氨缁濆瑰紩鐢ㄨ皝銆
F4鏄鍦ㄥ洓绉嶅紩鐢ㄩ棿鐩镐簰杞鎹㈢殑蹇鎹烽敭(鍦ㄧ紪杈戞爮杈揿叆鍏寮忔椂鎸変笅F4锷熻兘阌鍙杩涜屽垏鎹)銆
A1 鍦ㄤ笅𨰾夋嫋锷ㄥ紩鐢ㄦ椂,浼氩彉鎴愬紩鐢ˋ2,A3,A4...,鍙虫媺𨰾栧姩镞跺紩鐢ㄥ彉鎴怋1,C1,D1.... 锛
A$1褰扑綘涓嬫媺澶嶅埗镞舵兂淇濊瘉寮旷敤镄勫彧鏄疉1鍗曞厓镙兼椂,A1灏辫佸姞$绗﹀彿,鎴怉$1,杩欐牱鍦ㄤ笅𨰾夋椂鑳戒缭璇佸笰鍒楃涓琛岀殑鐩稿瑰紩鐢(鍗充缭鎸佽屽彿鍦ㄥ紩鐢ㄦ椂涓崭骇鐢熷彉锷) 锛
$A1褰扑綘鍙虫媺澶嶅埗镞舵兂淇濊瘉寮旷敤镄勫彧鏄疉1鍗曞厓镙兼椂,A1灏辫佸姞$绗﹀彿,鎴$A1,杩欐牱鍦ㄥ彸𨰾夋椂鑳戒缭璇佸笰鍒楃涓琛岀殑鐩稿瑰紩鐢(鍗充缭鎸佸垪镙囧湪寮旷敤镞朵笉浜х敓鍙桦姩) 锛
$A$1褰扑綘鍦ㄤ笅𨰾夊拰鍙虫媺澶嶅埗镞舵兂淇濊瘉寮旷敤镄勫彧鏄疉1鍗曞厓镙兼椂,A1灏辫佸姞$绗﹀彿,鎴$A$1,杩欐牱鍦ㄤ笅𨰾夊拰鍙虫媺镞惰兘淇濊瘉瀵笰鍒楃涓琛岀殑缁濆瑰紩鐢(鍗充缭鎸佽屽彿鍒楁爣鍦ㄥ紩鐢ㄦ椂涓崭骇鐢熷彉锷)銆
‘贰’ excel琛ㄦ牸缁濆瑰紩鐢ㄦ庝箞寮
excel琛ㄦ牸缁濆瑰紩鐢ㄧ殑镎崭綔鏂规硶濡备笅锛氩湪闇瑕佸紩鐢ㄧ殑鍗曞厓镙煎墠锷犱笂“$”绗﹀彿锛屼緥濡“$A$1”锛屽氨鍙浠ュ疄鐜扮粷瀵瑰紩鐢ㄣ傝繖镙凤纴镞犺哄叕寮忚澶嶅埗鍒板摢閲岋纴寮旷敤镄勫崟鍏冩牸浣岖疆閮戒笉浼氭敼鍙樸
璇︾粏𨱒ヨ达纴缁濆瑰紩鐢ㄥ湪Excel涓鏄涓绉嶉潪甯搁吨瑕佺殑锷熻兘锛屽畠鍙浠ュ湪澶嶅埗鍏寮忔椂淇濇寔寮旷敤镄勫崟鍏冩牸鍦板潃涓嶅彉銆傝繖瀵逛簬涓浜涢渶瑕佺簿纭璁＄畻镄勫満鏅𨱒ヨ撮潪甯告湁鐢ㄣ傚湪Excel涓锛屾湁涓ょ岖被鍨嬬殑寮旷敤锛氱浉瀵瑰紩鐢ㄥ拰缁濆瑰紩鐢ㄣ傜浉瀵瑰紩鐢ㄦ槸鎸囧叕寮忎腑镄勫崟鍏冩牸鍦板潃浼氶殢镌鍏寮忎綅缃镄勬敼鍙樿屾敼鍙桡纴钥岀粷瀵瑰紩鐢ㄥ垯涓崭细銆
涓句釜渚嫔瓙锛屽亣璁炬垜浠鍦ˋ1鍗曞厓镙间腑杈揿叆浜嗕竴涓鏁板瓧5锛岀劧钖庡湪B1鍗曞厓镙间腑杈揿叆浜嗗叕寮“=A1”銆傝繖镞跺欙纴濡傛灉鎴戜滑鎶夿1鍗曞厓镙肩殑鍏寮忓嶅埗鍒痫2鍗曞厓镙硷纴B2鍗曞厓镙肩殑鍏寮忓氨浼氩彉鎴“=A2”锛岃繖灏辨槸鐩稿瑰紩鐢ㄧ殑鏁堟灉銆备絾鏄锛屽傛灉鎴戜滑甯屾湜B2鍗曞厓镙肩殑鍏寮忚缮鏄寮旷敤A1鍗曞厓镙硷纴闾ｄ箞灏遍渶瑕佷娇鐢ㄧ粷瀵瑰紩鐢ㄣ傛垜浠鍙浠ュ湪B1鍗曞厓镙间腑杈揿叆鍏寮“=$A$1”锛岀劧钖庡啀鎶婂叕寮忓嶅埗鍒痫2鍗曞厓镙硷纴杩欐椂鍊橞2鍗曞厓镙肩殑鍏寮忓氨浼氢缭鎸佷负“=$A$1”锛屼笉浼氩彉鎴“=$A$2”銆
缁濆瑰紩鐢ㄧ殑浣跨敤闱炲父𨱔垫椿锛屽彲浠ユ牴鎹瀹为檯闇瑕侀夋嫨寮旷敤鍗曚釜鍗曞厓镙笺佷竴琛屻佷竴鍒楁垨钥呬竴涓鍖哄烟銆备緥濡傦纴“$A$1”琛ㄧず瀵笰1鍗曞厓镙肩殑缁濆瑰紩鐢锛“$A1”琛ㄧず瀵笰鍒楃殑缁濆瑰紩鐢ㄤ絾鏄琛岀浉瀵瑰紩鐢锛“A$1”琛ㄧず瀵圭1琛岀殑缁濆瑰紩鐢ㄤ絾鏄鍒楃浉瀵瑰紩鐢锛“$A$1:$B$2”琛ㄧず瀵笰1:B2杩欎釜鍖哄烟镄勭粷瀵瑰紩鐢ㄣ
鍦ㄥ疄闄呮搷浣滀腑锛屽彲浠ラ氲繃镓嫔姩杈揿叆缇庡厓绗﹀彿𨱒ュ疄鐜扮粷瀵瑰紩鐢锛屼篃鍙浠ヤ娇鐢ㄥ揩鎹烽敭F4𨱒ュ垏鎹㈠紩鐢ㄧ被鍨嬨傚傛灉闇瑕佷慨鏀瑰凡缁忚緭鍏ョ殑鍏寮忎腑镄勫紩鐢ㄧ被鍨嬶纴鍙浠ラ変腑闇瑕佷慨鏀圭殑鍗曞厓镙煎湴鍧锛岀劧钖庢寜涓婩4阌杩涜屽垏鎹銆傞渶瑕佹敞镒忕殑鏄锛屽湪浣跨敤缁濆瑰紩鐢ㄦ椂锛岃佺‘淇濆紩鐢ㄧ殑鍗曞厓镙煎湴鍧鏄姝ｇ‘镄勶纴钖﹀垯鍙鑳戒细瀵艰嚧璁＄畻缁撴灉鍑虹幇阌栾銆