Kupinda muExcel kunoreva kutamira kumusoro-uye-pasi kana kune rumwe rutivi kuburikidza nehwhepa rekushandisa uchishandisa mipumburu yemupumburu, zvigetsi zvemiseve pabhobho, kana mupumburu gumbo pamushonga.
Nekusavapo, Excel inoratidzika yakananga uye yakananga mipumburu mabheji pamwe nechokumusoro uye kurudyi kweEccel skrini sekuratidzwa mumufananidzo uri pamusoro.
Kuvanza / Kuona Mipumburu Mabhairi
Cherechedza : Kana uri kuvanza bhora rakanyatsoperera kuti uwedzere nzvimbo yekuona nzvimbo yebasa racho, iwe uchafanira kusanidza cheShizha chemashizha sarudzo pamwe chete nebhuku repumburu rakananga. Izvi zvichabvisa bhandi rezasi yeExcel window fomu.
Kuti uvanze mutsara wepakati uye / kana mutsara wemipumburu mune zvabuda zve Excel (kubvira Excel 2010):
- Dzvanya paDhiyabhorosi tab kuti uzarure Firimu menyu;
- Dzvanya pakusarudza Options mu menu kuti uzarure Excel Options dialog box ;
- Mubhokisi rebhokisi, chengetedza Kufambira mberi muboshwe-kuruboshwe kuti uzarurire Advanced Options pane pane pane kurudyi-pane;
- Muchikwata chepamusoro, svitsa pasi kusvika kune Zvichasarudza zvarongwa zvechikamu chebhuku rebhuku - anenge hafu yezasi;
- Chengetedza (kuratidza) kana kusabvisa (chivanza) Bharitsa reZvita reError Horizontal uye / kana Ratidza Zviratidzo zveBurani yeZviporo sezvaunoda.
- Dzvanya OK kuti uvhare bhokisi rebhokisi uye dzokera kubheji rekushanda.
Resize Bharamu yeMipumburu Bhuku
Kana nhamba yemashizha mubhuku rebhuku inowedzera kusvika pakuti mazita emashizha ose haagoni kuverengwa panguva imwechete, imwe nzira yekugadzirisa iyi ndeyokuderedza usayizi hwepabhori yepumburu yakanyanyisa.
Kuita izvi:
- Isai pointer mouse pane vertical ellipsis (zvitatu zvakananga madotsiti) pedyo nechepamusoro pepumburu bhari;
- Purogiramu yeganda ichashandura kumuseve wemisoro miviri - sezvinoratidzwa mumufananidzo pamusoro apa kana yakanyatsoiswa;
- Dhinda uye ubatisise bhodhi reboshwe yemudhishi uye dhonzai pointer kurudyi kukonzera bhora rakanyanyisa ropumburu kana kuruboshwe kuti uwedzere bhari yemupumburu.
Kugadzirisa Vertical Scroll Bar Slider Range
Dhidhiro mumutsara wepakati-bhokisi rinotamuka uye richidzika pasi-mutsara-kushandura muhukuru sekuwanda kwenhare mumushandisi webasa rine data kuchinja.
Sezvo nhamba yemiganhu inowedzera, ukuru hwejirasi inoderera.
Kana uine pepa rekushanda rine nhamba shomanana yemitsara ine data, asi slide iri duku chaizvo uye ichifambisa kunyange kunyange zvishoma zvishoma zvinokonzera kuti pepa rekushandira rikwire kumusoro kana kuti pasi pasi mazana ezviuru kana zvisikwa, zvinokonzerwa nemutsara kana kunyange imwe sero iri kure pasi pebasa rekushanda rakagadzirirwa nenzira imwe.
Kugadzirisa dambudziko kunosanganisira kuwana uye kubvisa iro rine rine chekupedzisira shanduro yakagadzirwa.
Kushandiswa kwemasero hazvive neine data-kuchinja kuenzaniswa kwesero, kuwedzera muganhu, kana kutoshandisa kushingaira kana kuomesa mafomatiro kumasero asina chinhu zvakakwana kuti iite sero-uye izvi zvinogona kuita kuti uwane uye kubvisa rutsanga rine iyo cell inotyisa .
Kuwana Yekupedzisira Active Row
Danho rokutanga nderokuita kopi yekuchengetedza yebhuku rebhuku. Zvitevedzo zvinotevera zvinosanganisira kubvisa miganhu mubasa rekushanda, uye kana mitsara ine data yakanaka yakangobviswa zvisiri izvo, nzira inonyanya kuidzikinura ndeyokuva nekopi yekuchengetedza.
Kuti uwane mutsara wokupedzisira mubasa rebasa rine sero rakagadzirirwa:
- Dhinda maki eCtrl + Pamba pakibhodi kuti uende kune cell A1 mune pepa rekushanda.
- Dhinda makiroti eCtrl + End ekubhobhoyo kuti uende kuseri rekupedzisira mune pepa rekushanda. Iri sero richava nzvimbo yepakati-kati pakati pemuganhu wakaderera wakagadzirwa uye yakanyatsogadziriswa ikholomu.
Kusvuta Ikupedzisira Active Row
Sezvo iwe usingakwanise kuva nechokwadi chokuti mamwe mitsetse haasati yasimbiswa pakati pemutsara wekupedzisira we data yakanaka uye yekupedzisira yakasungirwa mutsara, iyo yakanyatsodzidza ndeyekubvisa mitsetse yose pasi pe data yako uye yekupedzisira yakarongwa mutsara.
Iva nechokwadi chekusarudza mitsetse yose yekubviswa nekudarika pamutsara we header ne mouse kana nekudhinda Shift + Space keys pane keyboard.
Kana imwe nguva mitsara yakasarudzwa,
- Kurudyi penya pamutsara wemusoro weimwe yemitsetse yakasarudzwa kuti uzarure mamiriro ekutenderera;
- Dzvanya paChenesa , pane menyu kuti ubvise mitsetse yakasarudzwa.
Tarisa Usati Wafa
Usati wabvisa mapepa chero ipi zvayo, ona kuti izvo iwe unofunga kuti ndiwo mutsara wokupedzisira wemashoko anokosha,, chaizvoizvo, mutsara wokupedzisira wemashoko anokosha, kunyanya kana bhuku rebasa rinoshandiswa nevanhu vanopfuura mumwe chete.
Hazvisi zvisingazivikanwi kuvhara dhiyabhorosi kunze kwebasa remazuva ano, saka zvinokurudzirwa kuongorora zvakakwana uye usati waenderera mberi nekubviswa.
Save the Workbook
Mushure mokubvisa zvose izvozvi, danho rekupedzisira nderekuchengetedza bhuku rebhuku. Kusvikira bhuku rebhuku rakaponeswa, hakuzovi nekushandura muhukuru uye mufambiro weshizha muburani repumburu.