- Inkinga ivame ukuvela ekubeni khona kwezinto ezifihliwe noma amafomethi asetshenziswa emikhawulweni yokugcina yeshidi.
- Izilungiselelo zokubonisa izinto zingase zivimbele ikhono lokuhambisa amaseli ukufaka imigqa emisha.
- Ukuhlanza imigqa namakholomu angenalutho aqukethe ukufometha okungabonakali kubalulekile ekukhululeni indawo yokusebenza.
Ngiyaqiniseka ukuthi sekwenzekile kuwe: usebenza kanzima kuspredishithi sakho, udinga ukwengeza umugqa omusha ukuze uhlele idatha yakho, futhi ngokuzumayo i-Excel ikhipha umlayezo wephutha othukuthelisayo othi ayikwazi ukufaka amaseli ngoba izosusa idatha ngaphandle kweshidi. Kuyisikhathi esicasulayo, ikakhulukazi uma ubona ukuthi amaseli abonakala engenalutho futhi ungazi ukuthi kwenzekani ngohlelo.
Leli phutha livame kakhulu kunalokho ongakucabanga, futhi alihlali linembangela ecacile. Ngezinye izikhathi kuyinkinga elula yokucushwa , kanti ngezinye izikhathi i-Excel icabanga ukuthi unedatha kuze kufike kukholomu noma umugqa wokugcina, yize ungaboni lutho. Kulesi sihloko, sizohlukanisa zonke izixazululo ezingaba khona, kusukela ekulungiseni okulula kuya ekusebenziseni ama-macro, ukuze ukwazi ukubuyela emsebenzini ngaphandle kokuthi isofthiwe ikuphathe kabi.
Uma inkinga iyinto efihliwe
Esinye sezimbangela ezivame kakhulu ukuba nezinto, njengemibono, izithombe, noma izimo, ezibekwe ukuthi zihlale zizinzile noma zifihliwe. Uma uzama ukufihla ikholomu nomugqa ku-Excel noma ufaka umugqa bese kuba nokuphawula kweseli endleleni, i-Excel ingase iphahlazeke uma ukulungiselelwa kokubonisa kungalungile.
Ukuze ulungise lokhu ezinguqulweni zanamuhla, udinga ukuya kumenyu yezinketho ze-Excel, ufake ithebhu ethi Okuthuthukisiwe, bese ubheka izinketho zokubonisa zalesi sigaba sencwadi yokusebenza . Lapho, qiniseka ukuthi inketho ethi "Okwezinto, bonisa" ikhethiwe esikhundleni sokuthi "Akukho lutho." Icebo elisheshayo lokushintsha lokhu ngaphandle kokuzulazula ngamamenyu ukucindezela i-CTRL + 6.
Uma lokhu kungasebenzi, kungase kudingeke ushintshe izakhiwo zento ngokuqondile. Udinga ukusetha into ibe yimpahla ethi " Hambisa futhi ushintshe usayizi ngamaseli" . Ukuze wenze lokhu, khetha into (uma kuyimpendulo, chofoza kwesokudla bese ukhetha okuthi "Bonisa Amazwana"), iya ku-Object Format, faka ithebhu ethi Properties, bese uhlola ibhokisi elishiwo ngenhla. Lokhu kuvimbela into ukuthi isebenze njengesivimbelo esingabonakali esivimbela amaseli ukuthi asuswe.
Idrama yamaseli anefomethi engabonakali
Esinye isimo esivame kakhulu yilapho uhlelo lukuxwayisa ngokuthi amaseli angenalutho azothuthelwa ngaphandle kwespredishithi. Cishe, ngaphandle kokuqaphela, usebenzise ifomethi yokugcwalisa (njengesizinda esimhlophe) kumakholomu noma imigqa yonke, kuze kufike emaphethelweni e-Excel. Ngisho noma iseli lingenawo umbhalo, iqiniso lokuthi linombala libangela i-Excel ukuthi iyibheke njenge "engenalutho . "
Isixazululo esisebenza kahle kakhulu lapha ukuhlanza ngokuphelele. Ukususa okuqukethwe akwanele; udinga ukususa ngokoqobo imigqa namakholomu angadingekile. Khetha umugqa wokuqala ongenalutho ngaphansi kwedatha yakho bese uwususa wonke (Ctrl + Shift + Umcibisholo Ophansi). Yenza okufanayo ngamakholomu lapho idatha yakho iphelela khona kukholomu ye-XFD. Ngezinye izikhathi, inkinga ukuthi ukufometha kukopishwa ngokuzenzakalelayo kumigqa emisha evelayo uma ususa eminye, ngakho-ke ukusula ukufometha kumugqa wokugcina ngaphambi kokulondoloza kungaba yisihluthulelo.
Uma uneshidi lokusebenzela eligcwele izinto futhi ungafuni ukushintsha izakhiwo zazo ngayinye ngoba kungathatha isikhathi eside, ungasebenzisa ama-macro e-Excel . Kukhona i -macro elula ephindaphinda kuzo zonke izimo nezinto ezikushidi lokusebenzela elisebenzayo bese izinika ngokuzenzakalelayo isici sokuhambisa nokushintsha usayizi ngamaseli.
Ikhodi iqukethe ukumemezela ukuguquguquka kohlobo lwe-Shape nokusebenzisa iluphu Ukuze Ngamunye ukufaka isicelo s.Placement = xlMoveAndSize esicini ngasinye. Lokhu kuwusizo ikakhulukazi ezincwadini zokusebenza eziyinkimbinkimbi lapho kukhona khona izinkinobho noma ihluzo ezinkulu okuhlakazekile okungase kubangele ingxabano yokufaka ngaphandle kokuthi uqaphele.
Ukuze ugcine ukuhamba komsebenzi wakho kuhlelwe kahle, khumbula ukuthi ungaguqula futhi ububanzi bedatha yakho bube Amathebula e-Excel asemthethweni . Lokhu akugcini nje ngokugwema amanye ala maphutha okufometha, kodwa futhi kusebenzisa ngokuzenzakalelayo imibala nemiklamo emigqeni emisha, kukusindise ekufometheni ngesandla kanye nengozi yokugcwalisa ishidi ngamaseli usebenzisa ukugcwalisa okungabonakali.
Ngamafuphi, ukuze uyeke ukubhekana naleli phutha kufanele uqinisekise ukuthi azikho izinto ezivimba indlela ngokusebenzisa inketho ethi show all noma ukulungisa izakhiwo zazo, futhi uhlanze noma yimiphi iminonjana yokufometha ngengozi ezindaweni ezingenalutho zencwadi yokusebenza ngokususa imigqa namakholomu engeziwe kuze kufike emaphethelweni eshidi.
