Lokacin da kake buga takardar takardar Excel, sau da yawa shine lamarin cewa ɗigon rubutu bai dace ba a takarda takarda. Sabili da haka, duk abin da ya wuce wannan iyakar, wallafawa yana wallafa a kan ƙarin ɗakunan. Amma, sau da yawa, wannan halin da ake ciki zai iya gyara kawai ta hanyar canza canjin daftarin aiki daga littafin nan, wadda aka shigar ta hanyar tsoho, zuwa wuri mai faɗi. Bari muyi yadda za mu yi wannan ta amfani da hanyoyi daban-daban a Excel.
Darasi: Yadda za a yi takardar shimfiɗa wuri a cikin Microsoft Word
Sassin daftarin aiki
A cikin aikace-aikacen Excel akwai nau'o'i biyu don daidaitawar zanen gado lokacin bugawa: hoto da wuri mai faɗi. Na farko shine tsoho. Wato, idan ba ku aiwatar da kowane matsala tare da wannan wuri a cikin takardun ba, to, za'a buga shi lokacin da aka buga shi a zane-zanen hoto. Babban bambanci tsakanin wadannan nau'i-nau'i guda biyu shi ne cewa tare da tasirin hoto mai tsawo girman shafi ya fi nisa, kuma tare da wuri mai faɗi - madaidaiciya.
A gaskiya, ma'anar shafi na yada daga zane-zane na hoto zuwa wuri mai faɗi a cikin shirin Excel shine kadai, amma ana iya kaddamar da shi ta amfani da ɗaya daga cikin zaɓuɓɓuka. A wannan yanayin, ga kowane takarda na littafin, zaka iya amfani da matsayi naka. A lokaci guda, a cikin takarda ɗaya, wannan fasalin baza a iya canzawa ba don abubuwan da ya dace (shafuka).
Da farko, kana buƙatar gano ko za a juya daftarin aiki a kullun. Don wannan dalili, zaku iya amfani da samfoti. Don yin wannan, je shafin "Fayil"motsa zuwa sashe "Buga". A gefen hagu na taga akwai samfuri na takardun, yadda za a duba bita. Idan a cikin jirgin saman kwance an raba shi zuwa shafukan da yawa, wannan yana nufin cewa tebur bai dace a kan takardar ba.
Idan bayan wannan hanya za mu koma shafin "Gida" to, zamu ga layi na rabuwa. A cikin shari'ar lokacin da ya keɓe cikin tebur cikin sassan, wannan ƙarin shaida ne cewa a lokacin da bugu duka ginshiƙai a shafi guda ba zai yi aiki ba.
Bisa ga waɗannan yanayi, ya fi dacewa don sauya yanayin rubutun zuwa wuri mai faɗi.
Hanyar 1: Saitunan Saiti
Mafi sau da yawa, masu amfani suna amfani da kayan aiki a cikin saitunan buga don kunna shafin.
- Jeka shafin "Fayil" (A cikin Excel 2007, a maimakon haka, danna kan shafukan Microsoft Office a kusurwar hagu na taga).
- Matsar zuwa sashe "Buga".
- Yanayin samfoti wanda ya saba da mu ya buɗe. Amma wannan lokaci bazai sha'awa mu ba. A cikin toshe "Saita" danna maballin "Daidaitaccen Magana".
- Daga jerin jeri, zaɓi abu "Tsarin sararin samaniya".
- Bayan haka, za a sauya daidaitaccen shafi na takardar Excel ɗin zuwa wuri mai faɗi, wanda za'a iya kiyaye shi a cikin taga don samo rubutun da aka buga.
Hanyar 2: Tabbar Tafiyar Shafi
Akwai hanya mafi sauki don sauya daidaitawar takardar. Ana iya yin shi a shafin "Layout Page".
- Jeka shafin "Layout Page". Danna maballin "Gabatarwa"wanda aka samo a cikin kayan aiki "Saitunan Shafin". Daga jerin jeri, zaɓi abu "Yanki".
- Bayan haka, za a canza daidaitawar takardar zamani a wuri mai faɗi.
Hanyar Hanyar 3: Sauya daidaitattun shafuka masu yawa a lokaci guda
Lokacin amfani da hanyoyi da aka bayyana a sama, kawai takardar yanzu yana canza canjinta. A lokaci guda, yana yiwuwa a yi amfani da wannan saitin zuwa wasu abubuwa masu kama da juna a lokaci guda.
- Idan zanen gado wanda kake buƙatar aiwatar da aikin ƙungiya yana kusa da juna, to, ku riƙe maɓallin Canji a kan keyboard kuma, ba tare da sakewa ba, danna kan lakabin farko wanda yake a cikin ƙananan hagu na taga sama da matsayi na matsayi. Sa'an nan kuma danna kan lakabin karshe na kewayon. Ta haka ne, za a yi tasiri gaba ɗaya.
Idan kana buƙatar canza jagoran shafuka a kan wasu shafuka masu yawa, ƙididdiga waɗanda ba a samuwa kusa da juna ba, to, algorithm na ayyuka yana da ɗan bambanci. Danna maɓallin Ctrl a kan maɓalli kuma danna kowane gajeren hanyar da kake son yin aiki, tare da maɓallin linzamin hagu. Sabili da haka, abubuwan da ake bukata zasu zama alama.
- Bayan an zaɓa, yi aikin da ya saba da mu. Jeka shafin "Layout Page". Muna danna maballin kan tef "Gabatarwa"wanda ke cikin kungiyar kayan aiki "Saitunan Shafin". Daga jerin jeri, zaɓi abu "Yanki".
Bayan haka, duk zanen da aka zaɓa za su sami daidaituwa akan abubuwan.
Kamar yadda kake gani, akwai hanyoyi da dama don canja yanayin zane-zane zuwa wuri mai faɗi. Hanyoyi biyu na farko da muka bayyana ta dace don sauya sigogi na takardun yanzu. Bugu da ƙari, akwai ƙarin zaɓi wanda zai ba ka damar yin canje-canje na jagora a kan takardun yawa a lokaci guda.
