Kodi muli ndi mafayilo okhala ndi mapepala ambiri? Zochulukadi - khumi ndi awiri? Kupita patsamba lakumanja m'buku lotere kumatha kukhala kokhumudwitsa - mpaka mutapeza tsamba loyenera, mpaka mutadina ...
Njira 1. Makiyi otentha
Kusakanikirana Ctrl+PgUp и Ctrl+PgDown kukulolani kuti mutembenuzire buku lanu mmbuyo ndi mtsogolo.
Njira 2. Kusintha kwa mbewa
Dinani basi kulondola dinani mabatani a mpukutu kumanzere kwa ma sheet ndikusankha pepala lomwe mukufuna:
Zosavuta komanso zokongola. Imagwira ntchito mumitundu yonse ya Excel.
Njira 3. Zamkatimu
Njirayi ndi yovuta, koma yokongola. Chofunikira chake ndikupanga pepala lapadera lokhala ndi maulalo olowera kumasamba ena abuku lanu ndikuligwiritsa ntchito ngati mndandanda wazomwe zili mkati.
Lowetsani pepala lopanda kanthu m'buku ndikuwonjezera ma hyperlink pamapepala omwe mukufuna pogwiritsa ntchito lamulo Insert - Hyperlink (Ikani - Hyperlink):
Mutha kuyika zolemba zomwe zikuwonetsedwa mu cell ndi adilesi ya cell pomwe kudina ulalo kumatsogolera.
Ngati pali masamba ambiri ndipo simukufuna kupanga maulalo angapo pamanja, mutha kugwiritsa ntchito macro okonzeka kupanga mndandanda wazomwe zilimo.
- Momwe mungapangire mndandanda wazinthu za buku la Excel kuti muyende mwachangu kupita patsamba lomwe mukufuna
- Kupanga zokha zolemba zamabuku patsamba lina lomwe lili ndi ma hyperlink (zowonjezera za PLEX)