Izitshixo ezishushu Ungasidibanisa njani iiseli kwi-Excele

Indlela yoku-1: Iqhosha leseli ezininzi

Masiqale ngendlela eklasikhi yokudibanisa iiseli kwi-Excel esebenzisa umsebenzi ngegama elihambelanayo. Nangona kunjalo, ngeli xesha itshintsha indlela yokuyibiza, ixelelwe malunga nezitshixo ezinamatshizi ezijolise ekuhambeni kwezixhobo zenkqubo. Kuya kufuneka wenze uninzi loomatshini bokushicilela, kodwa ukuba uyabakhumbula, ukuvula iqhosha kuya kwenziwa ngokukhawuleza kunokhetho lwalo ngemouse.

1. Khetha iiseli ofuna ukuwudibanisa.



2. Cinezela iqhosha le-Alt ukubonakala kwimenyu ngokhetho lwezenzo kunye neqhosha le-backlit. Khetha i-"yekhaya" ye-theb ye-J. isitshixo



3. Oku kulandelayo kuya kubonisa ipaneli ngezenzo, apho kufuneka uqhubele ukhetho olufumanekayo kwiqhosha le-shcch.



4. Kwimenyu entsha eyehlayo, iinketho ezininzi ezikhoyo zokudibanisa iiseli ziya kuvela. Sebenzisa nayiphi na yazo ngokuxabisa iimfuno zakho.



5. Emva kokuvula iqhosha, ukudibanisa kuya kwenzeka ngokuzenzekelayo ukuba uya kubona ukubuyela etafileni.



6. Nceda uqaphele ukuba ukudibanisa iiseli ezimbini okanye ngaphezulu nganye kuzo kukho ixabiso elithile, kwenzeka ngokuzalisa ixabiso leseli ephezulu yasekhohlo, oko kukuthi, kwaye idatha eseleyo icinyiwe kuphela. Ukongeza, oku kuya kwazisa isaziso senkqubo evelayo.



7. Iziphumo zemanyano yolo manyano olibonayo le skrini ilandelayo.

Indlela 2: Iqhosha kwiPaneli yokuFikelela ekhawulezayo

Ukusebenzisa izitshixo ezishushu kukuthatha ixesha, ke ukuba udibanisa iiseli ze-Excel, ihlala iyimfuneko, kutheni ungazibuyiseli ngeqhosha elinye kwiphaneli yendlela emfutshane. Ukwenza oku, kuya kufuneka wenze ilungiselelo elincinci.

1. Yandisa iMephu yePaneli yokufikelela ngokukhawuleza yokuFunda ngokukhawuleza ngokucofa iqhosha eliphantsi apho ukhetha imithetho.



2. Kuluhlu lweemiyalelo ezikhoyo, fumana "udibanise kwaye ubeke embindini", emva koko ucofe kabini i-LKM kulo mgca okanye usebenzise iqhosha "elongeziweyo".



3. Iqhosha elihambelanayo liya kuvela kuluhlu olungasekunene, okuthetha ukuba longezwe ngempumelelo kwiphaneli yokufikelela ngokukhawuleza kwaye unokuvala ngokukhuselekileyo kule menyu.



4. Njengoko kunokubonwa, iqhosha likho ngasekhohlo apha ngasentla, ihlala ikwimo ecacileyo kwaye eyona iphezulu ichithwayo.



5. Khetha iiseli kwaye ucinezele iqhosha ukuze ufumane utshintsho olufunekayo.

Indlela 3: Intshukumo "Gcwalisa" - "Lungisa"

Ngoncedo lokuhambahamba ngamaqhosha ashushu, njengoko kubonisiwe kwisenzo 1, ungalibiza "-" ukulungelelanisa "-" eziya kulungelelanisa ", eziya kuthi zilungelelanise iziqulatho zeeseli ezilinganayo zezinye iiseli. Eli nqaku alifanelanga xa lisebenza neetafile, kodwa apho kukho isicatshulwa kuphela, kunokuba luncedo. Umgaqo wezenzo zayo uya kubona kule miyalelo ilandelayo.

1. Khetha ikholamu kunye nesicatshulwa ofuna ukugcwalisa kunye nokulungelelanisa uboniso oluchanekileyo.



2. Fowunela i-navigation nge-Alt kwaye ucinezele i-imeyile kwithebhu ephambili.



3. Okokuqala, cofa yu, emva koko uye kwimenyu "yokuhlela".



4. Ngokungeziweyo, cofa kunye nokuvula uluhlu lwe-drop-ezantsi "ukuzalisa".



5. Khetha inyathelo "ulungelelanise" usebenzisa isitshixo se-s.



6. Buyela kuluhlu olunikezelweyo kwaye ujonge iziphumo zesiphumo sokugcwalisa nokulungelelaniswa.