Nzira 3 dzeKushandura Pepa Rokushanda Tab Rambai mu Excel

Mivara yeTab ingakubatsira kuti urambe wakarongeka mukati meparashiro

Kuti ikubatsire kuwana ruzivo rwakananga mumafaira makuru eparadheet, inowanzobatsira kukodha yekodhi mapepa emashizha epa pepa rega rega ane data yakabatana. Saizvozvowo, unogona kushandisa mavara akasiyana-siyana kuti aparadzanise pakati pemashizha ane mashoko asina kukodzera.

Imwe nzira ndeyekugadzira hurongwa hwemavara emabhaibheri anopa mazano ekurumidza kuona sekutsva kwekupedzera kwemapurogiramu - akadai seruva rekuenderera mberi, uye tsvuku yekupedzwa.

Aya ndiwo maitirwo matatu ekushandura pepa pepa pepa pevara rebhuku rimwe chete mubhuku rebhuku:

• Kushandisa keyboard keys.
• Kungofa-cheka pamashizha tab (zvichida nzira inoshandiswa).
• Kushandisa mavoti tabo maitiro pane ribhoni.

Shandura Pepa Rokushanda Tab Tab Makore Kushandisa Keyboard Keys kana Mouse

Sarudzo 1 - Kushandisa Keyboard Hot Keys:

Cherechedza : Zita reA Alt muhutano hwezasi hazvifanirwi kubatirwa pasi apo mamwe makiyi akamanikidzwa, sekune mamwe maitiro ekugadzirisa. Chimwe nechimwe chinosungirirwa uye chinosunungurwa mukutsvaga.

Icho chinangwa chezvipfeko zvinoita zvinoita kuti ribbon iteerere. Kana imwechete yekupedzisira yekutsanangurira - T - yakamanikidzwa uye yakasunungurwa, peleti yemavara yekushandura chivara chebhupa chebhupa yakazarurwa.

1. Kushandura pane bheti rekushanda kuitira kuti riite pepa rinoshandiswa - kana kushandisa maitiro ekutsvaga ma keyboard kuti uwane pepa raunoda:

Ctrl + PgDn - enda kumashizha ari kurudyi Ctrl + PgUp - enda kumashizha kuruboshwe

2. Shingairira uye musunungure muchidimbu chinotevera chinobatanidzwa kuti uzarure peleti yemavara iri pasi peIndaneti yakasarudza paImba yebhu yebhoni :

Alt + H + O + T

3. Nokusingaperi, ruvara rwemavara rwemavara emutsetse wezvino hunosimbiswa (rakapoteredzwa nemuganhu wemarangi). Kana ruvara rwebhuti harina kumboshandurwa izvi zvichave zvichena. Dzvanya neyo mouse pointer kana shandisai mitsara yemuori pabhobhoyo kuti uwedzere kusimbiswa kumunhu waunoda muparlette;

4. Kana ukashandisa museve, shandisa muIteni paikirini kuti upedze marudzi ekuchinja;

5. Kuti uone mamwe mavara, shandisa mhiye weK pane keyboard kuti uzarure mutambo weparalette.

Chokusarudza 2 - Kurudyi Chofa Tsamba Yebheti:

1. Kusa-kona pane teji rebasa raunoda kuisazve marara kuti riite pepa rinoshandiswa uye kuti uzarure mharidzo yemamiriro ezvinhu;

2. Sarudza Tab Mavara mumutsetse wemenyu kuti uzarure palette pevara;

3. Kira pavara kuti uzvisarudze;

4. Kuti uone mamwe mavara, chengeta paMar Colors pane pasi pepara palette kuti uzarure chimiro chechivara chechivara.

Sarudzo 3 - Access Access Ribbon neMouse:

1. Kushandura pane bhokisi rebasa rekushandurwa kuti riitwe zita kuti riite pepa rinoshanda;

2. Kira paIndaneti tab yebhoni;

3. Dzvanya kuBuritsa sarudzo paibhoni kuti uzarure mhando yezvinyorwa pasi;

4. Muchikamu cheGadzira Mapepa ezvinyorwa, sarudza paTab Colour kuti uzarure palette pevara;

5. Kira pavara kuti uzvisarudze;

6. Kuti uone mamwe mavara, tora paMamwe Colors pasi pevara rweparlette kuti uzarure mutambo wechivara palette.

Kuchinja Tab Tab yeMa Multiple Worksheets

Kushandura pepa temavara yemavhesi emashizha akawanda kunoda kuti mapepa ese ebasa asarudze asati ashandisa imwe yenzira dzakataurwa pamusoro apa.

Mashizha akasarudzwa anogona kunge akabatana - pedyo nemumwe, zvakadai semashizha imwe, maviri, matatu - kana mahwendefa ega ega anogona kusarudzwa, akadai semashizha mana uye matanhatu.

Zvose zvakasarudzwa mabheji ekushanda mapepa zvichave zvakafanana.

Kusarudza magwaro akasiyana-siyana

1. Kushandura pane bhokisi rebasa riri pamucheto wokupedzisira weboka kuti richinjwa kuti riite pepa rinoshanda.

2. Bata pasi Shift key pane keyboard.

3. Kira pa tabu rebasa riri pamagumo eboka - mapepa ose pakati pekutanga uye ekupedzisira mapepa anofanira kusarudzwa.

4. Kana mahwendefa mazhinji akawanda akasarudzwa nokukanganisa, chovha pamagumo ekupedzisira - neShift key ichiri kumanikidzirwa - kusarura mapepa ekushanda asingadiwi.

5. Shandisa imwe yenzira dzinotsanangurwa pamusoro apa kuti uchinje ruvara rwebhu rwemashese ose akasarudzwa.

Kusarudza mapepa ega ega

1. Kira pa tabha rekutanga rebasa kuti riite pepa rinoshanda;

2. Batisisa kamba Ctrl pane keyboard uye chengetai pamabhasi eese mapepa okushandurwa kuti achinje - haafaniri kuumba boka rinotenderera - sezvinoratidzwa nemashizha mana uye matanhatu mumufananidzo uri pamusoro;

3. Kana peji yakasarudzwa nekukanganisa, chovha pairi kechipiri - neCtrl kiyi ichiri kumanikidzwa - kusarudze;

4. Shandisa imwe yenzira dzinotsanangurwa pamusoro apa kuti uchinje ruvara rwebhu rwemashese ose akasarudzwa.

Tab Ruvara Mitemo

Kana mapepa mavara mavara akachinjwa, mitemo Excel inotevera mukuratidza mavara emabvu awa:

1. Kushandura mutambo webhuku rimwe pepaji yekushanda:
   • Zita rebasa rinotsanangurwa muvara rakasarudzwa.
2. Kushandura mutambo webhuku yepamusoro pepasi rimwe chete pepaji:
   • Bhuku rinoshanda riripamusoro pebhu (s) rinotsanangurwa mumutsara wakasarudzwa.
   • Mamwe mabheji ekushandura mapeji anoratidza mutsara wakasarudzwa.