Incazelo yekholomu nemigqa kuma-spreadsheet e-Excel nama-Google
Amakholomu nemigqa yiyingxenye eyinhloko yanoma yiluphi uhlelo lwesipredishithi njenge-Excel ne-Google Spreadsheets. Kulezinhlelo ezinjalo, ishidi ngalinye lomsebenzi lihlelwe iphethini yegridi nge:
- amakholomu asebenza ngokuqondile;
- imigqa egijima ngokuzenzekelayo.
Iphepha lokusebenza ngalinye ezinguqulo zamuva kakhulu ze-Excel liqukethe:
- Amakholomu angu-16 384;
- Imigqa engu-1,048,576.
Ku-Google Spreadsheets usayizi ozenzakalelayo wephepha lokusebenzela ngu:
- Amakholomu angu-26;
- Imigqa eyi-100.
Amakholomu nemigqa ingezwa kuma-Spreadsheets we-Google uma nje inani lezingqamuzana zamaseli ngeshidi lomsebenzi lingadluli ku-400,000;
Ngakho-ke kungaba khona inamba ehlukene yamakholomu nemigqa, njenge:
- Amakholomu angu-50 nemigqa engu-8,000;
- Amakholomu angu-100 nemigqa engu-4,000;
Ikholomu ne-Row Headings
Kokubili i-Excel ne-Google Spreadsheets,
- ikholomu ngayinye ikhonjiswe ngencwadi ekhoneni yekholomu eqala ngekholomu A futhi, uma kwenzeka i-Excel, iqhubekela kukholomu XFD.
- umugqa ngamunye ukhonjiswe ngenombolo ekhanda lomugqa, kusukela ekuqaleni.
Ikholomu ne-Row Headings kanye namaReferensi yeselula
Iphuzu lesiphambano phakathi kwekholomu nomugqa iyiseli - ngayinye yamabhokisi amancane abonakala ephepheni lokusebenzela.
Kuthathwa ndawonye, izinhlamvu zekholomu nezinombolo zomugqa ezihlokweni ezimbili zakha izingqikithi zamangqamuzana , ezikhomba izindawo ezithile zeseli ekhasini lokusebenzela.
Izinkomba zocingo - njenge-A1, F56, noma i-AC498 - zisetshenziselwa kakhulu ekusebenzeni kwesipredishithi njengamafomula kanye nalapho kudala amashadi .
Ukuqokomisa wonke amakholomu nemigqa e-Excel
Ukugqamisa lonke ikholomu ku-Excel,
- chofoza kusihlokweni sekholomu;
- cindezela okhiye we- Ctrl + Spacebar ekhibhodi.
Ukugqamisa umugqa wonke ku-Excel,
- chofoza kusihlokweni somugqa;
- cindezela okhiye be- Shift + Spacebar .
Ukuqokomisa wonke amakholomu nemigqa ku-Google Spreadsheets
Ngamakholomu ongekho idatha,
- ukucindezela ukhiye we- Space Ctrl + ukhethe lonke ikholomu.
Amakholomu aqukethe idatha,
- ukucindezela ukhiye we- Space Ctrl + ukhethe isigaba sekholomu equkethe idatha;
- ukucindezela ukhiye we- Space Ctrl + okwesibili ukhetha lonke ikholomu.
Ngemigqa engekho idatha,
- ukucindezela okhiye be- Shift + Spacebar ukhethe ukhetho lonke.
Ngemigqa equkethe idatha,
- ukucindezela okhiye be- Shift + Spacebar ukhethe ingxenye yesigcawu equkethe idatha;
- ukucindezela ukhiye we- Space Shift + okwesibili ukhetha wonke umugqa.
Ukuzula imigqa namakholomu
Nakuba usebenzisa i-pointer yegundane ukuchofoza kumaseli noma ukusebenzisa imishayo yokuphenya, njalo kuyindlela yokukhetha ukuhamba eduze kwephepha lokusebenzela, ukuze uthole amafomethi amakhulu angashesha ukuhamba usebenzisa ikhibhodi. Ezinye izinhlanganisela ezijwayelekile ezisetshenziswayo zihlanganisa:
- Umcibisholo we- Ctrl + -jelela emgqeni wokugcina wephepha lokusebenzela
- Umcibisholo we- Ctrl + Up - gxumela emgqeni wokuqala wephepha lokusebenzela
- Ctrl + Umcibisholo ongakwesokudla - gxumela kukholomu yokugcina yephepha lokusebenzela
- Ctrl + Umcibisholo ongakwesokunxele - gxuma kukholomu yokuqala yephepha lokusebenzela
Ukwengeza Amakholomu Emigqa ekhasini lokusebenzela
Inhlanganisela efanayo yekhibhodi yekhibhodi ingasetshenziswa ekwengezeni kokubili amakholomu nemigqa kushidi lokusebenzela:
Ctrl + Shift + "+" (plus uphawu)Ukwengeza eyodwa kunokunye:
- khetha lonke ikholomu ngakwesokudla kwendawo ikholomu entsha
- khetha lonke umugqa ngaphezu kwendawo emgqeni omusha
Qaphela: Kumakhibhodi ane-Pad Pad ngakwesokudla kwekhibhodi evamile, sebenzisa isibonakaliso + lapho ngaphandle kwesihluthulelo se-Shift. Inhlanganisela ebalulekile iba:
Ctrl + "+" (plus uphawu)