Nokusarudza zvikamu zvakasiyana zvemasero - zvakadai semitsetse yakazara, mazamu, mahwendefa e data, kana kunyange mapepa ese ebasa, zvinoita kuti zvikurumidze uye zviri nyore kuita mabasa akawanda muExcel akadai se:
- Kuchinja koronhi yakafara uye zvikamu zvepamusoro .
- Kuchengetedza mapuranga nemitsara yedata .
- Kuisa mapuranga matsva uye mitsetse muhwhepa .
- Kushandisa nhamba kuumbwa .
Nzira Yokusarudza Sei Yose Mireza muPepa Rokushandisa ne Shortcut Keys
Kushandurwa kwebhokisi kwekusimbisa mutsara wose mubhesi remabasa nderokuti:
Shift + Spacebar
Kushandisa Shortcut Keys Sarudza Pepa Rokushanda Row
- Dzvanya pane sero rekushanda riri mumutsara kuti usarudzwa kuti riite sero rinoshanda .
- Dhinda uye ubatisise key Shift pane keyboard.
- Dhinda uye ubudise Spacebar key pabhobhoyo pasina kusunungura key Shift .
- Bvisa Shift key.
- Zvose masero mumutsara wakasarudzwa anofanira kuiswa pachena - kusanganisira iroji musoro .
Kusarudza Zvimwe Zvinyorwa
Kusarudza mimwe mitsetse iri kumusoro kana pasi pemutsara wakasarudzwa
- Dhinda uye ubatisise key Shift pane keyboard.
- Shandisa Up or Down arrow keys in the keyboard to select more rows above or below the row selected.
Sarudza Mitsara NeMouse
Mutsara wose unogonawo kusarudzwa ne:
- Isa mutsananguro weguru mumutsara we nhamba mumutsara weheader - mutsara we mouse inoshandura kumusvi waro unotsanangurira kurudyi sezvinoratidzwa mumufananidzo uri pamusoro.
- Dzvanya kamwe chete nebhokisi reboshwe .
Mitsara yakawanda inogona kusarudzwa ne:
- Isai peinter mouse mumutsara wenhamba mumutsara weheader.
- Dzvanya uye ubatisise ibhokisi reboshwe .
- Dragira mutsara weguru kumusoro kana pasi kuti usarudze nhamba yaidiwa yemitsara.
Nzira Yokusarudza Kwose Columns mune Pepa Rokushanda ne Shortcut Keys
Iko kusanganisa kukuru uko kunoshandiswa kusarudza iyo yose koromo ndeyokuti:
Ctrl + Spacebar
Kushandisa Shortcut Keys Sarudza Pepa Rokushanda Column
- Dzvanyira pane sero rebasa riri mu column inosarudzwa kuti riite sero rinoshanda.
- Dhinda uye ubatisise kamba Ctrl pane keyboard.
- Dhinda uye ubudise Spacebar key pabhobhoyo pasina kusunungura key Shift .
- Bvisa Ctrl .
- Zvose masero muhurukuro yakasarudzwa inofanira kuiswa pachena - kusanganisira iyo koromo musoro.
Kusarudza Zvimwe Zvinyorwa
Kusarudza mamwe mapuranga kune rumwe rutivi rwekamuri yakasarudzwa
- Dhinda uye ubatisise key Shift pane keyboard.
- Shandisa zvigadzirwa zvemanheru kana kurudyi pane keyboard kuitira kuti uwedzere mamwe mazamu kune rumwe rutivi rwekona yakasimbiswa.
Sarudza Columns NeMouse
Yese column inogonawo kusarudzwa ne:
- Isai mutsara weguru pamusana wekoromeri mumutsetse wemusoro-mutsara we mouse unoshandura kumusvi waro unotarisa pasi sezvinoratidzwa mumufananidzo uri pamusoro.
- Dzvanya kamwe chete nebhokisi reboshwe .
Mitsara yakawanda inogona kusarudzwa ne:
- Isa iyo pointer yevhesi pane tsamba yemutsetse iri mumutsetse wemusoro.
- Dzvanya uye ubatisise ibhokisi reboshwe .
- Drags pointer pointer yakasara kana kurudyi kusarudza nhamba yaunoda yemirasi.
Nzira Yokusarudza Mamwe Masepi muExpcel Worksheet ne Shortcut Keys
Pane zvikamu zviviri zvinokosha pakusarudza masero ose ari pepa rekuita nde :
Ctrl + A
kana
Ctrl + Shift + Spacebar
Kushandisa Shortcut Keys Sarudza Mamwe Maseji ari Padhigiramu Yekushandisa
- Dzvanya panzvimbo isina chinhu yepepaiti - nzvimbo isina data mumasero akapoteredza.
- Dhinda uye ubatisise kamba Ctrl pane keyboard.
- Dhinda uye usunungure tsamba Tsanga pabhobho.
- Bvisa Ctrl .
Zvose masero ari mubasa rinofanira kusarudzwa.
Sarudza Meseza Ese Pashanduro Yekushandisa uchishandisa "Sarudza Yose" Button
Kune avo vanosarudza kusashandisa keyboard, Sarudzo Yese Yose ndeimwe imwe nzira yekukurumidza kusarudza masero ose ari pepaji.
Sezvinoratidzwa mumufananidzo wepamusoro, Sarudza Zvose zviri kumusoro kwekona yekweseri kwebasa rekushanda uko musheji wepeji nekhomusoro musoro unosangana.
Kuti usarudze masero ose ari pasi pepaji rekushanda, pinda kamwe chete pane Bhokisi Rese.
Nzira Yokusarudza Mamwe Maseji ari muTebhenakeri yeDheta muExcel ne Shortcut Keys
Zvose masero ari munharaunda yakawanda ye data kana tafura ye data anogona kukurumidza kusarudzwa achishandisa zvidzitiro zvitsva. Pane zvikamu zviviri zvinokosha kusarudza kubva:
Ctrl + A
kana
Ctrl + Shift + Spacebar
Iyi nzira shoma shoma inosanganiswa mitsara inotsvaga yekugadzirisa iyo inoshandiswa kusarudza masero ose mune pepa rekushanda.
Kusarudza Zvimwe Zvikamu zveDheta Dhesi uye Worksheet
Zvichienderana nezvenzira iyo data iri mune pepa rekushongedzerwa yakarongwa yakarongeka, kushandisa zvigadziri zvitsva pamusoro apa zvinosarudza mari yakasiyana yedata.
Kana iyo inoshandiswa sechinosimbidzika inowanikwa mukati mehuwandu hwemashoko ndeyekuti:
- Dhinda Ctrl + A kamwe - Excel inosarudza masero ose ane data mukati.
Kana iyo dhepfenyuro yakatarwa yakave yakarongeka setafura uye ine mutsara wepamusoro une drop drop menus sezvinoratidzwa mumufananidzo pamusoro apa.
- Dhinda Ctrl + A kechipiri - Excel inosarudza mutsara we musoro.
Nzvimbo yakasarudzwa inokwanisa kuwedzerwa kuisa masero ose ari pepaji.
- Dhinda Ctrl + A kechipiri - Excel inosarudza pepa rese.
Nzira Yokusarudza Mahwiti Akawanda Emashandisirwo ari mu Excel Na Shortcut Keys
Haisi kungoenda chete pakati pemashizha mubhuku rebhuku uchishandisa nzira shoma yebhobho, asi unogonawo kusarudza kakawanda mairi mapepa nekatsinho yebhobhoyo zvakare.
Kuti uite saizvozvo, wedzera Shift key kumakwikwi maviri anoonekwa pamusoro apa. Iyo yaunoshandisa inotsamira pasinei nokuti uri kusarudza mapepa kuruboshwe kana kurudyi kwepaji ino.
Kusarudza mapeji kuruboshwe:
Ctrl + Shift + PgUp
Kusarudza mapeji kurudyi:
Ctrl + Shift + PgDn
Kusarudza Mahwendefa Akawanda Kushandisa Mouse uye Keyboard
Kushandisa iyo mouse pamwe ne keyboard keyboard kune rimwe ruzivo pamusoro pekushandisa keyboard chete - inokubvumira kusarudza zvisingasviki mashizha sezvinoratidzwa mumufananidzo uri kumusoro uye pamwe chete.
Zvikonzero zvekusarudza mapepa akawanda emabasa zvinosanganisira:
Kusarudza Multiple Shejent Sheets
- Dzvanya pane imwe pepa tab kuti uisarudze.
- Dhinda uye ubatisise key Shift pane keyboard.
- Dzvanya pane zvimwe zviri pedyo nepeji mapepa kuti uzviise pachena.
Kusarudza Nyaya Dzakawanda Dzisati Dzoka
- Dzvanya imwe pepa tab kuti uisarudze.
- Dhinda uye ubatisise kamba Ctrl pane keyboard.
- Dzvanya pane mamwe mapepa mabhii kuti uonekwe.