Kazhinji, masero ane zvinyorwa muExcel neGoogle Sheets anoratidza mhinduro kune zvinyorwa zvose nemabasa ari mubhuku remabasa.
Muchikamu chikuru chemashizha, kusvoterera zvakapoteredza neve mouse pointer kuti uwane masero ane mibomira iyi kana mabasa anogona kunge ari kurohwa kana kupotsa basa.
Ratidza Mafomu muExcel neGoogle Sheets uchishandisa Shortcut Keys
Bvisa mafungiro ekufungidzira paunowana mazano kuburikidza uchishandisa mushomanana wekodhi yekubatanidza kuratidza mazita ose muExcel neGoogle Sheet:
Ctrl + `(grave accent key)
Pamusoro petikwiti yakawanda, kemikisi yekukwirira yakadzika iri pedyo nenhamba nhamba 1 kumusoro kwekona yepamusoro yebhodi. Inoratidzika semushure we apostrophe.
Iri sangano rinokosha rinoshanda sechinhu chinoshandiswa pakushandura, izvo zvinoreva kuti iwe unodzvinyirira chinhu chimwechete chekubatanidza zvakare kuti uvanze mafomu kana wapedza kuaona.
Matanho ekuratidzira zvose maformu
- Dhinda uye ubatisise kamba Ctrl pane keyboard.
- Dhinda uye usunungure kemikisi yekunyora kwekomba pabhobhoyo pasina kusunungura Ctrl key.
- Bvisa Ctrl .
Pepa rekushanda rinofanira kuratidza mafomu ose mumasero avo ekushanda pane zvigumisiro.
Ku-Kuvanza Mafomu
Kuti uratidze mhinduro zvakare panzvimbo yemafomu, faira maCtrl + ` keys zvakare.
Nezve Kuratidza Mafomu
- Ratidza mazamu haashanduri zviri mukati pepaji, asi nzira iyo inoratidzwa.
- Ratidza mavara anoita kuti zvive nyore kuwana masero ane maforamu.
- Iko inokubvumira kuti uverenge nekukurumidza kuburikidza nemazita ose kuongorora zvikanganiso.
- Nyaya yacho inogonawo kushandiswa nekusarudza:
- Mifananidzo > Ratidza mafananidzo pamabhoni muExcel
- Ona > Zvose zvaunosarudza pane menyu muGoogle Sheets
- Kushandura mapepa ebhidhiyo ne Show Showms akazarurwa kunogona kuita kuti zvive nyore kutsvaga zvakaoma kuti uwane zvikanganiso.
Ratidza Mumwe Nomumwe Mapepa Mafomu
Panzvimbo pokuona maitiro ose, zvinobvira kuona maitiro imwe panguva imwe chete ne:
- Kudonha kaviri pane sero rine chinyorwa uye mouse.
- Kushandura kamwe chete pachitokisi chine rondedzero ne mouse uye zvino kumanikidza F2 key pane keyboard.
Zvose izvi zviito zvinogadzirisa purogiramu-kana Excel kana Google Sheets-mu-edit mode, iyo inoratidzira fomu iri muchitokisi uye zvinyorwa muvaraidza zvinyorwa zvinoshandiswa mumutambo. Izvi zvinoita kuti zvive nyore kutsvaga zvinyorwa zvemashoko zvinoshandiswa mumutambo.
Viga Mapurisa muEccel Using Protect Sheet
Imwe nzira yekuvanza mazano mu Excel ndeyokushandisa kuchengetedza pepa rekushanda , iyo inosanganisira chisarudzo chekudzivirira mafomu mumasero akavharidzirwa kubva pakuonekwa munzvimbo idzi:
- Muchitokisi kwavari
- Muchizamu chemuzamu apo sero rine rondedzero rakanamirwa
- Apo Show Showmulas inoshandiswa kana kushandisa shanduro yebhokisi kana kuburikidza nebhoni.
Kuvhara mazamu, sekuvhara masero, inotsika matanho maviri anosanganisira kuongorora mararamiro emasero waunoda kuvanza uye zvino kushandisa chekushanda chekushanda.
Sarudza Cell Range kuvanza
- Sarudza uwandu hwemasero ane mafomu ekuvanzwa.
- PaImba yebhu yebhoni, tsvaga paBhidhiyo yeBuritsa kuti uzarure mhando inodonha.
- Mune menyu, chengetai ma Format Cells kuti uzarure maBheji eDaily dialog box.
- Mubhokisi rebhokisi, chengetedza paKachengetedzwa tab.
- Pamusoro pebhu ino, sarudza Hidden check box.
- Dzvanya OK kuti ushandise shanduko uye uvhare bhokisi rebhokisi.
Isa Kushandura Purogiramu Yebasa
- PaImba yebhu yebhoni, tsvaga paFomenti yekusarudza kuti uzarure menyu inodonha.
- Dzvanya paKachengetedza Sheet sarudzo pasi pezveru kuti uzarure bhokisi rekudzivirira reSpect Sheet.
- Chengetedza kana kusanudza zvaunoda.
- Dzvanya OK kuti ushandise kuchinja uye uvhare bhokisi rebhokisi.
Panguva ino, mazita akasarudzwa anofanira kunge akavanzwa kubva pakuona muburani remurairi. Kusvikira danho rechipiri richiitwa, maitiro acho anoramba achionekwa mueseji yebasa rekushanda uye muburani rekushandisa.