Column uye Row Headings mu Excel Spreadsheets

MuExcel neGoogle Sheets, iyo koromusoro musoro kana koronti musoro ndiyo mutsara wakaita ruvara rine mabhii (A, B, C, etc.) anoshandiswa kutarisa imwe chinyorwa mune pepa rekushanda . Musoro wemusoro wepamusoro uri pamusoro pemutsara 1 mubasa rekushanda.

Mutsara unotungamira kana mutsara wemusoro ndeyendarama yakafuridzirwa iri kuruboshwe rwekoramende 1 mubasa rinoshandiswa rine nhamba (1, 2, 3, nezvimwewo) yakashandiswa kugona rutsara rimwe nerimwe mubasa rekushanda.

Column uye Row Headings uye Cell References

Zvakatorwa pamwe chete, mavara emakoromoni uye mutsara yemutsara mumusoro miviri inoita masero ekufambisa ayo anoratidza masero ega anowanikwa kumativi ekutenderera pakati pendarama nemutsara mune pepa rekushanda.

Nhamba dzezviratidzo - dzakadai seA1, F56, kana AC498 - dzinoshandiswa zvakanyanya mumashandi eparashiriti zvakadai semafomu uye pakuumba marati .

Printing Row and Column Headings in Excel

Nokusingaperi, Excel neGoogle Spreadsheets haisi kudhinda iyo koroni kana mutsara yemuvara inoonekwa pahwindo. Kunyora iyi mitsetse inowanzoita kuti zvive nyore kutarisa nzvimbo ye data mumabhuku makuru akadhindwa.

MuchiExcel, iyo nyaya yakanyanyisa kuita chiitiko chacho. Cherechedza, zvisinei, kuti inofanira kushandurwa kuti pepa rimwe nerimwe rekunyora ridhindwe. Kushandisa chiitiko pane rimwe bhuku riri mubhuku rebhuku hakuzoiti kuti mutsara uye zvinyorwa zvinyorwa zvinyorwa zveese mapepa.

Cherechedza : Ikozvino, hazvibviri kudhinda chinyorwa uye mutsara wepaGoogle Spreadsheets.

Kuti udhindise iyo koromo uye / kana mutsara mutsara wepaji rekushanda ririmo mu Excel:

1. Dhodza Page Peji yebhu yebhoni .

2. Dzvanya paBhokisi rekutsvaga reChirangaridzo muchikwata cheSaet Options kuti uite chinhu chacho.

Kutora Row uye Column Musoro Unoenda Kana Wabuda muExcel

Mutsara uye zvinyorwa zvinyorwa hazvifanirwi kuiswa pane imwe pepa pepaji. Zvikonzero zvekuvadzinga zvingave kuvandudza maitiro echidimbu chebasa kana kuti kuwana nzvimbo yakawanda yekiratidziro pamashizha makuru ebasa - zvichida paunotora zvidzidzo zvekrini.

Sezvakaita nekudhinda, mutsetse uye hutatu misoro inofanira kuvharwa kana kuvharwa kune rimwe nerimwe pepa pepaji.

Kuchenesa mutsara uye columusoro inonzi Excel:

1. Dzvanya paFirimu menyu kuti uzarure rondedzero.
2. Dzvanya Zvisarudzo mukati mutsamba kuzarura Excel Options dialog box.
3. Muchikamu chekuruboshwe-bhokisi rebhokisi rebhokisi, chengeta paZvikwata.
4. MuChiratidzo zvingasarudzwa zvechikamu chebasa iri - chiri pedyo nechokumucheto kwemaoko ekurudyi kwebhokisi rebhokisi - chengetedza pabhokisi rinotevera pedo Ratidza mutsara nemutsetse wemusoro zvakasarudzwa kuti ubvise checkmark.
5. Kuti udzire mutsetse uye hutatu huripo kune mamwe mahwhepa ebhuku rino rekushanda, sarudza zita reimwe pepa rekushanda kubva kubhokisi rebhokisi riri pedyo neChiratidzo zvarongwa zvebhuku rino rekushanda uye chesa chekucherechedza muRatidza mutsara nemumusoro wemusoro. chengeta bhokisi.
6. Dzvanya OK kuti uvhare bhokisi rebhokisi uye dzokera kubheji rekushanda.

Cherechedza : Ikozvino, hazvibviri kuchinja mutsara uye mutsara mutsara paGoogle Sheets.

R1C1 References vs. A1

Nekusavapo, Excel inoshandisa A1 referenti yekufananidzira kwezvikamu zvinyorwa. Izvi zvinoguma, sezvinotaurwa, mumusoro wehurukuro kuratidzira tsamba pamusoro pevhapi imwe neimwe kutanga nemutsamba A uye mutsara unotungamira nhamba dzinoratidza nhamba dzinotanga nemumwe.

Imwe nzira yekutsanangurira inozivikanwa - inozivikanwa seR1C1 zvinyorwa - inowanika uye kana ikabviswa, mapepa ose emabhuku mubhuku rose rebasa acharatidza nhamba pane kuti ave netsamba mumusoro wehurukuro. Mitsetse yepamutsara inoenderera mberi kuratidza nhamba seyo neA1 referencing system.

Pane zvimwe zvinobatsira kushandisa R1C1 system - kunyanya pazvinosvika pakufananidzira uye pakunyorera VBA code ye Excel macros .

Kutsigira R1C1 referencing system pa - kana kuvhara:

1. Dzvanya paFirimu menyu kuti uzarure rondedzero.
2. Dzvanya pane Zvaunenge uri pane urongwa kuti uzarure Excel Options dialog box.
3. Muchikamu chekuruboshwe-bhokisi rebhokisi rebhokisi, chengetai Mafomu.
4. MuKushanda pamwe neshoko remuchina wekona-kuruoko rworudyi rwebhokisi rebhokisi, chengetera pabhokisi riri pedyo neR1C1 referenced style yekusarudza kuwedzera kana kubvisa check check.
5. Dzvanya OK kuti uvhare bhokisi rebhokisi uye dzokera kubheji rekushanda.

Kushandura Zvisizvo Zvakanyorwa muChongwe uye Row Headers mu Excel

Chero pose apo imwe itsva Excel file yakazarurirwa, mutsara nehurukuro zvinyorwa zvinoratidzwa uchishandura bhuku rebhuku rinowanzoshandurwa. Iyi Nyore yepafaira yemhando ndiyo inoshandiswa kushandiswa mumasero ese ekushanda.

For Excel 2013, 2016, uye Excel 365, iyo isina musoro musoro musoro ndeye Calibri 11 pt. asi izvi zvinogona kuchinjwa kana zviduku zvikuru, zvakajeka, kana kungofanana nekunaka kwako. Cherechedza, zvisinei, kuti shanduko iyi inokanganisa mapepa ose ebhuku rebhuku.

Kuti uchinje maitiro akajairika maitiro:

1. Dzvanya paImba yebhu ye menu Ribbon.
2. Muchikwata cheStyles, chengetedza Cell Styles kuti uzarure palette yeStart Styles re-down-down.
3. Kungofa-bhota pabhokisi riri muchikwata chinonzi Normal - iyi ndiyo tsika Yakajairika - kuti uzarure mamiriro ekugadzirisa mamiriro ezvinhu aya.
4. Dzvanya paGadzirisa pane menyu kuti uzarure Shanduko yebhokisi rebhokisi.
5. Mubhokisi rebhokisi, chengetera pane Bhiiyo reMafuta kuti uzarure maBheji eDaily dialog box.
6. Muchikamu chechipiri bhokisi rebhokisi, chengeta paText tab.
7. Mutsamba: chikamu chetabhenakeri iyi, sarudzai mapepa aidiwa kubva pakuderera pasi kwezvakasarudzwa.
8. Ita chero humwe humwe hunodiwa hunoshandiswa - hwakadai sePaul style kana kuti ukuru.
9. Dzvanya OK kaviri, kuti uvhare zvose dialog boxes uye dzokera kushizha.

Cherechedza: Kana iwe usingagoni kuchengetedza bhuku rebasa mushure mokuita shanduko iyi kuchinja kwemaitiro hakuzochengetedzwe uye bhuku rebhuku richadzoka kudzokera kumasimboti apfuura panguva inotevera yazarurirwa.