Iinkcukacha malunga ukutshintsha indlela amanani e-Excel on the iincwadi

Namhlanje siza kuthetha ukutshintsha indlela amanani e-Excel kwi oonobumba. Kwezinye iimeko kuyimfuneko. Noko ke, abasebenzisi abaninzi owoyamaniswe ukuba umhleli Excel ukuba amanani bamacandelo omiselwe amanani, yena, izithethi bungabonakala oonobumba.

umyalelo

Ukuze ukusombulula umbuzo ukutshintsha indlela amanani e-Excel kwi oonobumba, ingakumbi ukwenza utshintsho abathile isimbo reference. Ukuze wenze oku, yiya etafileni umhleli. Ngenxa yoko, inani lwemihlathi izakubuyiselwa abizwa ncwadi. Qaphela ukuba ixabiso uqwalaselo echazwe igcinwe kwi fayile kunye netafile, ngaloo ndlela evula eziphathekayo, kwixesha elizayo siya ukulayisha wathi parameter. Excel ukubona utshintsho eyenziwe ngaphambili kwaye iza kukhokela inani lwemihlathi ngokungqinelana neemfuno umsebenzisi. Ukuba uvula ezofayile ukuba unalo intsingiselo eyahlukileyo esi sicwangciso, siza kubona indlela ezahlukeneyo nakubalwa iikholam. Ngamanye amazwi, ukuba ufumana itheyibhuli izicwangciso ezingaqhelekanga, baya kuhlala injalo kuzo zonke ezinye izinto.

Excel Iinketho

Sichubeka kwinyathelo elilandelayo ukuze kulungiswe umba kwi Excel ukutshintsha amanani phezu oonobumba iwabonakalalise main menu yangoku yomhleli ngokunqakraza kwi ezinkulu iqhosha zingajikelezi kwikona ephezulu ekhohlo le-window. Ngaphezu koko wehla siya kubona imisebenzi ezimbini. Omnye wabo kuthiwa «Excel Iinketho". Nqakraza kuyo. Ezi amanyathelo ekufuneka yenziwe ngaphandle kokusebenzisa i mouse - kwimenyu engundoqo evulayo xa ucofa iqhosha ALT kuqala ze emva koko "F". Kwelinye icala, ufikelelo evulekile Excel kuyimfuneko parameters ukuvumela ukuba incwadi «M».

links isimbo

Ukuze ukusombulula umbuzo ukutshintsha indlela amanani e-Excel kwi leta, khetha umba "Formula". Le ekhohlo ukuvula useto window. Iphendla i parameter elinoxanduva ukusebenza kunye neefomula. Yeyona nto yokuqala kweli candelo, ziphawulwe ngokuthi "isimbo unxibelelwano", sichaza indlela izithethi ziya kuboniswa onke amaphepha umhleli. Ukuze endaweni inani ngobhalo, asuse uphawu ehambelana bakaKehati yomisa ezichazwe. Uhanahaniso olu hlobo ingaveliselwa ngoncedo kunye mouse kunye nebhodi yezitshixo. Kwimeko yokugqibela, sisebenzisa indibanisela yezitshixo ALT + 1. cinezela iqhosha «Kulungile» Emva zonke izenzo ngasentla. Ngaloo ndlela ke mabarekhode utshintsho ngokwezicwangciso. Kwiinguqulelo ngaphambili le software lokufikelela engundoqo iqhosha menu a imbonakalo eyahlukileyo. Ukuba usebenzisa le magazini "2003" umhleli, sebenzisa "Izilungiselelo" menu. Okulandelayo, yiya kwi "General" tab, uze utshintshe isethingi ye "i R1C1". Ngoko ke ndicinge ukuba ukutshintsha indlela amanani e-Excel kwi oonobumba.