Ungayilungisa kanjani i-Header ku-Excel

Anonim

Ikhanda elikhuphukayo ku-Microsoft Excel

Ngezinhloso ezithile, abasebenzisi badinga isihloko setafula ngaso sonke isikhathi babona, noma ngabe ishidi lihlele. Ngaphezu kwalokho, kuvame ukudingekile, lapho uprinta idokhumenti kwi-Medical Medical (iphepha), kuboniswe unhlokweni wethebula ekhasini ngalinye eliphrintiwe. Ake sibheke ukuthi yiziphi izindlela ongazilungisa ngazo isihloko ku-Microsoft Excel application.

Ukuncipha unhlokweni ngentambo ephezulu

Uma isihloko setafula sitholakala emgqeni ongenhla, futhi asihlali ngaphezu komugqa owodwa, khona-ke ukulungiswa kwawo kungukusebenza okuyisisekelo. Uma imigqa eyodwa noma eziningi ezingenalutho ingaphezulu kwesihloko, kuzodinga ukususwa ukuze kusetshenziswe le ndlela yokwabelwa.

Ukuze uvikele isihloko, ngenkathi kuthebhu "yokubuka" yohlelo lwe-Excel, chofoza inkinobho ethi "Area Area Area". Le nkinobho isethethini ithuluzi lamathuluzi "ewindi". Ngaphezu kwalokho, ohlwini oluvula, khetha isikhundla "esivikelekile se-Upper Line".

Ukuqinisa umugqa ophezulu ku-Microsoft Excel

Emva kwalokho, isihloko esisekhoneni eliphezulu sizolungiswa, sihlala njalo ngaphakathi kwemingcele yesikrini.

Intambo ephezulu ihleliwe ku-Microsoft Excel

Ukulungisa isifunda

Uma kwenzeka nganoma yisiphi isizathu, umsebenzisi akafuni ukususa amaseli atholakalayo ngaphezulu kwesihloko, noma uma uqukethe umugqa ongaphezu koyedwa, khona-ke indlela engenhla yokuhlanganiswa ngeke ifane. Kuzofanele sisebenzise inketho ngokuqiniseka kwesifunda, noma kunjalo, esingeyona inkimbinkimbi yendlela yokuqala.

Okokuqala, sithuthela kuthebhu ethi "View". Emva kwalokho, chofoza esitokisini esedlule kakhulu ngaphansi kwesihloko. Okulandelayo, senza chofoza inkinobho "Bopha indawo", eyayivele ishiwo ngenhla. Ngemuva kwalokho, kumenyu evuselelwe, phinda ukhethe into ngegama elifanayo - "Bopha indawo".

Ukuqinisa indawo e-Microsoft Excel

Ngemuva kwalezi zinyathelo, isihloko setafula sizorekhodwa eshidini lamanje.

Le ndawo ihleliwe ku-Microsoft Excel

Ukususa ukuncipha kwekhanda

Noma ngabe yiziphi izindlela ezimbili ezibhalwe phansi zetafula elizolungiswa, ukuze ziphendule, kunendlela eyodwa kuphela. Futhi, senza ukuchofoza inkinobho ethepheni "Bopha indawo", kodwa kulokhu sikhetha isikhundla "sokususa ukuhlanganiswa kwezifunda".

Ukususa Ukuhlanganiswa Kwendawo ku-Microsoft Excel

Ukulandela lokhu, unhlokweni ophinwe uzokwenzeka, futhi lapho ephenya phansi, ngeke abonakale.

Isihloko sihlukaniswe kwi-Microsoft Excel

Ukuncipha unhlokweni

Kunezimo lapho kuphrinta idokhumenti kudinga ukuthi isihloko sikhona ekhasini ngalinye eliphrintiwe. Vele, ungahle uphule "itafula, nasezindaweni ezifiselekayo ukungena ekhanda. Kepha, le nqubo ingaphunyuka isikhathi esibalulekile, futhi, ngaphezu kwalokho, ushintsho olunjalo lungabhubhisa ubuqotho betafula, kanye nenqubo yokubalwa. Kukhona indlela elula kakhulu futhi ephephile ephephile itafula ngesihloko ekhasini ngalinye.

Okokuqala, singena kwithebhu "umaki wekhasi". Sifuna izilungiselelo ze- "Amapharamitha Emingcele. Ekhoneni layo elingezansi kwesokunxele kunesithonjana ngendlela yomcibisholo oblique. Chofoza kulesi sithonjana.

Shintshela kumapharamitha eshidi ku-Microsoft Excel

Iwindi livula ngamapharamitha ekhasi. Sithuthela kuthebhu "yeshidi". Ensimini eseduze kombhalo "Phrinta ekhasini ngalinye ngemigqa" Udinga ukucacisa izixhumanisi zomugqa lapho isihloko sitholakala khona. Ngokwemvelo, kumsebenzisi ongakulungele, lokhu akulula kangako. Ngakho-ke, chofoza inkinobho ebekwe ngakwesokudla kwenkambu yokungena yedatha.

Ikhasi le-Microsoft Excel

Iwindi elinamapharamitha ekhasi ligoqwa. Ngasikhathi sinye, ishidi liyasebenza lapho itafula litholakala khona. Vele ukhethe intambo (noma imigqa eminingana) lapho kufakwa khona isihloko. Njengoba ukwazi ukubona, izixhumanisi zifakwa ewindini elikhethekile. Chofoza inkinobho etholakala ngakwesokudla kwaleli windi.

Isihloko sokukhetha ku-Microsoft Excel

Iwindi livula ngamapharamitha ekhasi. Sisele kuphela ukuze sichofoze inkinobho ethi "KULUNGILE" etholakala ekhoneni layo elingezansi kwesokudla.

Igcina izilungiselelo zekhasi ku-Microsoft Excel

Zonke izenzo ezidingekayo zenziwa, kepha ngeke ubone izinguquko. Ukuze ubheke ukuthi igama lethebula manje seliphrintwe eshidini ngalinye, lithuthele kuthebhu "yefayela" yohlelo lokusebenza lwe-Excel. Okulandelayo, iya esigatshaneni esithi "Phrinta".

Ukuguqulwa kokubuka kuqala kwetafula ku-Microsoft Excel

Ngakwesokunene sewindows evule indawo yokubuka kuqala yombhalo ophrintiwe. Skrolela phansi phansi, futhi uqiniseke ukuthi lapho ukuphrinta, kuzokhonjiswa unhlokweni okhonjwe ekhasini ngalinye.

Ukubuka kuqala amatafula ku-Microsoft Excel

Njengoba ubona, kunezindlela ezintathu zokulungisa isihloko etafuleni le-Microsoft Excel. Ababili babo benzelwe ukuhlanganisa amatafula etafuleni, lapho besebenza nedokhumenti. Indlela yesithathu isetshenziselwa ukukhipha isihloko ekhasini ngalinye ledokhumenti ephrintiwe. Kubalulekile ukukhumbula ukuthi kungenzeka ukulungisa inhloko ngokulungiswa kwentambo kuphela uma kutholakala koyedwa, ngomugqa ophezulu weshidi. Phambilini, udinga ukusebenzisa indlela yokulungisa izindawo.

Funda kabanzi