Saita kuma gyara wurin bugawa a cikin Excel

Mataki na ƙarshe na aiki akan takaddun Excel galibi ana aika su zuwa firinta. Lokacin da kake buƙatar buga duk bayanan akan takarda, yawanci babu matsaloli tare da wannan. Amma abin da za mu yi lokacin da muke hulɗa da babban tebur, kuma kawai wani ɓangare na shi yana buƙatar buga shi.

Kuna iya tsara wurin bugawa a cikin Excel ta hanyoyi daban-daban:

• saita duk lokacin da aka aika da takarda zuwa firinta;
• gyara wani yanki na musamman a cikin saitunan daftarin aiki.

Bari mu dubi hanyoyin biyu mu ga yadda ake aiwatar da su a cikin shirin.

Hanyar 1: Daidaita wurin kowane lokaci kafin bugawa

Wannan hanya ta dace idan muna son buga takarda sau ɗaya kawai, don haka babu buƙatar gyara wasu wurare don gaba. Koyaya, idan daga baya muka yanke shawarar buga wannan takarda, dole ne a sake yin saitunan.

Algorithm na ayyuka shine kamar haka:

1. A kowace hanya da ta dace (misali, ta amfani da maɓallin linzamin kwamfuta na hagu da aka danna), zaɓi kewayon sel waɗanda muke shirin aikawa don bugawa. Bari mu ce muna buƙatar buga tallace-tallace kawai don kantuna na farko da na biyu. Bayan zaɓi, danna kan menu "Fayil".
2. A cikin lissafin hagu, je zuwa sashin "Hatimi". A cikin ɓangaren dama na taga, danna kan zaɓin bugawa na yanzu (wanda yake nan da nan a ƙarƙashin sunan toshe "Parameters").
3. Jerin yuwuwar zaɓuɓɓukan bugawa za su buɗe:
   • zanen gado mai aiki;
   • dukan littafin;
   • guntun da aka zaɓa (muna buƙatar shi).
4. A sakamakon haka, kawai ɓangaren tebur ɗin da muka zaɓa za a nuna shi a cikin yankin samfotin daftarin aiki, wanda ke nufin cewa lokacin da aka danna maɓallin. "Hatimi" kawai wannan bayanin za a buga a takarda.

Hanya na 2: Gyara Wurin Buga Na Cigaba

A cikin lokuta inda aikin tare da takaddun ke gudana akai-akai ko lokaci-lokaci (ciki har da aika shi don bugawa), yana da kyau a saita wurin bugawa akai-akai. Ga abin da muke yi don wannan:

1. Kamar yadda a cikin hanyar farko, da farko zaɓi yankin da ake so na sel. Sannan canza zuwa shafin "Tsarin shafi"inda muka danna maballin "Yankin bugawa" a cikin akwatin kayan aiki "Saitunan Shafi". Tsarin zai ba mu zaɓuɓɓuka biyu: saita da cirewa. Mun tsaya a farkon.
2. Don haka, mun sami damar gyara wurin sel, waɗanda za a buga su akai-akai har sai mun yanke shawarar yin wani gyara. Kuna iya duba wannan a cikin yankin samfoti a cikin zaɓuɓɓukan bugawa (menu "Fayil" - sashe "Hatimi").
3. Ya rage kawai don adana canje-canje a cikin takaddar ta danna maɓallin da ya dace a cikin menu "Fayil" ko kuma ta danna gunkin floppy diski a saman kusurwar hagu na shirin.

Cire pinning daga wurin da ake bugawa

Bari mu ce muna buƙatar mu canza wurin da aka kafa ko cire shi gaba ɗaya. Don yin wannan, juya baya zuwa shafin "Tsarin shafi" a cikin zaɓuɓɓukan da ke buɗewa bayan danna maɓallin "Yankin bugawa" zabi wannan lokacin "A ajiye". A wannan yanayin, ba lallai ba ne don zaɓar kowane kewayon sel a cikin tebur.

Muna komawa zuwa saitunan bugawa kuma mu tabbatar da cewa sun koma na asali.

Kammalawa

Don haka, babu wani abu mai rikitarwa a saita takamaiman wurin bugawa a cikin Excel, kuma wannan hanya zata ɗauki mintuna kaɗan kawai da dannawa don kammalawa. Har ila yau, idan muka yi shirin yin aiki tare da takardar kuma mu buga shi, za mu iya gyara wani yanki na musamman da za a aika don bugawa a kowane lokaci, kuma ba za mu ƙara yin amfani da lokaci a kan wannan ba a nan gaba.