Kugadzira Numeri mu Excel Kushandisa Shortcut Keys

Kugadziridza kuchinja kunoitwa kuExpcel mapepa kuitira kuti uwedzere maitiro avo uye / kana kutarisa pfungwa pane imwe nyaya yakarongeka.

Kugadzirisa kuchinja kuonekwa kwe data, asi hakushanduri data chaiyo muchitokisi, izvo zvingave zvakakosha kana iyo data inoshandiswa mukuverenga. Semuenzaniso, kuumba mafaira kunoratidza mbiri mbiri dzepamusoro hadzina kupfupisa kana kuti zvakatipoteredza zvigaro nematunhu anopfuura makumi maviri.

Kuti uchinje nhamba idzi nenzira iyi, data inofanira kuve yakakomberedza uchishandisa rimwe reEntcel rokutarisa mabasa.

01 ye 04

Kugadzirisa Numeri mu Excel

Nhamba yehuwandu hwekufambisa muExcel inoshandiswa kuchinja kuonekwa kwechiverengero kana kukosha mune imwe sero mubasa rekushanda.

Nhamba yehuwandu inosanganiswa nesero uye kwete kukosha mumusero. Mune mamwe mazwi, kuumbwa kwenhamba hakushandisi nhamba chaiyo muchitokisi, asi nenzira iyo inooneka.

Semuenzaniso, sarudza sero yakave yakarongedzwa nekuda kwezvakaipa, zvakakosha, kana kuti yakareba nhamba uye nhamba yakajeka pane kuti nhamba yakagadziridzwa inoratidzirwa mubha yefomu pane pepa pepaji.

Nzira dzakaputirwa nekushandura nhamba yekufambisa dzinosanganisira:

• shortcut key on the keyboard;
• kuumba zvidhori paibhoni ;
• iyo Format Cells dialog box .

Nhamba yekunamata inogona kushandiswa kune imwe sero, mazamu ese kana mitsetse, sarudzo yakasarudzwa yemasero, kana kuti pepa rese rekushanda.

Izvo zvisina kumira maitiro emaseli ane data yose ndeyeGaraiyo maitiro. Iyi maitiro haana mhando yakarongeka uye, nekutadza, inoratidza nhamba dzisina dhora zviratidzo kana mazai uye nhamba yakavhenganiswa - nhamba dzine chine chikamu chiduku-hachirevi kune imwe nhamba yedzimba dzepamusoro.

02 of 04

Kushandisa Kuburitsa Nhamba

Iko kusanganiswa kukuru uko kunogona kushandiswa kushandisa nhamba yekufambisa kune data ndeyekuti:

Ctrl + Shift + ! (kudanidzirwa pfungwa)

Mifananidzo yakashandiswa kune nhamba yakasarudzwa yedhidhi uchishandisa zvitsva zvitsva ndeyi:

• maviri decimal nzvimbo
• the comma as thousands separator (,)

Kushandisa nhamba kuronga kune deta uchishandisa zvigetsi zviduku:

1. Simbisai masero ane data kuti aenzaniswe
2. Dhinda uye ubatisise Ctrl uye Shift keys pane keyboard
3. Shingairira uye musunungure chinhu chekutsvaga (!) - iri pamusoro pe nhamba 1 - pabhobhoyo pasina kusunungura Ctrl uye Shift keys
4. Bvisa Ctrl uye Shift keys
5. Apo zvakakodzera, nhamba mumasero akasarudzwa achaumbwa kuti aratidze mafomu akataurwa pamusoro apa
6. Kushandura chero ipi zvayo yemasero inoratidza nhamba yepakutanga isina kufananidzwa mubha yemurairi pane pepa pepaji

Cherechedza: kune nhamba dzinopfuura mbiri mbiri dzinoshandiswa chete dzinotanga mbiri mbiri dzekupedzisira dzinoratidzwa, zvimwe zvacho hazvisati zvabviswa uye zvichiri kushandiswa mukuverenga zvinosanganisira aya maitiro.

Isa Kushandura Nhamba Uchishandisa Kushandiswa kweRibbon

Kunyange zvazvo maitiro mashoma anowanzoshandiswa aripo semufananidzo wemufananidzo paImba yebhu yebhoni, sezvinoratidzwa mumufananidzo uri pamusoro, mafomu akawanda ehuwandu ari muNhamba yeNhamba yeDhete -pasi-iyo inoratidza Gara sechinangwa chemajeri chemasero Kushandisa zvinyorwa zvinotevera:

1. Simbisai masero e data kuti aenzaniswe
2. Dzvanya pamusana weveve museve uri pedyo neNhamba yeFomeni yebhokisi kuti uzarure rondedzero
3. Dzvanya pane Nhamba yakasarudzwa muurongwa kushandisa iyi sarudzo kumasero akasarudzwa yedata

Numeri yakarongedzwa kune mbiri dzedzimba dzakadai sekibhokisi rekutsinhanisa pamusoro, asi comma separator haisati yashandiswa neyiyi nzira.

Isa Kushandura Nhamba muBhokisi Rejeri Rejeri Dialog

Nzira dzose dzekuita mafaira dzinowanika kuburikidza neFomendi Cells dialog box .

Pane zvingasarudzwa zviviri zvekuvhura bhokisi rebhokisi:

1. Dzvanya pabhokisi rebhokisi rebhokisi - diki rezasi rinotarisa rakatarisa muzasi kwekona yekona yeNhamba yekiyo yeboka pane ribhoni
2. Dhinda Ctrl + 1 pane keyboard

Mafomu ekufambisa maScellaneous mubhokisi rebhokisi akabatanidzwa pamwe chete pamatabheti eine nhamba dzenhamba dziri pasi peNhamba tab.

Pamusoro pebhu ino, mafomu anowanikwa akaparadzaniswa kuva zvikamu muwindo reboshwe. Dzvanya pane imwe sarudzo muhwindo uye maitiro uye sampuko yeyo sarudzo inoratidzwa kurudyi.

Kushandura Nhamba muhwindo rekuruboshwe kunoratidza unhu hunogona kugadziriswa

• nhamba yenzvimbo dzepamusoro dzakaratidzwa
• kushandiswa kwe comma separator yezviuru
• kuratidza zvisarudzo zvenhamba dzisina kunaka

03 of 04

Shandisa Mari Kuchinja

Kushandisa Kugadzirisa Kwemari Kushandisa Kushandura Kwenyika

Iko kusanganisa kukuru uko kunogona kushandiswa kushandiswa kwemari kushandiswa kune deta ndeyokuti:

• Ctrl + Shift + $ (chiratidzo chemadhora)

Izvo zvisiri izvo zvigadziro zvemari zvinoshandiswa kune yakasarudzwa data uchishandisa zvidzitiro zvitsva ndezvi:

• iro chiratidzo chemadhora
• maviri decimal nzvimbo
• the comma as thousands separator (,)

Matanho ekushandisa kushandisa mari yekugadzirisa uchishandisa Shortcut Keys

Kuisa mari yekufambisa kune deta uchishandisa mashomanana ekutsvaga:

1. Simbisai masero ane data kuti aenzaniswe
2. Dhinda uye ubatisise Ctrl uye Shift keys pane keyboard
3. Dhinda uye usunungure kiyi yechirwere chechirwere ($) - iri pamusoro pe nhamba 4 - pabhobhoyo pasina kusunungura Ctrl uye Shift keys
4. Bvisa Ctrl uye Shift keys
5. Masero akasarudzwa achaenzaniswa nemari uye, kana zvichibvira, ratidza mafomu akataurwa pamusoro apa
6. Kushandura chero ipi zvayo yemasero inoratidza nhamba yepakutanga isina kufananidzwa mubha yemurairi pane pepa pepaji.

Isa Kushandura Kwemari Kushandiswa Nokusarudza Ribhoni

Mhando yemari inogona kushandiswa kudhipatimendi nekusarudza Mari yakasarudzwa kubva kuNhamba yeDhigiriji yezvinyorwa pasi.

Chiratidzo chemadhora ( $) icon iri muNhamba yeNhamba paImba yebhu yebhoni, haisi yeMari yemafidhi asi yehuwandu hweAkaunti sezvainoratidzwa mumufananidzo uri pamusoro.

Mhedzisiro huru pakati pezviviri ndeyokuti kuenzanisa kwekugadzirisa kunoenzanisa dhora rekuraira kune rumwe rutivi rworuboshwe rwekero panguva yekugadzirisa dhiyoyo pachayo kurudyi.

Isa Kushandura Kwemari Mukudhindwa Kwemajeri eDhiyabhorosi Dialog

Iko shanduro yemari iri mu Format Cells dialog box yakafanana zvikuru neyomumiririri wefaira, kunze kwekusarudza kusarudza imwe shanduko yemari kubva pane chikwangwani chema dollar.

Iyo Format Cells dialog box inogona kuvhurwa imwe yenzira mbiri:

1. Dzvanya pabhokisi rebhokisi rebhokisi - diki rezasi rinotarisa rakatarisa muzasi kwekona yekona yeNhamba yekiyo yeboka pane ribhoni
2. Dhinda Ctrl + 1 pane keyboard

Mubhokisi rebhokisi, tora paDhidha mune chikamu chinyorwa kuruboshwe-kuru kutarisa kana kushandura zvirongwa zvemazuva ano.

04 we 04

Isa Chimiro chePententi

Iva nechokwadi chokuti deta iri kuiswa mumapurogiramu mafomu inowanikwa mufomu yemadhora - sa 0.33 - iyo, kana yakarongerwa nokuda kwezana, inoratidza zvakanaka se 33%.

Kunze kweiyo nhamba 1, integers - nhamba dzisina chikamu chekuwedzera - hachiwanzo kuenzaniswa kwepakati sezvo hutsika hunoratidzwa hunowedzerwa nechimwe chezana.

Somuenzaniso, kana yakasanganiswa nokuda kwezana:

• nhamba 1 yaizoonekwa se100%;
• nhamba 33 yaizoonekwa se 3300%.

Isa Kushandura Kwema Percent Using Kushandura Keys

Iko kusanganiswa kukuru uko kunogona kushandiswa kushandisa nhamba yekufambisa kune data ndeyekuti:

Ctrl + Shift + % (percent symbol)

Mifananidzo yakashandiswa kune nhamba yakasarudzwa yedhidhi uchishandisa zvitsva zvitsva ndeyi:

• 0 decimal nzvimbo
• icho chikamu chiratidzo chinowedzerwa

Nhanho dzekushandisa maPententi Kufambisa uchishandisa Kushandura Keys

Kuisa mapeji ekufambisa kudhipatimendi uchishandisa zvigetsi zviduku:

1. Simbisai masero ane data kuti aenzaniswe
2. Dhinda uye ubatisise Ctrl uye Shift keys pane keyboard
3. Shingairira uye musunungure pikisheni yepikisi yekomba (%) - iri pamusoro pe nhamba ye5 - pabhobhoyo pasina kusunungura maCtrl uye Shift keys
4. Bvisa Ctrl uye Shift keys
5. Iyo nhamba mumasero akasarudzwa ichakanganiswa kuti iratidze peji inoshandiswa
6. Kushandura chero ipi zvayo yakarongedzwa masero inoratidza nhamba yepakutanga isina kufananidzwa mubhadha yepemu yepamusoro pehwhepa

Isa Chimiro chePententiri uchishanda neRibbon Options

Purogiramu inogona kushandiswa kudhipatimendi inoshandisa iyo yepenti icon inowanikwa muNhamba yeNhamba paImba yebhu yebhoni, sezvinoratidzwa mumufananidzo wepamusoro, kana nekusarudza Pfumbamwe kubva muNhamba yeRudzi rweNzira yezasi.

Musiyano chete pakati pemaviri ndeyekuti ribhoni icon, sechitsinhanisi chebhodi yepamusoro, inoratidza zero nzvimbo dzepamusoro apo dhesiro rwandu rwekutsvaga rwuri kuratidza kusvika kune maviri nzvimbo dzepamusoro. Somuenzaniso, sekuratidzwa mumufananidzo uri pamusoro, nhamba 0.3256 inoratidzirwa se:

• 33% kana yakarongwa kuburikidza uchishandisa irobhoni icon
• 32.56% kana yakagadziridzwa uchishandisa doro-down list option

Numeri yakarongedzwa kune mbiri dzedzimba dzakadai sekibhokisi rekutsinhanisa pamusoro, asi comma separator haisati yashandiswa neyiyi nzira.

Shandisa Mazana Pasi Pakushandisa Mafaira MaBhokisi eDhiyabhorosi

Tichifunga nezvehuwandu hwematanho aidiwa kuti uwane peji yemafomati yakasarudzwa muFomendi Cells dialog box, pane zvishoma zvishoma apo sarudzo iyi inoda kushandiswa pane imwe yenzira dzakataurwa pamusoro apa.

Chikonzero chega chokusarudza kushandisa sarudzo iyi ndechekuchinja nhamba yezvimbo dzepamusoro dzakaratidzwa ne nhamba dzakakonzerwa nezana - mubhokisi rebhokisi nhamba yepamusoro nzvimbo dzakaratidzwa zvinogona kuiswa kubva ku zero kusvika ku30.

Iyo Format Cells dialog box inogona kuvhurwa imwe yenzira mbiri:

1. Dzvanya pabhokisi rebhokisi rebhokisi - diki rezasi rinotarisa rakatarisa muzasi kwekona yekona yeNhamba yekiyo yeboka pane ribhoni
2. Dhinda Ctrl + 1 pane keyboard