① Excel鎬庝箞鎵歸噺鍒犻櫎鎸囧畾鍗曞厓鏍煎唴瀹癸紵
鎵歸噺鍒犻櫎鎸囧畾鍗曞厓鏍煎唴瀹癸紝鏂規硶濡備笅錛
鏂規硶涓錛岄紶鏍囨嫋鍔ㄩ夊畾鏁版嵁鍖哄煙鈫掓寜閿鐩樹笂鐨凞ELETE閿銆傦紙榪炵畫鍖哄煙錛
鏂規硶浜岋紝榧犳爣鍗曞嚮琛屾爣錛岄夊畾涓琛岋紝鎴栧垪鏍囷紝閫夊畾涓鍒椻啋鎸夐敭鐩樹笂鐨凞ELETE閿銆傦紙鏁磋屾垨鏁村垪錛
鏂規硶涓夛紝榧犳爣鎷栧姩閫夊畾澶氳岃屾爣錛屾垨澶氬垪鍒楁爣鈫掓寜閿鐩樹笂鐨凞ELETE閿銆傦紙澶氳屾垨澶氬垪錛
鏂規硶鍥涳紝鎸変綇CTRL閿錛岄紶鏍囧崟鍑婚渶瑕佸垹闄ょ殑鍗曞厓鏍礆紝鈫掓寜閿鐩樹笂鐨凞ELETE閿銆傦紙涓嶈繛緇鍗曞厓鏍礆級
鏂規硶浜旓紝鍏堝崟鍑繪煇涓鍗曞厓鏍尖啋鍐嶆寜浣廠HIFT鈫掗紶鏍囧啀鍗曞嚮鍙﹀栫殑鍗曞厓鏍尖啋鎸夐敭鐩樹笂鐨凞ELETE閿銆傦紙榪炵畫鍖哄煙錛
鏂規硶鍏錛孷BA鏂規硶銆
SUB DELMyValue()
Range("A1:C3").Value="" '鏁版嵁鍖哄煙鎸夊疄闄呬慨鏀
End Sub