Mukati
Paunenge uchishanda nematafura akareba asingakwane pahwindo uye aine nhamba huru yemakoramu, nguva nenguva pane kudikanwa kwekupeta skrini kuitira kuratidza mutsara wepamusoro une misoro pairi. Kuti zvive nyore, chirongwa cheExcel chinopa kugona kugadzirisa musoro wetafura kumusoro kwechidzitiro kwenguva yese iyo faira yakavhurwa. Sarudzo dzekuita izvi dzinokurukurwa pazasi.
Mutsara mumwe chete wepamusoro unoda kubaiwa
- Mumutsara wepamusoro weribhoni yepurogiramu, enda kune "Tarisa" tab.
- Muchikamu che "Window" (mazita echikamu anoratidzwa pazasi peribhoni), tsvaga chinhu "Freeze nzvimbo" uye tinya katatu muchikamu chayo chekurudyi.
- Muchinyorwa chinovhurwa, sarudza "Kiya mutsara wepamusoro" nekudzvanya bhatani rekuruboshwe. Mhedzisiro ichave iripo zvachose pachiratidziro chetafura yemusoro mutsara, iyo inoenderera kunyange mushure mekuvharwa kwefaira.
Mutsara wepamusoro wakapiniwa
Kubatanidza musoro kune mitsetse yakawanda
Kana iwe uchida kugadzirisa mitsara yakati wandei, saka iwe unofanirwa kuita zvakasiyana:
- Muchikamu chekuruboshwe chetafura, tinya pasero remutsara wekutanga risiri chikamu chemusoro. Muchiitiko ichi, iri sero A3.
Kutevedzana kwezviito zvekugadzirisa mitsara yakawanda - Enda kune "Tarisa" tebhu, tinya pa "Freeze Nzvimbo" uye sarudza chinhu che "Freeze Nzvimbo" kubva pakudonha-pasi. Nekuda kweizvozvo, mitsetse yese iri pamusoro peiyo iyo yakasarudzwa sero ichagadziriswa kumusoro kwechidzitiro.
Musoro unogadziriswa mutafura, inosanganisira mitsetse miviri yepamusoro
"Smart table" - imwe sarudzo yekugadzirisa musoro
Kana iwe uchijairana neExcel's smart spreadsheets, pane imwe nzira inobatsira yekuapinza. Ichokwadi, iyi sarudzo inoshanda chete munyaya yemusoro wemutsara mumwe chete.
- PaKumba tab yeribhoni, sarudza tafura yose.
- Muchikamu che "Styles" (pazasi peribhoni), tinya pane "Format seTafura" chinhu. Hwindo rine seti yezvitaera zvetafura richavhurwa. Mariri iwe unofanirwa kudzvanya pane yakanyanya kufanirwa sarudzo.
Checkbox "Table with headers" - Iwindo re "Table Formatting" rinobuda, umo miganhu yetafura yeramangwana inoratidzwa, uye bhokisi re "Table with Headers" rinowanikwawo. Ita shuwa kuti yekupedzisira inotariswa.
- Vhara hwindo nekudzvanya bhatani rekuti "OK".
"Smart table" ine musoro wakagadzika
Iwe unogona kugadzira "smart tafura" neimwe nzira:
- Mushure mekusarudza nzvimbo yaunoda, enda ku "Insert" ribhoni tab uye chengeta pa "Tables" chinhu.
- Mune pop-up list, tinya pane "Table" chinhu.
- Mushure me "Gadzira Tafura" hwindo raonekwa nezvirimo zvakafanana ne "Format Tafura" hwindo, iwe unofanirwa kutevedzera matanho akafanana neaya atotsanangurwa pamusoro. Nekuda kweizvozvo, "smart table" ichaonekwawo ine cap yakagadziriswa kumusoro.
Yechipiri nzira yekugadzira "smart tafura"
Madhinda sei tafura ine musoro pane yega yega peji
Pakudhinda tafura inotora mapeji akati wandei, zvinobatsira kuve nemusoro wayo papeji yega yega. Izvi zvinokutendera kuti ushande nechero peji rakadhindwa zvakasiyana. MuExcel, mukana uyu unopiwa uye unogona kuitwa sezvinotevera.
- Enda ku "Page Layout" ribhoni tebhu uye muchikamu che "Peji Setup" (pazasi peribhoni) tinya pabhokisi rine museve kurudyi rwechinyorwa.
Kutevedzana kwezviito muhwindo guru reExcel - Muwindo reKugadzira Peji rinovhurwa, enda kune Sheet tab.
- Dzvanya pabhokisi re "Kuburikidza nemitsetse" (yechipiri kubva kumusoro).
- Dzokera kutafura uye, nekufambisa chitubu, icho chatora chimiro chemuseve mutema unonongedza kurudyi, pamwe nekoramu ine nhamba dzemutsara, sarudza mutsara kana mitsetse umo musoro wetafura unowanikwa.
Kutevedzana kwezviito mu "Peji Setup" hwindo - Pane izvi, zviito zvese zvinopedzwa, asi mhedzisiro yavo haina kuratidzwa pachiratidziri.
Tafura yekuona mushure mekusarudza musoro kuti uiprinde papeji yega yega
Zvinokosha! Kuti uve nechokwadi chekuti chinangwa chinowanikwa, unofanirwa kuenda kune "Faira" ribhoni tab uye tinya pane "Print" chinhu. Muhwindo rinovhurwa, rudzi rwegwaro semugumisiro wekudhindwa kwaro hucharatidzwa.
Pano, nekudzvanya pamakona matatu mumutsara wepasi pehwindo kana nekukwenya vhiri rembeva, nekasevha pane peji retafura, unogona kuona mapeji ese kutarisa kuvepo kwemusoro pane yega yega.
mhedziso
MuExcel, pane nzira mbiri dzekutaridza zvachose musoro wetafura pachiratidziri. Chimwe chazvo chinosanganisira kushandiswa kwekugadzirisa nzvimbo, yechipiri - kushandura tafura kuva "smart" imwe nekugadzirisa nzvimbo yakasarudzwa yekuisa tafura mairi. Nzira mbiri idzi dzinoita kuti zvikwanisike kupinza mutsara mumwe, asi yekutanga chete inokubvumira kuti uite izvi nemusoro une mimwe mitsetse.. Excel inewo imwezve nyore - kukwanisa kudhinda gwaro rine musoro pane imwe neimwe peji, izvo zvechokwadi zvinowedzera kushanda kwekushanda nayo.