Inkcazo yamakholomu kunye nemigca kwi-Excel ne-Google spreadsheets
Iikholam kunye nemigca yinxalenye ebalulekileyo yiprogram ye- spreadsheet efana ne-Excel kunye ne-Google Spreadsheets. Kwiiprogram ezinjalo, iphepha ngalinye lomsebenzi libekwe kwiphepha legridi nge:
- iikholamu zihamba ngokuzenzekelayo;
- imigqa ehamba ngokuthe ngqo.
Iphepha ngalinye leenguqulelo zakutshanje ze-Excel liqule:
- 16,384 iikholomu;
- 1,048,576 imigca.
Kwi-Google Spreadsheets ubukhulu obungapheliyo bephepha lokusebenzela ngu:
- Iikholomu ezingama-26;
- Imiqolo eyi-100.
Iikholomu kunye nemigqa ingafakwa kwiiSpredishithi zeGoogle ixesha elide ukuba inani elipheleleyo leeseli kwiphepha lokusebenzela alidluli kuma-400,000;
Ngoko ke kukho inamba ehlukeneyo yamakholomu kunye nemigqa, njengale:
- Iikholamu ezingama-50 kunye nee-8,000;
- Iikholomu ezili-100 kunye nee-4,000;
Iikholamu kunye neenhloko zezihloko
Kuzo zombini i-Excel kunye ne-Google Spreadsheets,
- nganye ikholunweyo iboniswe ngeteksi ekhompyutheni yomnxeba eqala ngekholomu A kwaye, kwimeko ye-Excel, isebenza kwi-colum XFD.
- ngamnye umgca uchongiwe ngenani kumqolo olandelwayo, uqala enye.
Ikholomu kunye neendlela zezihloko kunye neeReferensi zeeSeli
Ikhonkco le-intersection phakathi kwekholam kunye nomgca yileli - nganye yeebhokisi ezincinci ezibonwe kwiphepha lokusebenzela.
Kuthathwe ndawonye, iileta zekholomu kunye namanani omqolo kwiintloko ezimbini zidala izikhokelo zeseli , ezichonga indawo nganye zeeseli kwiphepha lokusebenzela.
Izikhombisi zeselula - ezifana ne-A1, F56, okanye i-AC498-zisetyenziswe ngokubanzi kwimisebenzi yespredishithi njengamafomula kunye nalapho kudala amashadi .
Ukugqamisa iMigqomo yonke kunye neeNdlela kwi-Excel
Ukugqamisa yonke ikholomu kwi-Excel,
- nqakraza kwintloko yekholomu;
- cofa iqhosha le Ctrl + Spacebar kwikhibhodi.
Ukugqamisa umgca opheleleyo kwi-Excel,
- nqakraza kwi-header yomqolo;
- cinezela iifayile zeShift + ze-Spacebar .
Ukuqakraza iikholamu kunye neendlela kwiGoogle Spreadsheets
Kwiikholamu ezingenayo idatha,
- Ukucinezela i- Ctrl + I-keybar ibhokisi sele ukhetha lonke ikholomu.
Kwiikholamu ezineenkcukacha,
- ukucima i- Ctrl + Iibha yendawo yekhefu sele ukhetha icandelo lekholomu equkethe idatha;
- ucinezela i- Ctrl + Iibha yendawo yesikhokelo okwesibini ukhetha ikota yonke.
Ngemiqolo engenakho idatha,
- Ukucinezela iifayile zeShift + Spacebar sele ukhetha umqolo wonke.
Imiqolo equkethe idatha,
- ukucindezela iifayile zeShift + zendawo yekhefu sele ukhetha icandelo lomqolo oqulethe idatha;
- Ukucindezela isitshixo seShift + seSithuba seSibini okhethiweyo ukhetha umqolo wonke.
Ukuhamba ngeeRow kunye neeColumns
Nangona usebenzisa i-pointer ye mouse ukucofa kwiiseli okanye ukusebenzisa imivalo ye-scroll, kuyisoloko inokukhetha ukuhamba ngephepha lokusebenzela, kwiifayile ezinkulu zokusebenzela zikwazi ukukhawuleza ukuhamba usebenzisa ikhibhodi. Ezinye izinto eziqhelekileyo ezisetyenziswayo ziquka:
- Ctrl + Utolo oluphantsi -ya kumqolo wokugqibela wephepha lokusebenzela
- Ctrl + Up arrow - gxuma kumqolo wokuqala wephepha lokusebenzela
- Ctrl + Utolo olusekunene - gxuma kumqolo wokugqibela wephepha lokusebenzela
- Ctrl + Itolo lekhohlo - gxuma kwikholamu yokuqala yephepha lokusebenzela
Ukongeza iiKholamu zeeKhowudi kwiShishini lokuSebenza
Inhlanganisela efanayo yekhibhodi ingasetyenziselwa ukongeza zombini iikholam kunye nemigca kwiphepha lokusebenzela:
Ctrl + Shift + "+" (kunye nomqondiso)Ukongeza omnye kunomnye:
- ukhethe lonke ikholomu ukuya ngasekunene kwendawo yekholam entsha
- ukhethe umqolo wonke ngaphaya kwendawo yohlu olutsha
Qaphela: Kwiibhodi eziphambili ezine-Pad Pad ukuya ngasekunene kwebhodibhodi eqhelekileyo, sebenzisa uphawu + apho ngaphandle kwesihluthulelo seShift. Intlangano ebalulekileyo iba:
Ctrl + "+" (kunye nomqondiso)