Don wasu dalilai, masu amfani suna buƙatar taken teburin koyaushe a gani, koda ya jitu. Bugu da kari, yana da sau da yawa wajibi ne don, lokacin da aka buga takaddar kan matsakaici a matsakaici (takarda), an nuna a kan kowane shafin da aka buga. Bari mu gano waɗanne hanyoyi da zaku iya gyara taken a aikace-aikacen Microsoft Excel.
Pinching taken a saman kirtani
Idan taken tebur yana kan layi na babba, kuma ba ya mamaye layin guda ɗaya, to gyara shine aikin farko. Idan daya ko fiye da komai a sama suna sama da taken, ana buƙatar cire su don amfani da wannan zaɓin aikin.
Don amintar da taken, yayin da a cikin "kallo" shafin na shirin, danna maɓallin "Tsoro na Tsoro". Wannan maɓallin yana kan tef a cikin "taga" kayan aiki. Bugu da ari, a cikin jerin da suka buɗe, zaɓi "Tsaro na sama".
Bayan haka, an tsara taken da ke saman layin za a gyarawa, kasancewa koyaushe a cikin iyakokin allo.
Gyara yankin
Idan akwai wani dalili, mai amfani baya son cire sel ɗin da ke cikin taken, ko kuma ya ƙunshi layin guda ɗaya, to, hanyar haɗin gwiwa ta sama ba zai dace ba. Dole ne mu yi amfani da zaɓi tare da saurin ɗaukar yankin, wanda, duk da haka, ba ya rikitarwa da hanyar farko.
Da farko dai, mun ƙaura zuwa shafin "Duba". Bayan haka, danna kan mafi yawan sel da aka fice a ƙarƙashin taken. Bayan haka, muna yin danna maɓallin "Sanya yankin", wanda aka riga aka ambata a sama. To, a cikin sabunta menu, sake za i abun tare da sunan iri ɗaya - "Sanya yankin".
Bayan waɗannan ayyukan, za a rubuta taken teburin akan takardar na yanzu.
Ana cire pinching na taken
Duk abin da hanyoyin da aka lissafa guda biyu na teburin za a gyara, don amsa, akwai hanya ɗaya kawai. Kuma, muna yin danna maballin a kan tef "ɗaure yankin", amma wannan lokacin mun zaɓi matsayin "don cire haɓakar yankunan".
Biyo wannan, da aka sanya taken zai zama wanda aka bayyana, kuma lokacin da aka gungurawa takardar, ba za a gan shi ba.
Pinching taken
Akwai lokuta yayin da ake buga takardu da ake buƙata cewa taken ya kasance a kowane shafin buga shafin. Tabbas, zaku iya "rushe tebur da hannu, kuma a wuraren da ake so su shiga Liber. Amma, wannan tsari na iya tserewa babban adadin lokaci, kuma, bugu da ƙari, irin wannan canjin na iya lalata amincin tebur, da kuma hanyar da lissafi. Akwai wata hanya mafi sauƙin sauƙi kuma amintaccen buga teburin tare da taken a kowane shafi.
Da farko dai, mun shiga cikin shafin "Shafi shafi na shafi". Muna neman "sigogi na ganye". A cikin ƙananan hagu na hagu akwai gunki a cikin wani kifar kibiya. Danna wannan gunkin.
Window taga yana buɗewa tare da sigogin shafin. Mun koma zuwa "takardar" shafin. A cikin filin kusa da rubutu "Buga akan kowane shafi ta hanyar Lines" Kuna buƙatar tantance daidaiton layin da taken yake. A zahiri, don mai amfani mara amfani, wannan ba mai sauƙi bane. Sabili da haka, danna maɓallin an sanya maɓallin a hannun dama na filin shiga bayanai.
Window ɗin tare da sigogin shafi yana tare. A lokaci guda, takaddun ya zama mai aiki da wanda tebur yake. Kawai zaɓi kirtani (ko layin da yawa) wanda aka sanya taken. Kamar yadda kake gani, ana shigar da masu daidaitawa a cikin taga musamman. Latsa maɓallin da yake a hannun dama na wannan taga.
Window taga yana buɗewa tare da sigogin shafin. Mun rage kawai don danna maɓallin "Ok" da ke cikin kusurwar dama ta dama.
Dukkan ayyukan da suka wajaba sun zama dole, amma ba za ku ga wani canje-canje ba. Don bincika ko sunan tebur yanzu an buga shi akan kowane takarda, matsa zuwa shafin "fayil" shafin aikace-aikacen Excel. Na gaba, je zuwa maɓallin "Buga".
A gefen dama na taga wanda ya buɗe fannonin da aka buga na takardar buga. Sungura ƙasa, kuma tabbatar da cewa lokacin da aka buga bugawa, za a nuna wani pinned kai a kowane shafi.
Kamar yadda kake gani, akwai hanyoyi guda uku don gyara taken a teburin Microsoft Excel. Guda biyu daga cikinsu an tsara su don inganta a allunan a cikin tebur, lokacin aiki tare da daftarin aiki. Ana amfani da hanyar ta uku don fitarwa zuwa taken a kowane shafi na daftarin daftarin aiki. Yana da mahimmanci a tuna cewa yana yiwuwa a gyara kan taken ta hanyar ficewa na kirtani kawai idan an samo shi akan ɗaya, tare da babba na takardar. A akasin haka, kuna buƙatar amfani da hanyar gyara wuraren.