Excel Shortcut Zvikamu Zvokukurukura kune Zvimwe Zvishandiso uye Zvimwe
Dzidza zvose pamusoro pezvikamu zvekutsvaga, kusanganisira kusanganiswa kwekushandisa zvakanakisa Excel kusvika pakukwanisa kwayo.
01 ye27
Isa New Worksheet mu Excel
Iyi Excel tip inokuratidza kuti ungaisa sei pepa rekushandira mubhuku rebhuku uchishandisa nzira shoma yebhobhodhi. Isa New Excel Worksheet Kushandisa Keyboard Shortcut Press uye ubatisise SHIFT key pane keyboard. Dhinda uye kusunungura key F11 pane keyboard. Bhuku idzva remashandi richaiswa mubhuku rino rekushandira. Kuti uwedzere mamwe mapepa okushanda anoenderera mberi nekusunungura uye kusunungura key F11 paunenge wakabata pasi SHIFT key. Zvimwe »
02 pa27
Wopira Rugwaro Pamadzimai maviri muExpcel
Peta rugwaro mune imwe seni Kana iwe uchida kuti mavara aonekwe pamiganhu yakawanda mune imwe sero, unogona kuisa sero kuti mazwi acho avhare kamwe chete, kana iwe unogona kuisa mutsara webhuku. Unoda kuitei? Peta muromo wega wega Pinda mutsetse wepasitiki Pura gwaro pakarepo Mupepaiti, sarudza masero aunoda kuaita. Pamusoro peTabha tema, muBhuku Rokubatanidza, bhura Wrap Text Button image. Excel Ribbon Image Notes Zvinyorwa zviri muchitokisi wraps kuti zvikwanise hutatu hupamhi. Paunoshandura chikamu chakafara, kuvhara deta kunogadzirisa zvisiri nyore. Kana zvose zvinyorwa zvakaputirwa zvisingaoneki, zvingangodaro nokuti mutsara wacho wakatarwa kune imwe nzvimbo yakakwirira kana kuti mutsara uri mumasero emasero akabatanidzwa. Kuita kuti zvinyorwa zvose zvakaputika zvionekwe, ita zvinotevera kuti uchinje rutsanga rurefu: Sarudza sero kana mararamiro aunoda kugadzirisa mutsara wakakwirira. PaImba yebhu, mumapoka eCells, chombo Funga. Excel Ribbon Image Pasi Pamazana, ita chimwe chezvinotevera: Kuti uchinje ruzivo rwakakwirira, tsvaga AutoFit Row Height. Kuti ujekese rutivi rwakakwirira, tsvaga Row Height, uye wonyora rutsanga rurefu rwaunoda muRow urefu bhokisi. Chirongwa Unogonawo kukwevera muganhu wakaderera wemutsara kusvika kumusoro uko unoratidza zvese zvakanyorwa. Pamusoro pePeji Peji Peji Isai mutsara wekutsvaga Unogona kutanga mutsara wezvinyorwa pane imwe nzvimbo inenge iri muchitokisi. Dhinda kaviri kero iyo iwe waunoda kupinda mutsara. Kushandura kechibhobho Unogonawo kusarudza sero, uye pfuurira F2. Muchikamu, chengetera nzvimbo yaunoda kuputsa mutsara, uye wobva wanyora ALT + ENTER.
Excel's texture text feature is a handy formatting feature that allows you to control the look of labels and headings in your spreadsheet .
Musoro wekukomberedza unobvumira kuti uise mavara pamiganhu yakawanda mukati memusero mumwe chete pane kuti mharidzo inopararira pamusoro pemasero akawanda mubheji rekushanda .
Izwi rokuti "technikisi" yechikamu ichi ndechekuvhara rugwaro uye kukosha kwekunyora magwaro ndechekuti:
Alt + PindaMuenzaniso: Kushandisa Zvidhori ZveKutsvaga Kuvhara Rugwaro
Muenzaniso unoshandisa Excel yekuputira chidimbu chinyorwa:
- Muchitokisi D1 chengetedza zvakanyorwa: Monthly Receive uye pinda paIngiyi pikicha.
- Sezvo mutsetse wacho wakareba kwenguva refu kune sero, inofanira kupfuurira mukati memusero E1.
- Muchitokisi E1 chinyora mashoko acho: Mwedzi Yezvokudhura uye divhai muIngeni yeKii pane keyboard.
- Nokupinda nhamba kuE1 iyo inonzi mu cell D1 inofanira kubviswa pamugumo wesero D1. Uyewo, mutsara muE1 inofanira kupfuurira mucheperi kusvika kurudyi.
- Kugadzirisa matambudziko aya aya, shandisa masero D1 neE1 mubasa rekushanda.
- Dzvanya paIndaneti tab.
- Dzvanya paKutsvaga Bhokisi reMatsetse pabhoni .
- Iyo mavara mumasero D1 neE1 inofanirwa ikozvino zvose zviri kuonekwa zvakajeka nemashoko akavhuniwa mumiganhu miviri isina kupera mukati mumasero mashoma.
Excel's texture text feature is a handy formatting feature that allows you to control the look of labels and headings in your spreadsheet. Panzvimbo pokuwedzera mahwendefa ebasa rekuita kuti misoro yakareba ionekwe, kuvhara musoro kunokubvumira kuti uise magwaro pamiganhu yakawanda mukati memusero mumwe chete. Kufukura Mutsara Wemuenzaniso Muenzaniso Kubatsira nemuenzaniso uyu, ona mufananidzo uri pamusoro. Muchitokisi G1 nyora zvinyorwa: Monthly Inowanikwa uye shandisa ENTER key pane keyboard. Sezvo Mwedzi Miripo yakareba kwenguva refu nokuda kwekamuri rayo, ichasvikira muchitokisi H1. Muchikamu che1 H1 chinyora mharidzo: Mwedzi Yezvokudhura uye tumira ENTER mutsara pabhodhi. Pane imwe nguva dhidhi inopinda muchitokisi H1 yekutanga mazita Monthly Income inofanira kubviswa. Kugadzirisa dambudziko racho, dhonza masero G1 neH1 pane pepanheti kuti uonekwe. Dzvanya paIndaneti tab. Dzvanya paKutsvaga Bhokisi reMatsetse pabhoni. Iyo mavara mumasero G1 neH1 inofanirwa iye zvino zvose zviri kuonekwa zvakajeka nemashoko akavhuniwa mumiganhu miviri pasina kuputika kusvika mumasero ari pedyo.
Iyi dzidzo inosanganisira nzira yekunyora pamitsara yakawanda mukati memusero webasa rimwe chete.
Izwi rokuti "technikisi" yechikamu ichi ndechekuvhara rugwaro uye kukosha kwekunyora magwaro ndechekuti:
Alt + PindaMuenzaniso: Kushandisa Zvidhori ZveKutsvaga Kuvhara Rugwaro
Kushandisa Excel yekuputira purogiramu yenyaya uchishandisa chete keyboard:
- Dzvanya pane sero apo iwe unoda kuti rugwaro ruvepo
- Tora yekutanga mutsara wezvinyorwa
- Dhinda uye ubatisise Key Alt pane keyboard
- Dhinda uye usununguke muIno yeKuisa pabhobhoyo musinganunuri Alt key
- Bvisa Alt key
- Iko kunyoresa inofanira kuenderera kune mutsara uri pasi pemashoko akangopinda
- Tora wechipiri mutsara wezvinyorwa
- Kana uchida kupinda mukati memitsetse miviri yenyaya, ramba uchidhinda Alt + Enter pakuguma kwemurongo mumwe nomumwe
- Kana zvose zvinyorwa zvaiswa, pinda muIki yeIngi pane khibhodi kana chengeta ne mouse kuti uende pane imwe sero
03 of 27
Wedzera Mazuva Ano
Iyi tutori inotaura kuti iwe unokurumidza kuwedzera sei zuva razvino kumushandi webasa uchishandisa chete keyboard.
Iko kusanganiswa kwekuwedzera kwezuva ndechekuti:
Muenzaniso: Kushandisa Zvidhori ZveKutsvaga kuwedzera Mazuva Ano
Kuti uwedzere zuva razvino kumushandisi wepaji uchishandisa chete keyboard:
- Dzvanya pane sero apo iwe uchida kuti zuva riende.
- Dhinda uye ubatisise kamba Ctrl pane keyboard.
- Shingairira uye musunungure kiyi-colon key ( ; ) pane keyboard asi musununguri Ctrl.
- Bvisa Ctrl.
- Zuva rezuva rino rinofanira kuwedzerwa kushizha rinoshandiswa mumusero wakasarudzwa.
Cherechedza: Kushandura kemikisi iyi hakuiti kushandiswa kweTODAY basa saka zuva racho harina kuchinja nguva dzose kana pepa rekushandura richizarurirwa kana kurongedzwa zvakare. Zvimwe »
04 of 27
Sum Data mu Excel Kushandisa Shortcut Keys
Sum Data mu Excel Kushandisa Shortcut Keys
Izvi zvinotaura kuti ungakurumidza kupinda sei Excel's SUM basa kuti uwedzere dhidhi uchishandisa zvitsva zvishoma pa keyboard.
Iko mubatanidzwa wekutanga wekupinza basa reSUM nderekuti:
" Alt " + " = "
Muenzaniso: Kupinda Basa reSUM uchishandisa Shortcut Keys
- Isa data inotevera inhengo D1 kusvika kuD3 yeExcel pepa rekushanda : 5, 6, 7
- Kana zvichidikanwa, chengeta pane cell D4 kuti iite iyo inoshanda masero
- Dhinda uye ubatisise Key Alt pane keyboard
- Dhinda uye usunungure chiratidzo chakaenzana ( = ) pane keyboard asi usunungurire Alt key
- Bvisa Alt key
- Basa reSUM rinofanira kunge rakapinda muchitokisi D4 neyeri D1: D3 yakasimbiswa sechinhu chebasa
- Dhinda pikicha inopinda mubhokisi kuti upedze basa
- Mhinduro 18 inofanira kuonekwa muchitokisi D4
- Paunenge uchinyora pane cell D4 yakakwana basa = SUM (D1: D3) inowanikwa mubhadha yepamusoro pane pepa pepaji.
Iyi nzira shomanana inogona kushandiswa kugadzirisa dhese mumigwagwa pamwe nemakoroni.
Cherechedza : I-SUM yakagadzirirwa kuiswa pasi pekorodhe ye data kana kumucheto wekodzero yemutsara we data.
Kana basa reSUM rapinda pane imwe nzvimbo kunze kweiyi, huwandu hwemasero akasarudzwa sehutano hwebasa hungave husina kunaka.
Kuti uchinje mararamiro akasarudzwa, shandisa mouse pointer kuti uise pachena mabheji akakodzera usati wanyora muItena kuti upedze basa More »
05 of 27
Kuwedzera Nguva Yemazuva Ano
Izvi zvidzidzo zvinowedzera kukurumidza kuwedzera nguva yemazuva ano kune pepa rekushandisa uchishandisa chete keyboard:
Iko kuunganidza kukuru kwekuwedzera nguva ndeyokuti:
Muenzaniso: Kushandisa Zvimedu Zvitsva Zvokuwedzera Maawa Ano
Kuwedzera nguva yemazuva ano kune pepa rekushandisa uchishandisa chete keyboard:
- Dzvanya pane sero apo iwe unoda nguva yekuenda.
- Dhinda uye ubatisise Ctrl uye Shift keys pane keyboard.
- Dhinda uye ubudise kiyi yekoloni (:) pane keyboard asi isunungure Ctrl uye Shift keys.
- Nguva yemazuva ano ichawedzerwa kune spreadsheet.
Cherechedza: Kushandura kemikisi iyi hakuiti kushandiswa kweNOW basa kuitira kuti zuva racho risashandurwe nguva dzose kana pepa rekushanda richizarurirwa kana kugadziriswa.
Mamwe Shortcut Keys Tutorials
Zvimwe »06 of 27
Isa Hyperlink
Isa Hyperlink muExcel Kushandisa Shortcut Keys
Related tutorial : Isa Hyperlinks uye Ma Bookmarks mu Excel
Iyi Excel tip inobatanidza nzira yekukurumidza kuisa hyperlink pamashoko akasarudzwa achishandisa zvidzitiro zviduku mu Excel.
Iko kusanganisa kukuru uko kunogona kushandiswa kuisa hyperlink ndeyokuti:
Ctrl + k
Muenzaniso: Isai Hyperlink uchishandisa Shortcut Keys
Kuti ubatsirwe nemirayiridzo iyi chengetedza pamufananidzo uri pamusoro
- Mune pepa re Excel worksheet chengeta pane cell A1 kuti iite iyo inoshanda masero
- Tora shoko kuti uite seanchor text seSpreadsheets uye diya Enter Enter pane keyboard
- Dzvanya pane sero A1 kuti uite zvakare kuti iri sero rinoshanda
- Dhinda uye ubatisise kamba Ctrl pane keyboard
- Dhinda uye usunungure tsamba ( k ) kiyiyo pabhobhoyo kuti uzarure Insert Hyperlink dialog box
- MuIndaneti: mutsara pazasi kwebhokisi rebhokisi yebhokisi ye URL yakakwana sey:
http://spreadsheets.about.com - Dhura Ok kuti upedze hyperlink uye uvhare bhokisi rebhokisi
- Nheyo yekunyorera muchitokisi A1 inofanira kunge yava yebhuruu muvara uye yakatsanangurwa ichiratidza kuti ine hyperlink
Kuedza Hyperlink
- Isai peinter mouse pane hyperlink in cell A1
- Mushonga unobva mumuseve unofanirwa kuchinja kusvika muruoko rwechiratidzo
- Dzvanya pamagwaro ekutsanangurira anchor
- Tsvaga yewebhu yako inofanira kuzarurirwa peji yakawanikwa ne URL
Bvisa Hyperlink
- Isai peinter mouse pane hyperlink in cell A1
- Mushonga unobva mumuseve unofanirwa kuchinja kusvika muruoko rwechiratidzo
- Enda pakananga pinyorwa ye hyperlink anchor kuti uzarure Kontext drop down menu
- Dzvanya Kubvisa Hyperlink sarudzo mumenyu
- Rudzi ruvara rwebhuruu uye tsananguro inofanira kubudiswa kubva pamashoko anchokwe anoratidza kuti hyperlink yakabviswa
Other Keyboard Shortcuts
07 pa27
Ratidza Mafomu
08 pa27
Excel Shortcut Keys - Dzokorora
Iyi Excel shortcut key tutorial inokuratidza iwe "kubvisa" shanduko yakaitwa kune Excel worksheet.
Related tutorial: Feature Excel's Slide Feature .
Cherechedza: Zvakakosha kuyeuka kuti kana ukashandura Kuronga, "kunodzosera" zviito zvako mumutemo wakatarisa wawakashandisa.
Nzira yekutsinhanisa inoshandiswa kushandiswa kushandura "kushandura" kuchinja ndeyekuti:
- Ctrl + " Z "
Muenzaniso wekugadzirisa kushandura uchishandisa Shortcut Keys
- Tora imwe data muchikamu , chakadai seA1 mune pepadheetti uye diya kuIta yekiyo pabhobho.
- Dzvanya pane iyo sero kuitira kuti iite sero rinoshanda .
- Dzvanya paImba yebhu yebhoni .
- Shandisai zvinotevera maitiro ekufambisa kune data yako:
- shandura mutsara wepavara,
- wedzera iyo column,
- teerera,
- shandura rudzi rwemhando yeAaral Black,
- Pakati pekuenzanisa data
- Dhinda uye ubatisise kamba Ctrl pane keyboard.
- Dhinda uye usunungure tsamba " Z " pane keyboard.
- Dheta iri muchitokisi inofanira kushanduka kudzokera kuruboshwe rworuboshwe sezvo shanduko yekupedzisira (kugadziriswa kwepakati) isisina kushandiswa.
- Dhinda uye ubatisise kiyi Ctrl pane keyboard zvakare.
- Dhinda uye usunungure tsamba " Z " pabhodhi kaviri pasina kusunungura ctrl .
- Hakusi chete katsinanguro kanobviswa asi faira haichazovi Arial Black.
- Izvi zvinoitika nokuti, sezvakataurwa pamusoro apa, kushandurwa kwechiitiko "kushandura" zviito zvako mune zvakatemwa zvakarongeka zvawakashandisa.
Zvimwe Excel Shortcut Keys Tutorials
- Kuwedzera Nguva Yemazuva Ano
- Sarudza Mamwe Masero Asingaoneki muExcel
- ALT - TAB Kushandura kuWindows
09 of 27
Kusarudza Mamwe Masero Asingaoneki
Sarudza Mamwe Masero Asingaoneki muExcel
Zvimwe Zvidzidzo: Sarudza Mamwe Masero Asina Kujeka Uchishandisa Keyboard neMouse
Nokusarudza masero akawanda muExcel unogona kubvisa data, shandisa maitiro akaita semiganhu kana shading, kana kushandisa zvimwe zvingashandiswa kumativi makuru epepaiti rese panguva imwechete.
Pane dzimwe nguva masero aya haasi munzvimbo inogadzirisa. Mune mamiriro ezvinhu izvi zvinokwanisika kusarudza zvisingasviki masero.
Izvi zvinogona kuitwa uchishandisa keyboard uye mouse pamwechete kana kungoshandisa keyboard.
Kushandisa Keyboard in Extended Mode
Kusarudza zvisiri pamasero masero ane keyboard chete inoda iwe kushandisa khibhodi mu Extended Mode .
Yakawedzerwa mode inoshandiswa nekufambisa F8 key pane keyboard. Iwe unovhara maitiro akawedzerwa nokudhinda Shift neF8 makii pabhokisi pamwe chete.
Sarudza Mamwe Mamwe Masero Asingaoneki muExcel Kushandisa Keyboard
- Shandisa se cell cursor kune imwe sero yaunoda kusarudza.
- Dhinda uye usunungurire F8 key pabhobhoyo kuti utange Extended Mode uye kuisa seni yekutanga.
- Pasina kutenderera se cell cursor, shandisa uye osunungura Shift + F8 makii pabhokisi pamwe chete kuti muvhare mhepo yakawedzerwa.
- Shandisai mitsara yemiseve pakibhodi kuti uite se cell cursor kune rimwe rinotevera raunoda kuisa pachena.
- Sero yekutanga inofanira kuramba yakasimbiswa.
- Nees cell cursor pane imwe sero inotevera kuti iiswe pachena, dzokorora matanho 2 ne3 pamusoro.
- Ramba uchiwedzera masero kumabhedhi akaiswa pachena uchishandisa F8 uye Shift + F8 zvigadzirira kutanga uye kumira yakawedzerwa mode.
Kusarudza Majeri Ekare uye Asingaiti Mairi muExpcel Kushandisa Keyboard
Tevera matanho ari pasi apa kana mararamiro aunoda kusarudza ane musanganiswa wemasero anenge ari oga uye ari oga sekuratidzwa mumufananidzo uri pamusoro.
- Shandisa se cell cursor kune imwe sero muboka remasero waunoda kuisa.
- Dhinda uye kusunungura f8 key pane keyboard kuti utange Extended Mode .
- Shandisai miseve yemiseve pabhobhoyo kuti uwedzere ruzivo rwakasimbiswa kuti uise masero ose muboka.
- Nevose masero muboka rakasarudzwa, tsvaga uye usunungurire Shift + F8 makiyi pabhokisi pamwe chete kuti muvhare maitiro akawedzerwa.
- Shandisai miseve yemiseve pabhobhoyo kuti uite se cell cursor kure neboka rakasarudzwa remasero.
- Boka rokutanga remasero rinofanira kuramba rakasimbiswa.
- Kana pane mamwe masero akabatana aunoda kuisa pachena, enda kune imwe sero iri muboka uye dzokorora matanho 2 kusvika 4 pamusoro.
- Kana paine masero ega ayo waunoda kuwedzera kune yakarongedzwa, shandisa sekutanga yekuraira pamusoro apa kujekesa masero masere.
10 pa27
Sarudza Mamwe Masero Asingaoneki muExcel neKiboardboard neMouse
Zvimwe Zvidzidzo: Kusarudza Mamwe Masero Asingaoneki Achishandisa Keyboard
Nokusarudza masero akawanda muExcel unogona kubvisa data, shandisa maitiro akaita semiganhu kana shading, kana kushandisa zvimwe zvingashandiswa kumativi makuru epepaiti rese panguva imwechete.
Paunenge uchishandisa dhora sarudza nzira nemushoni kuti uone nekukurumidza bhokisi remaseri ari pedyo nepamwe nzira inowanzosarudzwa yekusarudza kupfuura imwe kero, pane dzimwe nguva apo masero iwe waunoda kusimbisa haawani pedyo nemumwe.
Kana izvi zvichiitika, zvinokwanisika kusarudza zvisingasviki masero. Kunyange kusarudza zvisiri izvo zvakasvibirira masero zvinogona kuitwa chete nebhobhoyo , zviri nyore kuti uite kushandisa keyboard ne mouse pamwechete.
Kusarudza Mamwe Masero Asingaoneki muExcel
Kuti ubatsirwe nemuenzaniso uyu, ona mufananidzo uri pamusoro.
- Dzvanya pane sero yekutanga yaunoda kusarudza neyo mouse pointer kuti iite iyo inoshanda sero .
- Bvisa mutsara.
- Dhinda uye ubatisise kamba Ctrl pane keyboard.
- Dzvanya pamamwe masero waunoda kusarudza Asina kusunungura Ctrl .
- Kana kamwe masero ose aidiwa achisarudzwa, kusunungura Ctrl .
- Usambofa pane imwe nzvimbo neyo mouse pointer kana ukasunungura ctrl kana iwe uchabvisa kujekesa kubva kumasarudzo akasarudzwa.
- Kana ukasunungura ctrl pfupi nokukurumidza uye uchida kuisa mamwe masero, tsvaga uye ubatisise Ctrl kechi zvakare uye tora pane mamwe masero (s).
Mamwe Shortcut Keys Tutorials
11 pa27
ALT - TAB Kuchinja muWindows
Haisi kungove nzira yekutsvaga kweAexcel, ALT - TAB Kuchinja inzira inokurumidza kufamba pakati pevhesi dzose dzakasununguka muWindows (Win key + Tab muWindows vista).
Kushandisa keyboard kuti uite basa pane kombiyuta kunowanzoshanda zvakanyanya kudarika kushandisa mushonga kana zvimwe zvinogadzirisa, uye ALT-TAB Kugadzirisa ndechimwe chezvinhu zvakashandiswa zvikuru zvidzitiro zve keyboard.
Kushandisa ALT - TAB Kuchinja
- Vhura mahwendefa maviri kana maviri muWindows. Izvi zvinogona kuva maEfcel maviri kana eExpcel File uye file Microsoft Word somuenzaniso.
- Dhinda uye ubatisise Key Alt pane keyboard.
- Dhinda nekusunungura tab yeTabhi pabhokisi pasina kurega kuenda kune Alt key.
- The ALT - TAB Fast Switching window inofanira kuoneka mukati mekombiyuta yako.
- Iwindo iyi inofanira kunge ine chinyorwa chegwaro rimwe nerimwe ikozvino rakazarurwa pakombiyuta yako.
- Pikicha yekutanga pane kuruboshwe ichava yebhuku rino - iro rinoratidzwa pachikona.
- Chiratidzo chechipiri kubva kuruboshwe chinofanira kusimbiswa nebhokisi.
- Pasi pemifananidzo inofanira kuva zita rebhuku rakasimbiswa nebhokisi.
- Dzosera Alt key uye mafasititi akashandura iwe kumagwaro akaiswa pachena.
- Kuti uende kune mamwe magwaro akaratidzwa muAlt - TAB Fast Switching window, ramba uchibata pasi Alt paunenge uchishandisa kate Tab . Mbambo imwe neimwe inofanira kutamisa bhokisi rakasimbiswa kuruboshwe kurudyi kubva pane rimwe bhuku kusvika kune rinotevera.
- Bvisai Alt key apo rugwaro ruchida runotsanangurwa.
- Kamwe iyo ALT - TAB Fast Switching window yakazaruka, unogona kuchinja mararamiro ebhokisi rinokurudzira - kuifambisa kubva kurudyi kuenda kuruboshwe - nekuchengeta pasi Shift key pamwe neAiyo key uye ipapo kugunzva Tab .
Other Keyboard Shortcuts
12 pa27
Excel's Go To Feature
Related tutorial: Excel Zita Bhokisi Rokushandisa .
Iyo Inofanirwa kuiswa muExcel inogona kushandiswa kukurumidzira kuenda kumasero akasiyana mune pepasitetet . Ichi chinyorwa chinosanganisira muenzaniso wekuti ungashandisa sei Go kuenda kuti uende kune masero akasiyana-siyana uchishandisa nzira shoma yebhobhodhi.
Kunyange zvazvo zvisina kudiwa pamashandiro ebasa anoshandisa mashomanana mashoma nemitsetse , nokuda kwemashizha makuru emashandi anogona kuva anobatsira kuva nenzira dzakajeka dzekukwira kubva kune imwe nzvimbo yebasa rako rechikoro kune rimwe.
Kuti uite iyo Go kuisa kushandisa kirabhodi, shandisa f5 key
Muenzaniso unoshandisa Excel's Go kuenda kuUkufamba:
- Dhinda F5 key pabhobhoyo kuti uburise Go Go dialog box.
- Tora mu cell reference yeaida kuenda kunotarisa mutsara webhokisi rebhokisi. Munyaya iyi: HQ567 .
- Dzvanya kuK OK bhatani kana kuti shandisa ENTER key pane keyboard.
- Bhokisi dema rakapoteredza sero rinoshanda rinofanira kusvetera kune imwe sero HQ567 ichiita kuti ive itsva inoshanda masero.
- Kuti uende kune imwe sero, dzokorora matanho 1 kusvika ku3.
Related Tutorials
- Excel Name Box Navigation
- Cell References in Formulas
- Kuwedzera Hyperlinks uye Ma Bookmarks mu Excel
13 pa27
Excel Chizadza Pasi Command
Kana iwe uchida kuisa data imwe chete - mavara kana nhamba - mune imwe nhatu dzemakamuri mashoma ari munhare , Fill Down command inogona kukurumidza kuita izvi iwe uchishandisa keyboard.
Iyi Excel tip inokuratidza kuti ungashandisa sei Kuzadza pasi murairo mune imwe Excel spreadsheet uchishandisa nzira shoma yebhobhodhi.
Iko kusanganisa kukuru uko kunoshandisa Idzadza pasi murairo ndeyokuti:
- Ctrl + D
Muenzaniso: Kushandisa Kuzadza neCkeyboard Shortcut
Kuti ubatsirwe nemuenzaniso uyu, ona mufananidzo uri pamusoro.
- Tora imwe nhamba, yakadai se395.54 mu cell D1 mu Excel.
- Dhinda uye ubatisise key Shift pane keyboard
- Dhinda uye ubatisise Key Down Arrow pabhobhoyo kuti uwedzere kujekesa kwesero kubva pane imwe D1 kusvika D7.
- Bvisa zvose zvigetsi.
- Dhinda uye ubatisise kamba Ctrl pane keyboard.
- Dhinda uye kusunungura " D " kiyi pane keyboard.
- Mitsara D2 kusvika D7 inofanira kunge ichizadzwa nemamwe mashoko akafanana seyero D1.
Other Keyboard Shortcuts
14 pa27
Kushandisa Ichairiki Kugadzirisa
Iyi Excel tip inokuratidza kuti ungashandise sei zvinyorwa zvekugadzirisa uchishandisa zvidzitiro zviduku pane keyboard.
Pane humwe huviri hukuru hunobatanidza hunogona kushandiswa kuwedzera kana kubvisa tetariki mafomu ku data:
- Ctrl + " I " makii
- Ctrl + " 3 " makiyi
Muenzaniso: Kushandisa Zvimedu Zvitsva Zvokushandisa Kushandura Itaitiki Kugadzira
Kuti ubatsirwe nemuenzaniso uyu, ona mufananidzo kurudyi.
- Tora imwe data muchikamu , chakadai seE1 muparadheet uye diya kuIta yekiyi pane keyboard.
- Dzvanya pane iyo sero kuitira kuti iite sero rinoshanda .
- Dhinda uye ubatisise kamba Ctrl pane keyboard.
- Dhinda uye usunungure tsamba " Ini " pane keyboard.
- Ichasoka mafomati inofanira kushandiswa kune data iri muchitokisi.
- Dhinda nekusunungura ma Ctrl + " I " maikiti zvakare kuti ubvise mavara emitambo.
Other Keyboard Shortcuts
15 pa27
Isa Kushandura Nhamba
Izvi zvidzidzo zvinoshandisa nzira yekushandisa nhamba kuisa masero masarudzo achishandisa chete keyboard:
Nhamba dzenhamba dzinoshandiswa kune data yakasarudzwa ndeyi:
- maviri decimal nzvimbo
- the comma as thousands separator (,)
- iyo chiratidzo chisina (-) chezvinhu zvisingaiti
Iko kusanganisa kukuru uko kunogona kushandiswa kushandiswa kwemari kushandiswa kune deta ndeyokuti:
Ctrl + Shift + ! (kudanidzirwa pfungwa)
Muenzaniso: Kushandisa Zvimedu Zvitsva Zvokushandisa Kuita Kufomesa Nhamba
Uyu muenzaniso unoratidzwa mumufananidzo uri pamusoro
- Wedzera iyi inotevera data kumasero A1 kusvika kuA4:
4578.25102 45782.5102 457825.102 4578251.02 - Simbisai masero A1 kusvika kuA4 kuti musarudze
- Dhinda uye ubatisise Ctrl uye Shift keys pane keyboard
- Dhinda uye usunungure chinhu chekutsvaga ( ! ) Pane keyboard kunze kwekusunungura Ctrl uye Shift keys
- Bvisa Ctrl uye Shift keys
- Nhamba dziri mumasero A1 kusvika kuA4 dzinofanira kunge dzakasanganiswa kuti dziratidze mbiri mbiri dzepamusoro kunyange zvazvo huwandu huwandu hwave huwandu huviri
- Masero aya anofanirawo kuva nekima yakawedzerwa sezviparadzanisa zvezviuru
- Kushandura chero ipi zvayo yemasero inoratidza nhamba yepakutanga isina kufananidzwa mubha yemurairi pane pepa pepaji
Other Keyboard Shortcuts
16 pa27
Shandisa Mari Kuchinja
Iyi tutori inotaura kuti ingakurumidza sei kushandisa mari yekufambisa kumasero akasarudzwa achishandisa keyboard chete:
Iko kusanganisa kukuru uko kunogona kushandiswa kushandiswa kwemari kushandiswa kune deta ndeyokuti:
- Ctrl + Shift + 4
Muenzaniso: Kushandisa Zvimedu Zvitsva Zvokushandisa Kuisa Mari Kuumba
Kuti ubatsirwe nemuenzaniso uyu, ona mufananidzo kurudyi.
- Wedzera iyo inotevera data kumasero A1 kusvika B2: 7.98, 5.67, 2.45, -3.92
- Dragodza masero A1 kusvika kuB2 kuti uonekwe.
- Dhinda uye ubatisise Ctrl uye Shift keys pane keyboard.
- Dhinda uye ubudise nhamba yechina kiyi ( 4 ) pane keyboard asi usunungurire Ctrl uye Shift keys.
- Mumakamuri A1, A2, uye B1 dhora rechirwere ( $ ) rinofanira kuwedzerwa kune data.
- Muchitokisi B2, nokuti data iri nhamba isina kunaka, inofanira kuva yakatsvuka uye yakapoteredzwa mabheji akaenzana kuwedzera kuva nechiratidzo chemadhora ( $ ) yakawedzerwa.
Other Keyboard Shortcuts
17 pa27
Isa Chimiro chePententi
Iyi Excel nhepfenyuro inosanganisira kushandisa Percent formatting kune masero akasarudzwa muSpreadsheet ye Excel uchishandisa zvitsva zvishoma zvebhokisi.
Iko kusanganisa kukuru uko kunogona kushandiswa kushandiswa kwemari kushandiswa kune deta ndeyokuti:
- Ctrl + Shift + 5
Muenzaniso wekushandisa maPententi kudhinda uchishandisa Shortcut Keys
Kuti ubatsirwe nemuenzaniso uyu, ona mufananidzo uri pamusoro.
- Wedzera iyo inotevera data kumasero A1 kusvika B2: .98, -34, 1.23, .03
- Dragodza masero A1 kusvika kuB2 kuti uonekwe.
- Dhinda uye ubatisise Ctrl uye Shift keys pane keyboard.
- Dhinda uye ubudise nhamba yechishanu nheyo ( 5 ) pane keyboard asi isunungure Ctrl uye Shift keys.
- Mumakamuri A1 kusvika kuB2 data inofanira kuchinjwa kuzana neine chikamu chepakati ( % ) yakawedzerwa kune data.
Mamwe Shortcut Keys Tutorials
- Shandisa Mari Kuchinja
- Kushandisa Ichairiki Kugadzirisa
- Wedzera Makomo muExcel
18 pa27
Sarudza Meseji ese muExcel Data Table
Iyi Excel tip inobatanidza nzira yekusarudza masero ose etafura yeDeccel data uchishandisa nzira yekuchera keyboard. Kuita izvi kunokubvumira kushandisa shanduko dzakadai sekugadzirisa mafaira, huwandu hwendarira, nezvimwewo kune rimwe pepa pepaji kamwechete.
Nyaya inobatanidza: Kuumba Data Deta muExpcel .
Cherechedza: Kubatsirwa nemuenzaniso uyu, ona mufananidzo kurudyi.
Muenzaniso weNzira Yokusarudza Sei Mamwe Maseji muData Re Data
- Vhura pepa reku Excel riri rine tafura ye data kana kuti ita tafura ye data .
- Dzvanya pane chero sero mutafura yedhadha.
- Dhinda uye ubatisise kamba Ctrl pane keyboard.
- Dhinda uye ubudise tsamba " A " kiyi pane keyboard kunze kwekusunungura Ctrl .
- Zvose masero ari mufurafura yemadhora anofanira kusimbiswa.
- Dhinda uye usunungure tsamba " A " kechipiri.
- Mutsara wehurukuro wefurafura yedhadharo inofanira kuiswa pachena pamwe chete nefurafura yedata.
- Dhinda uye usunungure tsamba " A " kechipiri.
- Zvose masero ari mubasa rinofanira kuiswa pachena.
Other Keyboard Shortcuts
19 pa27
Sarudza Rute Row yose mu Excel Uchishandisa Shortcut Keys
Sarudza Ropa muPepa Rokushanda
Iyi Excel tip inobatanidza nzira yekukurumidza kusarudza kana kusimbisa mutsara wose mune pepa rekushandisa uchishandisa zvidzitiro zvekibhokisi paExcel.
Iko kusanganiswa kukuru kunoshandiswa kusarudza rutsanga ndechekuti:
SHIFT + SPACEBAR
Muenzaniso: Kushandisa Nheyo dzeKutsvaga Kusarudza Bhuku Rese Rokushanda Row
- Vhura Excel Worksheet - haifaniri kuva chero data iripo
- Dzvanyira pane imwe kero riri mubasa rekushanda - rakadai seA9 - kuti riite sero rinoshanda
- Dhinda uye ubatisise key SHIFT pane keyboard
- Dhinda uye ubudise key SPACEBAR pabhodhi asi usasunungura key SHIFT
- Bvisa SHIFT key
- Zvose masero mumutsara wakasarudzwa anofanira kuiswa pachena - kusanganisira iroji musoro
20 pa27
Chengetedza ku Excel
Excel Save Shortcut Keys
Iyi Excel tip inobatanidza nzira yekukurumidza kuchengetedza dhina uchishandisa zvigadzirisho zvitsva pabhokisi mu Excel.
Iko kusanganisa kukuru uko kunogona kushandiswa kuchengetedza dambudziko nderekuti:
Ctrl + S
Muenzaniso: Kushandisa Zvimedu Zvitsva Zvokuchengetedza Pepa Rokushanda
- Dhinda uye ubatisise kamba Ctrl pane keyboard
- Dhinda nekusunungura tsamba ( S ) kiyi pane keyboard kunze kwekusunungura Ctrl
- Bvisa Ctrl
First Time Save
Kana iwe wakambochengetedza pepa rekushanda chete chiratidzo chokuti Excel iri kuchengetedza faira yako ingave iyo mutsara weguru inoshandura muchidimbu muhodhi ye hourglass uye zvakare kudzokera kune yakazara machena pamwe nechiratidzo.
Iyo nguva yenguva ye hourglass inoramba ichioneka inoenderana nenhamba ye data Excel inofanira kuchengetedza. Iyo yakawanda iyo yakawanda ye data kuti ichengetedze, nguva refu hourglass icon ichaonekwa.
Kana uri kuchengetedza pepa rekushandisa kwekutanga kokunge Bhokisi reKachengetedza rebhokisi rinozarura.
Apo faira inoponeswa kwekutanga kokutanga zvikamu zviviri zvemashoko zvinofanira kusanangurwa mu Save As dialog box:
- zita refaira (kusvika kumakumi maviri nema25 anosanganisira nzvimbo)
- nzvimbo (folda) iyo faira ichachengetwa
Save Frequently
Kubvira kushandiswa kweCtrl + S zvitsva zvitsvaga inzira yakadaro yekuchengetedza dambudziko iri pfungwa yakanaka kuchengetedza kakawanda - zvishoma nemaminitsi mashanu - kuti urege kurasikirwa nedhidhiyo kana chiitiko chekombiyuta ichipera. Zvimwe »
21 pa27
Viga uye Unganise Makoromo neMirairo muExcel
22 pa27
Kugadzirisa zuva
Iyi Excel tip inokuratidza kuti unyoresa sei zuva (zuva, mwedzi, gore romufaira) mune imwe Excel spreadsheet uchishandisa nzira shoma yebhokisi.
Kufambisa Musi uchishandisa Keyboard Shortcut
- Wedzera zuva raidiwa kusero mune imwe Excel spreadsheet.
- Dzvanya pane sero kuti uite sero rinoshanda .
- Dhinda uye ubatisise Ctrl uye Shift keys pane keyboard.
- Dhinda uye ubudise nheyo yechiratidzo ( # ) pabhobhoyo pasina kusunungura Ctrl uye Shift keys.
- Zuva riri kushanda rinoshandiswa ruchaiswa muzuva, mwedzi, gore romufaira.
Other Keyboard Shortcuts
23 pa27
Kugadzirisa Mazuva Ano
Iyi Excel tip inokuratidza kuti unyore sei nguva yemazuva ino (awa, miniti, uye AM / PM mafomati) muExpcel spreadsheet uchishandisa nzira shoma yebhobhodhi.
Kufambisa Ikozvino Nguva kushandisa Keyboard Shortcut
- Shandisa NOW basa kuti uwedzere zuva razvino uye nguva yero cell D1.
- Dzvanya pane sero D1 kuti uite sero rinoshanda .
- Dhinda uye ubatisise Ctrl uye Shift keys pane keyboard.
- Dhinda uye ubudise nhamba mbiri ( 2 ) pabhobhoyo pasina kusunungura Ctrl uye Shift keys.
- Ikozvino basa muchitokisi D1 ichagadziridzwa kuratidzira nguva yemazuva ino muawa, miniti, uye AM / PM format.
Other Keyboard Shortcuts
24 pa27
Shandura Pakati Pebasa Rokushanda
Sezvimwe zvinoshandiswa pakushandisa mutsara, zviri nyore kushandura nzira shoma yebhobhoyo kuti uchinje pakati pemashandi eku Excel.
Nheyo dzinoshandiswa ndeye CTRL key pamwe chete nePGUP (peji kumusoro) kana PGDN (peji pasi) key
Muenzaniso - Shandura Pakati Pebasa Rokushanda mu Excel
Kuenda kurudyi:
- Dhinda uye ubatisise CTRL key pane keyboard.
- Dhinda uye usunungure pGDN (peji pasi) kiyi pane keyboard.
- Kuendesa imwe peji kudivi rekodzero uye kusunungura pGDN kechi kechipiri.
Kutamira kuruboshwe:
- Dhinda uye ubatisise CTRL key pane keyboard.
- Dhinda uye ubudise pGUP (peji peji) kiyi pane keyboard.
- Kutamisa imwe peji kuruboshwe rworuboshwe uye kusunungura pGUP kechipiri kechipiri.
Other Keyboard Shortcuts
25 pa27
Rongedza Masekeri neF2 Function Key
Excel Chengetani Masekesi Shortcut Key
Basa rekushandisa F2 rinokubvumira kukurumidza uye nyore nyore kuchinja data yesero kuburikidza nekugadzira Excel's edit mode uye kuisa iyo kuisa pfungwa pane iyo pamagumo emagetsi anoshandiswa zviripo zviripo.
Muenzaniso: Kushandisa F2 Key Kuita Semu Zviri Mukati
Muenzaniso uyu unobatanidza maitiro ekugadzira fomu muExcel
- Isa data inotevera iri mumasero 1 kusvika D3: 4, 5, 6
- Dzvanya pane cell E1 kuti iite iyo inoshandiswa seki
- Isa inotevera inomusiyumu muyero E1:
= D1 + D2 - Dhinda pikicha inopinda mubhokisi kuti upedze fomu - mhinduro 9 inofanira kuonekwa muchitokisi E1
- Dzvanya pane cell E1 kuti uite zvakare iyo inoshanda masero
- Dhinda chipfeko cheF2 pane keyboard
- Excel inopinda kuronga mamiriro uye kuiswa kwekuisa kunoiswa pamagumo emvura yezvino
- Shandura chimiro nekuwedzera + D3 kusvika pakuguma kwayo
- Dhinda pikicha inopinda mubhobhoyo kuti upedze fomu uye urege kuchinja mamiriro - huwandu hutsva hwomutambo - 15 - hunofanira kuonekwa muchitokisi E1
Cherechedza: Kana sarudzo yekubvumira zvakananga mumasero akadzimwa, kushidzira f2 yeF2 icharamba ichiisa Excel mu edit mode, asi kuisa pfungwa ichaendeswa kune bhora yepamusoro pane pepa rekushandisa kuitira kugadzirisa zviri mukati. Zvimwe »
26 pa27
Sarudza Mamwe maSera ari mu Excel Worksheet
27 pa27
Wedzera Makomo
Iyi Excel tip inobatanidza nzira yekuwedzera muganhu kumasanangurwa akasarudzwa muExpcel spreadsheet uchishandisa nzira shoma yebhokisi.
Related tutorial: Kuwedzera / Kugadzirisa Mabhiriji mu Excel .
Iko kuunganidza kukuru kwekuwedzera nguva ndeyokuti:
Muenzaniso weNzira yekuwedzera micheche uchishandisa Keyboard Shortcut
Kuti ubatsirwe nemuenzaniso uyu, ona mufananidzo kurudyi.
- Pinda nhamba 1 kusvika ku 9 mumasero D2 kusvika kuF4.
- Dragodza sarudza masero D2 kusvika kuF4 kuti uonekwe.
- Dhinda uye ubatisise Ctrl uye Shift keys pane keyboard.
- Dhinda uye usunungure nhamba yechinomwe kiyi ( 7 ) pabhobhoyo pasina kusunungura Ctrl uye Shift keys.
- Mitsara D2 kusvika kuF4 inofanira kuve yakakomberedzwa nemuganhu wakanga.
Other Keyboard Shortcuts