Yadda ake shimfiɗa tebur zuwa cikakken takarda a cikin Excel

Lokacin ƙirƙirar tebur a cikin Microsoft Office Excel, mai amfani zai iya ƙara girman tsararrun don faɗaɗa bayanan da ke cikin sel. Wannan yana da amfani lokacin da ma'auni na abubuwan asali sun yi ƙanƙanta da rashin dacewa don aiki tare da su. Wannan labarin zai gabatar da fasalulluka na haɓaka tebur a cikin Excel.

Yadda ake ƙara girman tebur a cikin Excel

Akwai manyan hanyoyi guda biyu don cimma wannan burin: don faɗaɗa ɗaiɗaikun sel na farantin da hannu, misali, ginshiƙai ko layi; yi amfani da aikin zuƙowa allo. A cikin akwati na ƙarshe, ma'auni na takardar aikin zai zama mafi girma, sakamakon abin da duk alamun da ke kan shi zai karu. Duk hanyoyin biyu za a tattauna dalla-dalla a ƙasa.

Hanyar 1. Yadda za a ƙara girman sel guda ɗaya na tsararrun tebur

Za a iya faɗaɗa layuka a cikin tebur kamar haka:

1. Sanya siginan linzamin kwamfuta a kasan layin don faɗaɗa kan iyakarsa tare da layi na gaba.
2. Duba cewa siginan kwamfuta ya juya zuwa kibiya mai gefe biyu.

3. Riƙe LMB kuma matsar da linzamin kwamfuta zuwa ƙasa, watau daga layi.
4. Ƙare aikin ja lokacin da ɗinkin ya kai girman girman mai amfani.

5. Hakazalika, faɗaɗa kowane layi a cikin teburin da aka gabatar.

Kula! Idan, riƙe LMB, fara motsa linzamin kwamfuta zuwa sama, layin zai ragu.

Girman ginshiƙan suna ƙaruwa ta hanya ɗaya:

1. Saita siginan linzamin kwamfuta zuwa gefen dama na wani takamaiman shafi, watau akan iyakarsa da shafi na gaba.
2. Tabbatar cewa siginan kwamfuta ya canza zuwa kibiya tsaga.
3. Riƙe maɓallin linzamin kwamfuta na hagu kuma matsar da linzamin kwamfuta zuwa dama don ƙara girman ginshiƙin asali.

4. Duba sakamakon.

Tare da hanyar da aka yi la'akari, za ku iya faɗaɗa ginshiƙai da layuka a cikin tebur zuwa ƙima mara iyaka har sai tsararru ta mamaye duk sararin takaddar aikin. Kodayake iyakokin filin a cikin Excel ba su da iyaka.

Hanyar 2. Yin amfani da kayan aikin da aka gina don ƙara girman abubuwan tebur

Hakanan akwai wata hanya ta dabam don ƙara girman layuka a cikin Excel, wanda ya haɗa da manipulations masu zuwa:

1. Zaɓi LMB ɗaya ko fiye da layi ta hanyar matsar da linzamin kwamfuta zuwa "saman-sasan" na takardar aikin, watau a tsaye.
2. Danna dama akan guntun da aka zaɓa.
3. A cikin mahallin menu, danna kan "Tsarin Layi ..." abu.

4. A cikin layi ɗaya na taga da ke buɗewa, maye gurbin ƙimar tsayin da aka rubuta tare da lamba mafi girma kuma danna "Ok" don aiwatar da canje-canje.

5. Duba sakamakon.

Don shimfiɗa ginshiƙai ta amfani da kayan aikin da aka gina a cikin shirin, zaku iya amfani da umarni mai zuwa:

1. Zaɓi a cikin jagorar kwance takamaiman ginshiƙi na tebur wanda ke buƙatar faɗaɗa.
2. Danna-dama a ko'ina a cikin ɓangaren da aka zaɓa kuma zaɓi zaɓi "Shafin Faɗin ..." zaɓi daga menu.

3. Kuna buƙatar yin rijistar ƙimar tsayin da zata fi ta yanzu girma.

4. Tabbatar cewa ɓangaren jeri na tebur ya ƙaru.

Muhimmin! A cikin windows "Shafin Nisa" ko "Row Height", za ka iya canza ƙayyadaddun ƙimar sau da yawa har sai mai amfani ya sami sakamakon da ake so.

Hanyar 3: Daidaita sikelin duba

Kuna iya shimfiɗa duk takardar a cikin Excel ta hanyar ƙara girman allo. Wannan ita ce hanya mafi sauƙi don kammala aikin, wanda aka raba zuwa matakai masu zuwa:

1. Bude daftarin aiki na Microsoft Excel da ake so ta hanyar gudanar da fayil ɗin da aka ajiye akan kwamfutarka.
2. Riƙe maɓallin "Ctrl" akan maballin PC kuma ka riƙe shi.
3. Ba tare da sakin “Ctrl” ba, gungura motar linzamin kwamfuta sama har sai girman allo ya ƙaru zuwa girman da mai amfani ke buƙata. Ta haka, dukan tebur zai yi girma.
4. Kuna iya ƙara girman allo ta wata hanya. Don yin wannan, yayin da ke kan takardar aikin Excel, kuna buƙatar matsar da darjewa a cikin ƙananan kusurwar dama na allo daga - zuwa +. Yayin da yake motsawa, zuƙowa a cikin takaddar zai ƙaru.

Ƙarin Bayani! Har ila yau, Excel yana da maɓallin “Zoom” na musamman a cikin shafin “Duba”, wanda ke ba ka damar canza sikelin allo sama da ƙasa.

Hanyar 4. Canja ma'auni na tsararrun tebur kafin buga daftarin aiki

Kafin buga tebur daga Excel, kuna buƙatar bincika sikelin sa. Anan zaka iya ƙara girman tsararrun don ɗaukar duk takardar A4. Zuƙowa kafin buga canje-canje bisa ga tsari mai zuwa:

1. Danna maɓallin "File" a saman kusurwar hagu na allon.
2. A cikin nau'in mahallin mahallin, danna LMB akan layin "Buga".

3. A cikin sashin "Saituna" a cikin menu wanda ya bayyana, nemo maɓallin don canza ma'auni. A cikin dukkan nau'ikan Excel, yana cikin ƙarshe a cikin jerin kuma ana kiransa "Yanzu".
4. Fadada ginshiƙi tare da sunan "Yanzu" kuma danna kan layin "Zaɓuɓɓukan ƙira na al'ada…".

5. A cikin taga "Zaɓuɓɓukan Shafi", je zuwa shafin farko, a cikin sashin "Scale", sanya maɓallin juyawa a cikin layin "Saita" kuma shigar da lambar haɓakawa, misali, 300%.
6. Bayan danna "Ok" duba sakamakon a cikin preview taga.

Kula! Idan tebur ba a kan dukkan shafin A4 ba, to kuna buƙatar komawa zuwa taga iri ɗaya kuma saka lambar daban. Don samun sakamakon da ake so, dole ne a maimaita hanya sau da yawa.

Kammalawa

Don haka, yana da sauƙi don shimfiɗa tebur a cikin Excel zuwa cikakken shafi ta amfani da hanyar sikelin allo. An yi bayaninsa dalla-dalla a sama.