Nyob rau hauv Excel thiab Google los xij, kem npe los yog sab header yog xim gray-xim uas muaj cov tsiaj ntawv (A, B, C, thiab lwm yam) siv los txheeb txhua kem hauv daim ntawv . Sab xaib sab nraud yog nyob saum toj 1 hauv daim ntawv ua haujlwm.
Cov kab ntawv uake los yog kab tshooj yog cov xim gray-xim nyob rau sab laug ntawm kem 1 nyob hauv daim ntawv ua haujlwm uas muaj cov lej (1, 2, 3, thiab lwm yam) siv los txheeb qhia txhua kab hauv daim ntawv.
Kem thiab cov npe thiab cov xov tooj ntawm tes
Tawm ua ke, cov ntawv sau ua ke thiab cov kab zauv nyob hauv ob lub hau lus tsim cov xov tooj ntawm tes uas teev cov tib neeg lub hlwb uas nyob rau ntawm qhov kev sib tshuam ntawm ib kab thiab kab hauv daim ntawv ua haujlwm.
Xov tooj ntawm tes - xws li A1, F56, lossis AC498 - yog siv ntau hauv cov ntawv xov xwm spreadsheet xws li cov qauv thiab thaum tsim cov kab kos .
Kev Tshaj Lawm thiab Kem Sau hauv Excel
Los ntawm lub neej ua ntej, Excel thiab Google Spreadsheets tsis txhob sau cov kem lossis kab ntawv pom ntawm kev tshuaj ntsuam. Luam cov npe ntawm cov kab no feem ntau ua rau nws yooj yim los taug qab qhov chaw ntawm cov ntaub ntawv hauv cov ntawv ua haujlwm loj.
Nyob rau hauv Excel, nws yog ib qho yooj yim teeb meem mus qhib lub feature. Nco ntsoov tias, nws yuav tsum muab rau txhua daim ntawv ua haujlwm luam tawm. Ua kom muaj cov lus qhia hauv ib daim ntawv ua haujlwm hauv phau ntawv no yuav tsis tshwm rau cov kab ntawv thiab kab ntawv sab sau ua rau tag nrho cov ntawv khom nqi.
Ceebtoom : Tam sim no, nws tsis tuaj yeem sau cov kab lus thiab kab ntawv hauv Google Spreadsheets.
Txhawm rau sau cov kem ntawv thiab / lossis kab hau rau daim ntawv sau ua haujlwm tam sim no hauv Excel:
Nias Page Layout tab ntawm txoj hlua .
Nias rau ntawm Sau lub thawv Sau rau ntawm Pawg Cov Ntawv Teev Npe kom qhib lub feature.
Tig Tsawg thiab Kem Lub Npe Los Yog Tawm hauv Excel
Cov kab ntawv hauv qab thiab kab ntawv tsis tas yuav tsum tau sau rau ntawm ib daim ntawv sau ua haujlwm. Cov laj thawj rau txoj kev xa lawv yuav ua kom zoo li daim ntawv ntawm daim ntawv los sis kom tau qhov chaw ntxiv rau cov ntawv ua haujlwm loj - tejzaum nws thaum coj cov duab ntxoo.
Raws li kev luam ntawv, kab ntawv thiab kab ntawv sab nraud yuav tsum muab xa los yog tawm rau txhua daim ntawv rau tus kheej.
Kaw cov kab thiab sab ntawv nyob hauv Excel:
- Nias rau hauv cov ntawv qhia zaub mov kom qhib lub npe ntawm qhov sau tseg.
- Nyem Cov kev xaiv hauv daim ntawv qhib qhib Excel xaiv dialog box.
- Nyob rau hauv seem hauv qab ntawm lub thawv sab laug, nyem rau ntawm Advanced.
- Hauv kev xaiv saib rau hauv daim ntawv ua haujlwm no - nyob ze rau hauv qab ntawm txoj cai pane ntawm lub thawv sab nraud - nyem rau ntawm lub checkbox ntawm qhov Qhia Tsho thiab sab hau kev xaiv kom tshem lub checkmark.
- Kom xu kab thiab kab ntawv sab nraud rau cov ntawv khomob ntxiv rau hauv phau ntawv sau ua haujlwm, xaiv lub npe ntawm lwm daim ntawv ua haujlwm ntawm lub thawv rau ntawm qhov chaw nyob ntawm ib sab ntawm cov kev xaiv zaub rau daim ntawv khij no thiab tshem lub cim khij hauv Show Show thiab column headers kos lub thawv.
- Nias lawv xav kom kaw lub thawv tawm thiab xa rov tuaj rau ntawm daim ntawv ua haujlwm.
Lus Cim : Tam sim no, nws tsis muaj peev xwm xa cov kem ntawv thiab kab ntawv tawm hauv Google nplooj ntawv.
R1C1 Cov lus qhia thiab A1
Yog vim li cas, Excel siv cov lus A1 siv rau cov xov tooj ntawm tes. Qhov no tshwm sim, raws li tau hais tseg, nyob rau hauv kem npe ntawm cov ntawv sau saum cov kab ntawv pib nrog tsab ntawv A thiab cov kab npe uaj displaying tooj pib nrog ib.
Ib qho kev qhia txog lwm qhov chaw - hu ua R1C1 cov neeg ua pov thawj - yog muaj thiab yog tias nws raug qhib, tag nrho cov ntawv ua haujlwm hauv txhua phau ntawv yuav qhia cov zauv es tsis yog cov ntawv sau rau sab ntawv. Cov kab ntawv tseem ceeb ntxiv mus tso saib cov zauv xws li nrog A1 referencing system.
Muaj qee qhov kev zoo rau kev siv R1C1 system - feem ntau thaum nws tuaj cuag cov qauv thiab thaum sau VBA code rau Excel macros .
Txhawm rau muab R1C1 referencing system rau - lossis tawm:
- Nias rau hauv cov ntawv qhia zaub mov kom qhib lub npe ntawm qhov sau tseg.
- Nyem rau ntawm cov kev xaiv hauv daim ntawv qhib qhib Excel xaiv dialog box.
- Nyob rau hauv seem hauv qab ntawm cov lus sib tham, nyem rau ntawm Cov Qauv.
- Hauv kev ua haujlwm nrog cov qauv ntawm sab xis ntawm sab xis ntawm lub thawv sab nraud, nyem rau ntawm lub checkbox ntawm qhov R1C1 reference style xaiv los ntxiv lossis tshem tus cim kos.
- Nias lawv xav kom kaw lub thawv tawm thiab xa rov tuaj rau ntawm daim ntawv ua haujlwm.
Hloov cov ntawv sau rau hauv Kem thiab Kab Headers hauv Excel
Thaum twg yog qhib cov ntaub ntawv tshiab Excel, cov kab ntawv thiab kab ntawv sab sau ua ke siv cov phau ntawv lub ntsiab lus coj los ua ke. Qhov no style style font tseem yog lub neej siv font siv nyob rau hauv tag nrho cov ntawv ua haujlwm hlwb.
Rau Excel 2013, 2016, thiab Excel 365, lub neej ua ntej font yog Calibri 11 pt. tab sis qhov no tuaj yeem hloov tau yog tias nws tsawg dhau, dhau heev lawm, lossis tsis yog rau koj qhov kev nyiam. Nco ntsoov tias, qhov kev hloov no cuam tshuam tag nrho cov ntawv khomob hauv phau ntawv no.
Los hloov qhov qub style chaw:
- Ndliv qhov Tsev Tsev ntawm Ribbon cov ntawv qhia.
- Nyob rau hauv lub pab pawg neeg yeej, nyem Cell Styles qhib lub tshev Cell ntawm nqis palette.
- Txoj cai-nias rau ntawm lub thawv nyob rau hauv lub palette hu ua Niaj hnub - qhov no yog qhov qub style - qhib qhov kev xaiv no lub ntsiab lus teb.
- Nias ntawm Hloov rau hauv cov ntawv qhia zaub mov qhib lub thawv Style.
- Nyob rau hauv lub thawv ntawv, nias ntawm Hom Ntawv khawm qhib lub Hom Tshuaj Khoos Phib Ntoo.
- Hauv no lub thawv thib ob, nyem rau ntawm daim ntawv Tab.
- Hauv Daim Ntawv Keeb Kwm: seem ntawm daim ntawv no, xaiv qhov koj xav tau los ntawm daim ntawv teev npe ntawm kev xaiv.
- Ua lwm yam kev hloov - xws li Font style lossis loj.
- Nyem OK ob zaug, kaw ob lub dialog boxes thiab xa rov tuaj rau ntawm daim ntawv ua haujlwm.
Lus Cim: Yog tias koj tsis tseg cov ntawv ua haujlwm tom qab hloov qhov kev hloov no yuav tsis tau txais kev cawmdim thiab cov phau ntawv yuav rov qab ua dua qub rau lub sijhawm dhau los nws qhib.