Kushandisa Excel Shortcut kuwedzera Mawhepa Akaitwa

Ndiani aiziva kuti izvi zvakaoma kuita?

Sezvakasiyana nezvimwe zvisarudzo zveExcel, pane nzira dzakawanda dzekuisa imwe kana mamwe mapepa emashandire mubhuku rebasa riripo.

Heano mirayiridzo yevatatu nzira dzakasiyana:

1. Kushandisa zvitsva zvitsva pakibhodi.
2. Kushandisa hoyo uye peji tab.
3. Kushandisa zvingasarudzwa zviri paImba yebhu yebhoni .

Isa New Worksheet Usinghandisa Keyboard Shortcut

Iko kune zvidimbu zviviri zvinokonzera maikirano ekubatanidza pepa rekushanda mu Excel:

Shift + F11
kana
Alt + Shift + F1

Somuenzaniso, kuisa pepa rekushanda neShift + F11:

1. Dhinda uye ubatisise key Shift pane keyboard.
2. Dhinda uye usunungure kiyi F11 - iri pamusoro pemutsara wenhamba pa keyboard.
3. Bvisa Shift key.
4. Bhuku idzva remabasa richaiswa mukati mebhuku rino rekushandisa kune kodzero dzezvose zviripo zvemashizha.
5. Kuti uwedzere mahwhepa akawanda emabasa anoenderera mberi kusvitsa uye kusunungura fai F11 paunenge wakabata pasi Shift key.

Isa Mahwendefa Akawanda Emashandisi achishandisa Keyboard Shortcut

Kuti uwedzere mahwhepa akawanda emabasa panguva imwe uchishandisa zvishoma zvishoma zvebhokisi, unotanga kutanga kusimbisa nhamba yeiyo mawheti ekushanda kwemashizha kuti uudze Excel kuti mangani mapepa matsva anofanira kuwedzerwa vasati vashandise nzira shoma

Cherechedza: Tsanangudzo dzemashoko dzakasarudzwa dzinofanira kuva dziri pedo kune umwe kune imwe nzira yekushanda.

Kusarudza mahwendefa mazhinji kunogona kuitwa neShift key uye mouse kana nechimwe chezvikamu zvishoma zve keyboard:

Ctrl + Shift + PgDn - inosarudza mapepa kurudyi.
Ctrl + Shift + PgUp - inosarudza mapepa kuruboshwe.

Somuenzaniso, kuisa zvitatu zvemashoko matsva:

1. Dzvanya pane rimwe bheti rebasa riri mubhuku rekushandisa kuti riise pachena.
2. Dhinda uye ubatisise Ctrl + Shift keys pane keyboard.
3. Dhinda uye usunungure pgDn kechi kaviri kuti uise mavara maviri aya kurudyi - mapepa matatu anofanira kuiswa pachena zvino.
4. Tevera mirayiridzo yepamusoro yekuisa mapepa okushanda uchishandisa Shift + F11.
5. Zvitatu zvitsva zvemashizha zvinofanira kuwedzerwa kubhuku rebhuku kune kodzero dzezvose zviripo zvemashizha.

Isa New Excel Worksheets Usinghandisa Mouse uye Sheet Tabs

Kuti uwedzere pepa rimwe chete rekushandisa uchishandisa mouse, chengetera paChiratidzo cheNew Sheet chiri pedyo nemashizha mapeji pasi peEccel screen, sezvinoratidzwa mumufananidzo uri pamusoro.

MuExcel 2013, iyo itsva pepaikoni chiratidzo ndicho chinonyanya kuratidzwa sezvinoratidzwa mumufananidzo wokutanga pamusoro. MuExcel 2010 uye muna 2007, chiratidzo chacho chifananidzo chesepaji asi chichiripo chiri pedyo nepepa tabuti pasi pekona.

Iyo pepa itsva inowedzerwa kurudyi rwekushandira shee t .

Isa Many Worksheets Work Using Sheet Tabs neMouse

Kunyange zvazvo zvichikwanisika kuwedzera mahwhepa akawanda emabasa kuburikidza nekukanda kazhinji pane peji yechitsuwa, imwe nzira ndeyekuti:

1. Dzvanya pane imwe pepa tab kuti uisarudze.
2. Dhinda uye ubatisise key Shift pane keyboard.
3. Dzvanya pane zvimwe zviri pedyo nepeji mapepa kuti uzviise pachena - kusimbisa nhamba yakafanana yemashizha emashizha semashizha matsva kuwedzerwa.
4. Chimbidza-chengetedza pane imwe yematunhu akasarudzwa kuti uzarure Insert dialog box.
5. Dzvanya paIndaneti Yepa Worksheet muwindo rebhokisi rebhokisi.
6. Dzvanya OK kuti uwedzere mapepa matsva uye uvhare bhokisi rebhokisi.

Zvinyorwa zvitsva zvese zvichawedzerwa kurudyi rwemafashiti ose aripo.

Isa New Worksheet Usinghandisa Ribbon

Imwe nzira yekuwedzera imwe pepa rekushanda ndeyokushandisa iyo Inser option iri paImba yebhu yebhoni:

1. Dzvanya paImba yebhu yebhoni.
2. Dzvanya paIngai icon kuti uzarure mhando inodonha yezvasarudzo.
3. Dzvanya kuisa Isa Sheet kuti uwedzere peji itsva kuruboshwe rwebasa rinoshanda.

Isa Many Worksheets Work Using the Ribbon

1. Tevera matanho 1 kusvika ku3 kumusoro kwekusarudza nhamba yakafanana yemashizha mapepa semashizha matsva kuwedzerwa.
2. Dzvanya paImba yebhu yebhoni.
3. Dzvanya paIngai icon kuti uzarure mhando inodonha yezvasarudzo.
4. Dzvanya paNyore Sheet kuti uwedzere mahwendefa matsva kuruboshwe rwebasa rinoshanda.