Nzira Yokugadzirisazve Pepa Rokushanda muExpcel

01 ye 02

Dzorerazve Pepa Rokushanda mu Excel

Kudzokorora uye Kudzokorora Mapepa Ebasa Rebasa

Kuchinja kwakawiri kunoita kuti zvive nyore kuronga nekuona mapepa uye data ravanenge vadzidza ndezvekuti vafananezve pepa rekushandura uye kuti vachinje ruvara rwebhupa rebasa riri rine zita riri pasi pebasa.

Kudzokorora re Excel Worksheet

Pane nzira dzakawanda dzokugadzirisazve pepa rekushanda muExcel, asi zvose zvinosanganisira kushandisa pepa mapepa pasi peEccel chinyorwa kana zvisarudzo zviri paImba yebhu yebhoni .

Sarudzo 1 - Kushandisa Keyboard Hot Keys:

Cherechedza : Zita reA Alt harifaniri kutarisirwa pasi apo mamwe makiyi akamanikidzwa, sekune mamwe maitiro ekufambisa. Chimwe nechimwe chinosungirirwa uye chinosunungurwa mukutsvaga.

Icho chinangwa chezvipfeko zvinoita zvinoita kuti ribbon iteerere. Kana imwe chete yekupedzisira iri muhutano - R - yakamanikidzwa uye yakasunungurwa, zita rezvino pane pepa pebhu rekushandiswa kana chekushanda rinojekesa .

1. Dhinda uye usunungure muchidimbu chinotevera chekubatanidza kukosha kuisa zita rekushandira pepa;

Alt + H + O + R

2. Tora zita idzva pabasa rekushanda;

3. Kushandisa Key in Enter pane keyboard kuti upedze kugadzirisa zvakare pepa rekushanda.

Kugadzirisa Mafashoni Keyboard Shortcut

Kushandurwa kwekodhiyo kechikwereti ndechekushandura pakati pebasa rekushanda - sezvo shanduro yakashanda ndiyo iyo ichanzi ichinzi ichishandise kushandisa kiyi yekubatana pamusoro apa. Shandisa zvinotevera zvinokonzera kukosha kuti uone kuti bhadharo rakakodzera rakatumidzwazve:

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

Sheet Tab Kudzokorora Ongororo

Pepa rekushandisa rinogona kutumidzwa zita rekutsvaga pane pepa pebhu pamwe nemaviri anosarudzwa.

Chokusarudza 2 - Cheka Cheka Tepa Tepa:

1. Tora kaviri pazita razvino riri mubheji rebasa rekushanda kuti uone zita razvino pane tab;
2. Tora zita idzva rekushanda;
3. Dhinda pikicha inopinda mubhobhoyo kuti upedze kugadzirisa zvakare pepa rekushanda;
4. Zita idzva rinofanira kuonekwa pane peji rebasa.

Sarudzo 3 - Kurudyi Chofa Tsamba Remahwende:

1. Kumbofa nechokuita pane tabu rebasa raunoda kutorazve kuti uzarure mamiriro ekutenderera;
2. Dzvanya kuRinazve mumutauro wemenu kuti uone zita rekushandura riripo;
3. Tevera matanho 2 kusvika 4 pamusoro.

Nzira 4 - Access muRibbon Option neMouse:

1. Dzvanya pamabhasiro ebasa raunofanira kutumidzwa kuzoita kuti rive pepa rinoshanda
2. Dzvanya paImba yebhu yebhoni
3. Dzvanya pane Fomu yakasarudza pane ribhoni kuti uzarure menyu inoderera
4. Muchikamu cheGadzira Mapepa ezvinyorwa, sarudza paReneti Sheet kuti uise peji pebhu pazasi kwekona
5. Tora zita idzva rebasa
6. Dhinda pikicha inopinda mubhokisi kuti upedze kugadzirisa zvakare pepa rekushanda

Ona MaTabheti Api eBhuku Rebasa

Kana bhuku rebasa rine nhamba yakawanda yemashandisirwo emapuranga kana bhudziro rakapeteredzwa rakapeteredzwa rave rawedzerwa, kwete mapepa ose mapepa angangowanikwa panguva imwechete-kunyanya kubva apo mazita emashizha anowedzera, saizvozvo tabo.

Kugadzirisa mamiriro ezvinhu aya,

1. Isai pointer mouse pane vertical ellipsis (zvitatu zvakananga madotsiti) pedyo nechepamusoro pepumburu bhari;
2. Purogiramu yeganda ichashandura kumuseve wemisoro miviri - sezvinoratidzwa mumufananidzo pamusoro apa kana yakanyatsoiswa;
3. Dhinda uye ubatisise ibhokisi rezasi re mouse uye dhonza pointer kurudyi kuti uwedzere nzvimbo yepepa mabhii kuti aenzaniswe - kana kuruboshwe kuti uwedzere bhari yepumburu.

Excel Worksheet Zita Zisungo

Pane mitsara mishoma pazvinosvika pakugadzirisa zvakare Excel worksheet:

• Zita harigoni kudarika vanhu 31 murefu
• Zita rebasa remashandi haigoni kusara risina chinhu
• Tsanangudzo dzinotevera hazvigoni kushandiswa nezita: \ /? : * [

Kushandisa Worksheet Mazita mu Excel Formulas

Kudzokorora rimwe pepa rekushanda hakuiti nyore nyore kuchengetedza mapepa ega ega mubhuku guru rebasa, asi rine ruzivo rwakawedzerwa rwekuita kuti zvive nyore kunzwisisa mafomu anotsanangura mahofisi akawanda.

Apo chirevo chinosanganisira kushandiswa kwemafero kubva pane rimwe pepa peji iro zita rebasa rinowanikwa mumutsetse.

Kana mazita ekushandurwa kwemashoko akashandiswa - akadai saSheet2, Sheet3 - chirevo chichatarisa chimwe chinhu chakadai:

= Sheet3! C7 + Sheet4! C10

Kupa mapepa ezita zita rinotsanangura - rakadai seMari yekuDhura uye Mari YeJune - rinogona kuita kuti rondedzero ive nyore kujekesa. Semuyenzaniso:

= 'Zvingadhura'! C7 + 'June Mari'! C10

02 of 02

Kuchinja Sheet Tab Colors

Kushandura Sheet Tab Colors Overview

Kuti ikubatsire kuwana ruzivo rwakananga mumafaira makuru eparadheet, inowanzobatsira kukodha yekodhi ma tabs emamwe mapepa ese 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.

Kushandura Tab Tab yeSepa Rokushanda Rimwe

Sarudzo 1 - Kushandisa Keyboard Hot Keys:

Cherechedza : Sezvo nekugadzirisazve pepa rekushandisa uchishandisa makii anotsvaira , iyo Alt haifaniri kutarisirwa pasi apo mamwe makiyi akamanikidzwa, sekune mamwe maitiro ekutsvaira. Chimwe nechimwe chinosungirirwa uye chinosunungurwa mukutsvaga.

1. Dhinda uye usunungure muchidimbu ichi chinotevera chekubatanidza kuti uzarure peleti yepavara iri pasi peIndaneti yakasarudza paImba yebhu yebhoni:

Alt + H + O + T

2. Nokusavapo, ruvara rwekona riri kumusoro kwekona yekona yeparlette - yakachena mumufananidzo uri pamusoro - yakasarudzwa. Dzvanya neyo mouse pointer kana shandisa mutsara museve pabhobhoyo kuti uwedzere kuiswa kumushu unoda;

3. Kana ukashandisa mitsara yemiseve, pinda muIno yeIngi pane keyboard kuti upedze kugadzirisa zvakare pepa rekushanda;

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

Chokusarudza 2 - Kurudyi Chofa Tsamba Yebheti:

1. Kumbofa nechepamusoro pebhuku rebasa raunoda kuisazve ruvara kuti ruite iyo pepa rinoshandiswa uye kuti uzarure mamiriro ekutenderera;
2. Sarudza Tab Mavara mumutsetse wemenyu kuti uzarure palette pavara;
3. Dzvanya pamuvara kuti uzvisarudzire;
4. Kuti uone mamwe mavara, tora paMamwe Colors pasi pevara rweparlette kuti uzarure chimiro chemavara palette.

Sarudzo 3 - Access Access Ribbon neMouse:

1. Dzvanya pamabhasiro ebasa kuti tishandise zita kuti riite pepa rinoshanda;
2. Dzvanya paImba yebhu yebhoni;
3. Dzvanya pane Fomu yakasarudza pane ribhoni kuti uzarure menyu pasi;
4. Muchikamu cheGadzira Mapepa ezvinyorwa, sarudza paTab Colour kuti uzarure pelette pavara;
5. Dzvanya pamuvara kuti uzvisarudzire;
6. Kuti uone mamwe mavara, tora paMamwe Colors pasi pevara rweparlette kuti uzarure chimiro chemavara palette.

Kushandura Tab Tab yeMa Multiple Worksheets

Cherechedza: Zvose zvakasarudzwa mabheji ekushanda zvichave zvakafanana.

1. Kuti usarudze tereji rimwe pebasa rebasa, bata pasi Ctrl kiyi pane keyboard uye chengeta pane imwe neimwe tab ne mouse inotsanangura.
   Kurudyi pfupa pane imwe yezvakasarudzwa zvemashizha mapeji kuti uzarure mhando yezasi.
2. Sarudza Tara Muvara mumarongero e menyu kuti uzarure palette yevara.
3. Kuti uone mamwe mavara, tora paMamwe Colors pasi pepara palette kuti uzarure Custom Color Palette.

Mhinduro

1. Kushandura mutambo webhuku rimwe pepaji yekushanda:
   • Zita rebasa rinotsanangurwa muvara rakasarudzwa.
2. Kushandura mutambo webhuku yepamusoro pepasi rimwe chete pepaji:
   • Iyo yebasa yebasa rebhurosi yebhisho yakatsanangurwa mumuvara wakasarudzwa.
   • Mamwe mabheji ekushandura mapeji anoratidza mutsara wakasarudzwa.