Contents
Haɗin maɓalli mai zafi zaɓi ne ta hanyar da za'a iya buga wani haɗin gwiwa akan maballin, wanda tare da shi zaku iya samun dama ga wasu fasalulluka na editan Excel da sauri. A cikin labarin, za mu yi la'akari da hanyoyin da za a share layuka a cikin teburin edita ta amfani da maɓalli masu zafi.
Share layi daga madannai tare da hotkeys
Hanya mafi sauri don share layi ko da yawa shine amfani da haɗin maɓalli masu zafi. Domin goge abubuwan cikin layi ta amfani da gajeriyar hanyar keyboard, kawai kuna buƙatar danna maɓallai guda 2, ɗaya daga cikinsu shine “Ctrl” na biyu kuma shine “-”.
Hakanan ya kamata a lura cewa layin (ko abubuwa da yawa) dole ne a zaɓa a gaba. Umurnin zai share ƙayyadaddun kewayon tare da biya na sama. Aikace-aikacen zai ba da damar rage lokacin da aka kashe da kuma ƙi ayyukan da ba dole ba tare da taimakon abin da ake kira akwatin maganganu. Yana yiwuwa a hanzarta hanyar don share layin ta amfani da maɓallan zafi, duk da haka, don wannan dalili, kuna buƙatar yin matakai 2. Da farko, ajiye macro, sa'an nan kuma sanya aiwatar da shi zuwa takamaiman haɗin maɓalli.
Ajiye macro
Ta amfani da macro code don cire wani abu na layi, yana yiwuwa a cire shi ba tare da amfani da ma'anar linzamin kwamfuta ba. Ayyukan zai taimaka wajen ƙayyade adadin ɓangaren layi inda alamar zaɓe yake kuma share layin tare da motsi zuwa sama. Don yin wani aiki, ba kwa buƙatar zaɓar abin da kansa kafin hanya. Don canja wurin irin wannan lambar zuwa PC, ya kamata ka kwafa shi kuma ka liƙa shi kai tsaye a cikin tsarin aikin.
Sanya gajeriyar hanyar keyboard zuwa macro
Yana yiwuwa a saita hotkeys na ku, don haka hanyar don share layin za a ɗan ƙara haɓaka, duk da haka, don wannan dalili, ana buƙatar ayyuka 2. Da farko, kuna buƙatar adana macro a cikin littafin, sannan gyara aiwatar da shi tare da wasu maɓalli masu dacewa. Hanyar da aka yi la'akari da shi na share layukan ya fi dacewa da ƙarin masu amfani da editan Excel.
Muhimmin! Ya kamata a lura cewa yana da mahimmanci don zaɓar maɓallai masu zafi don share layuka a hankali, tunda an riga an yi amfani da haɗuwa da yawa ta aikace-aikacen Excel kanta.
Bugu da ƙari, edita yana bambanta haruffa na ƙayyadaddun wasiƙar, don haka, don kada a mayar da hankali kan shimfidar wuri yayin gudanar da macro, yana yiwuwa a kwafa shi da wani suna daban kuma zaɓi maɓalli mai maɓalli don shi ta amfani da maɓallin kama.
Macro don share layuka bisa ga sharadi
Hakanan akwai kayan aikin ci gaba don aiwatar da hanyar da ake tambaya, ta amfani da waɗanda ba kwa buƙatar mayar da hankali kan gano layin da za a goge. Misali, zamu iya ɗaukar macro da ke nema da cire abubuwan layi masu ɗauke da takamaiman rubutun mai amfani, da ƙari don Excel. Yana cire layi tare da yanayi daban-daban da yawa da ikon saita su a cikin akwatin maganganu.
Kammalawa
Don cire abubuwan cikin layi a cikin editan Excel, akwai kayan aiki masu amfani da yawa. Zaka iya amfani da hotkeys don yin irin wannan aiki, da kuma ƙirƙirar macro naka don cire abubuwan layi a cikin tebur, babban abu shine bi algorithm na ayyuka daidai.