Ikholomu ne-Row Headings kuma-spreadsheets e-Excel

Ku-Excel nama-Google AmaSpredishithi, isihloko sekholomu noma isihloko sekholomu ngumugqa ombala obomvu oqukethe izinhlamvu (A, B, C, njll) ezisetshenziselwa ukukhomba ikholomu ngayinye ekhasini lokusebenzela . Isihloko sekholomu sitholakala ngenhla kwe-row 1 kuphepha lokusebenzela.

Umugqa oholayo noma i-header row ikholomu eluhlaza okwesobunxele bekholomu 1 ekhasini lokusebenzela eliqukethe izinombolo (1, 2, 3, njll) esetshenziselwa ukukhomba umugqa ngamunye ekhasini lokusebenzela.

Ikholomu ne-Row Headings kanye namaReferensi yeselula

Kuthathwa ndawonye, ​​izinhlamvu zamakholomu nezinombolo zomugqa ezihlokweni ezimbili zakha izingqikithi zamangqamuzana ezikhomba amangqamuzana athile atholakala ekhoneni lokuhlangana phakathi kwekholomu nomugqa ekhasini lokusebenzela.

Izinkomba zocingo - njenge-A1, F56, noma i-AC498 - zisetshenziselwa kakhulu ekusebenzeni kwesipredishithi njengamafomula kanye nalapho kudala amashadi .

Ukuphrinta Umgqa Wokwakho kanye nekholomu ku-Excel

Ngokuzenzakalelayo, i-Excel nama-Google Spreadsheets awaphrinti ikholomu noma izihloko ze-irowu ezibonwe esikrinini. Ukuphrinta le migqa yokuqondisa ngokuvamile kwenza kube lula ukulandelela indawo yedatha kumashidi amakhulu okunyathelisiwe.

Ku-Excel, kuyindaba elula ukuvula isici. Nokho, phawula ukuthi kumele ivuliwe ukuze ishidi ngalinye liphrinte. Ukuvuselela isici ekhasini elilodwa lokusebenzela ebhokisini lokusebenzela ngeke liholele izihloko zegqawu nekholomu eziphrintiwe kuwo wonke ama-worksheets.

Qaphela : Okwamanje, akunakwenzeka ukuphrinta ikholomu nezinhlobonhlobo zamarowu kuma-Google Spreadsheets.

Ukuphrinta ikholomu kanye / noma izihloko zegqawu zephepha lokusebenzela lamanje ku-Excel:

1. Chofoza ithebhu yekhasi lekhasi lebhebhoni .

2. Chofoza ebhokisini lokuhlola lokuphrinta kwiqembu lezinketho zeSpredishithi ukuze usebenze isici.

Ukuvula ama-Row ne-Column Izihloko ku-Off noma ku-Excel

Izinhlobonhlobo zegqawu nekholomu akudingeki ziboniswe ephepheni elithile lomsebenzi. Izizathu zokuzivala kuzoba ukuthuthukisa ukubonakala kwephepha lokusebenzela noma ukuthola isikhala esingeziwe esikrinini esikhulu semisebenzi - mhlawumbe uma uthatha izifinyezo zesikrini.

Njengokunyathelisa, izihloko zegqawu nekholomu kufanele zivulwe noma zivaliwe kumaphepha ngamunye womsebenzi.

Ukucima umugqa wekholomu kanye nekholomu ku-Excel:

1. Chofoza kwimenyu yefayela ukuze uvule uhlu lokudonsa phansi.
2. Chofoza Izinketho ohlwini ukuze uvule Ibhokisi lengxoxo ye-Excel.
3. Ephini lesokunxele lesibhokisi lebhokisi, chofoza ku- Advanced.
4. Kokukhethwa kukho kokubonisa kwalesi sigaba somsebenzi - eseduze nendawo engezansi kwesobunxele bebhokisi lengxoxo - chofoza ebhokisini lokuhlola eduze kweKhombisa umugqa wekholomu nezinhlobonhlobo zekholomu ukuze ususe uphawu lokuhlola.
5. Ukucima i-row kanye nezihloko zekholomu ukuze uthole amafomu okusebenza engeziwe ebhokisini lamanje, khetha igama lenye ishidi lokusebenzela kusuka ebhokisini elidonsela phansi eliseduze nezinketho zokubonisa kulolu shicilelo lokusebenzela bese usula uphawu lokuhlola kumakhanda ekhombisa irowu nekholomu hlola ibhokisi.
6. Chofoza OK ukuvala ibhokisi lengxoxo bese ubuyela ekhasini lokusebenzela.

Qaphela : Okwamanje, akunakwenzeka ukuvula ikholomu nezihloko zegqawu ku-Google AmaSpredishithi.

Ama-R1C1 Okubhekiselwe ngokumelene no-A1

Ngokuzenzakalelayo, i-Excel isebenzisa isitayela sokubhekisela se-A1 samakholi weselula. Lokhu kuboniswa, njengoba kukhonjisiwe, ezihlokweni zekholomu kubonisa izinhlamvu ngaphezulu kwekholomu ngayinye eqala ngencwadi A kanye nomugqa okhombisa izinombolo ezibonisa kuqala.

Enye indlela yokubheka kabusha - eyaziwa njengezikhombisi-R1C1 - iyatholakala futhi uma ivuliwe, wonke ama-worksheets kuzo zonke izincwadi zokusebenzela azobonisa izinombolo esikhundleni sokubhala izinhlamvu ezihlokweni zekholomu. Izihloko zegqawu ziyaqhubeka nokubonisa izinombolo njenge-A1 reference reference system.

Kunezinzuzo ezithile zokusebenzisa uhlelo lwe-R1C1 - ikakhulukazi uma kuziwa emafomula futhi uma ubhala ikhodi ye-VBA ye- Excel macros .

Ukuvula uhlelo lokubhekisela kwe-R1C1 - noma luvale:

1. Chofoza kwimenyu yefayela ukuze uvule uhlu lokudonsa phansi.
2. Chofoza kwi Izinketho ohlwini ukuze uvule Ibhokisi lengxoxo ye-Excel.
3. Kwiphepha lesokunxele lebhokisi lebhokisi, chofoza amafomula.
4. Ekusebenzeni ngefomula lesigaba sekhasi lesokudla ngakwesobhokisi lebhokisi, chofoza ebhokisini lokuhlola eduze ne- R1C1 inketho yesitayela sokubheka ukuze ungeze noma ususe uphawu lokuhlola.
5. Chofoza OK ukuvala ibhokisi lengxoxo bese ubuyela ekhasini lokusebenzela.

Ukushintsha Ifonti Okuzenzakalelayo Kukholomu Nama-Row Headers ku-Excel

Njalo uma ifayela elisha le-Excel livuliwe, izihloko zegqawu nekholomu ziboniswa usebenzisa ifonti yokusebenza yesimo esivamile. Lefonti yesitayela evamile iyisitayela esizenzakalelayo esetshenziselwa kuwo wonke amaseli okusebenzela.

I-Excel 2013, 2016, ne-Excel 365, ifonti yokushaya okuzenzakalelayo ngu-Calibri 11 pt. kodwa lokhu kungashintshwa uma kuncane kakhulu, kucace kakhulu, noma kungabi nje ukuthanda kwakho. Nokho, phawula ukuthi lolu shintsho luthinta wonke ama-worksheets encwadini yokusebenzela.

Ukushintsha izilungiselelo zesitayela ezivamile:

1. Chofoza kuthebhu yaseKhaya yemenyu yeRibbon.
2. Eqoqweni lezitayela, chofoza i- Cell Styles ukuze uvule i-palette ye-Cell Styles ehlaselwa phansi.
3. Chofoza ngakwesokudla ebhokisini le-pallet elinesihloko esijwayelekile - lokhu kuyisitayela esivamile - ukuvula imenyu yokuqukethwe yenketho.
4. Chofoza ukuguqula kwimenyu ukuvula ibhokisi lengxoxo yesitayela.
5. Ebhokisini lebhokisi, chofoza inkinobho Yefomathi ukuvula ibhokisi lengxoxo yefomathi yefomathi.
6. Kulo bhokisi lesibili lebhokisi, chofoza kuthebhu yefonti.
7. Efonini: ingxenye yalethebhu, khetha ifonti oyifunayo ohlwini lokudonsa lokukhetha.
8. Yenza noma yiziphi izinguquko ezithandayo - njengezitayela zefonti noma usayizi.
9. Chofoza KULUNGILE kabili, ukuvala kokubili amabhokisi engxoxo bese ubuyela ekhasini lokusebenzela.

Qaphela: Uma ungalondolozi ibhukwana ngemuva kokwenza lolu shintsho ushintsho lwefonti ngeke lusindiswe futhi ibhuku lokusebenzela lizobuyela emuva kumuntu oyifakile esikhathini esizayo lapho ivuliwe.