Lokacin da ka buga daftarin aiki na Excel, sau da yawa akwai yanayi inda teburin nisa bai dace da takaddara takarda ba. Sabili da haka, duk abin da ya wuce wannan iyakar, ɗab'i yana buga kan ƙarin zanen gado. Amma, sau da yawa, ana iya gyara wannan yanayin ta hanyar canza daidaituwa kawai na takaddar daga hoton, wanda aka shigar ta tsohuwa, zuwa shimfidar wuri. Bari mu ga yadda ake yin wannan ta amfani da hanyoyi daban-daban a cikin Excel.
Darasi: Yadda za a yi bayanin wuri mai faɗi a cikin takardar
Daftarin aiki yada
A cikin aikace-aikacen Excel, akwai zaɓuɓɓuka guda biyu don daidaiton takardar lokacin ɗab'i: hoto da shimfidar wuri. Na farkon shine tsoho. Wato, idan ba ku aiwatar da wani magudi ba tare da wannan tsarin a cikin takaddar, to lokacin da aka buga shi zai fito a cikin hoton hoton. Babban bambanci tsakanin waɗannan nau'ikan sakawa biyu shine cewa a cikin hoton hoton tsayin shafin ya fi girma, kuma a cikin shimfidar wuri mai faɗi, akasin haka.
A zahiri, hanyar don hanya don juyar da shafi daga hoto zuwa wuri mai faɗi a cikin Excel shine kawai, amma ana iya ƙaddamar da amfani da ɗayan zaɓuɓɓuka da yawa. A lokaci guda, zaku iya amfani da nau'in matsayin ku a cikin kowane takarda kowane littafi. A lokaci guda, a cikin takarda guda ɗaya ba zaku iya canza wannan sashi ba don abubuwan da ke tattare da shi (shafuka).
Da farko dai, kuna buƙatar gano ko yana da kyau a juya takarda kwata-kwata. Don waɗannan dalilai, zaku iya amfani da samfoti. Don yin wannan, je zuwa shafin Fayilolimatsa zuwa sashen "Buga". A gefen hagu na taga akwai yankin samfoti na takaddar, yadda zai kaya akan buga. Idan an rarrabu zuwa shafuka da yawa a cikin jirgin sama na kwance, wannan yana nufin cewa teburin bazai dace da takardar ba.
Idan bayan wannan hanyar zamu koma shafin "Gida" sannan zamu ga hanyar da ta lalace. Game da batun yayin da ya rarraba teburin tsaye cikin sassa, wannan ƙarin tabbaci ne cewa lokacin buga duk ginshiƙai a shafi ɗaya ba za'a sanya shi ba.
Ganin irin waɗannan yanayin, zai fi kyau a sauya jigon daftarin aiki zuwa wuri mai faɗi.
Hanyar 1: saitin saiti
Mafi sau da yawa, masu amfani suna juyawa kayan aikin da ke cikin saitunan bugawa don kunna shafin.
- Je zuwa shafin Fayiloli (maimakon haka, a cikin Excel 2007, danna kan tambarin Microsoft Office a saman kusurwar hagu na taga).
- Mun matsa zuwa sashin "Buga".
- Wurin da aka riga aka san shi yana buɗewa. Amma wannan lokacin ba za ta nuna sha'awarmu ba. A toshe "Saiti" danna maballin "Tsarin littafi".
- Daga jerin-saukar, zaɓi "Bayyanar wuri mai faɗi".
- Bayan haka, za a canza jigon shafi na takaddar Excel aiki zuwa wuri mai faɗi, ana iya ganinsa ta taga don samfotin daftarin da aka buga.
Hanyar 2: Tab ɗin Tsarin shafi
Akwai hanya mafi sauƙi don sauya daidaiton takardar. Ana iya yin sa a cikin shafin Tsarin shafin.
- Je zuwa shafin Tsarin shafin. Latsa maballin Gabatarwawanda yake a cikin shinge na kayan aiki Saitunan Shafi. Daga jerin-saukar, zaɓi "Ganin shimfidar wuri".
- Bayan haka, za a canza yanayin gabatarwar na yanzu zuwa wuri mai faɗi.
Hanyar 3: Canja daidaiton zanen gado a lokaci daya
Lokacin amfani da hanyoyin da ke sama, akwai canjin shugabanci kawai akan takardar yanzu. A lokaci guda, yana yiwuwa a aiwatar da wannan siga ga wasu abubuwan da suke kama guda lokaci guda.
- Idan mayafan da kuke son aiwatar da aikin rukuni sun kasance kusa da juna, to sai ku riƙe maɓallin Canji a kan maballin keyboard kuma, ba tare da sake shi ba, danna kan gajeriyar hanyar farko da ke cikin ƙananan hagu na taga a saman sandar matsayin. Daga nan saika latsa alamar layin karshe. Don haka, za a fifita kewayon gaba ɗaya.
Idan kanaso jujjuyawar shafi na shafuka akan wasu zanen gado wadanda alamominsu basu zama kusa da juna ba, to algorithm na ayyukan yayi dan kadan ne. Riƙe maɓallin Ctrl A kan maballin keyboard ka latsa kowane gajeriyar hanya wacce kake son aiwatar da aiki tare da maɓallin linzamin kwamfuta na hagu. Don haka, abubuwan da suka zama dole a fadada su.
- Bayan da aka zaɓi zaɓi, muna aiwatar da aikin da muka saba. Je zuwa shafin Tsarin shafin. Danna maɓallin a kan kintinkiri Gabatarwalocated a cikin kungiyar kayan aiki Saitunan Shafi. Daga jerin-saukar, zaɓi "Ganin shimfidar wuri".
Bayan haka, duk zanen gado da aka zaɓa za su sami jigon abubuwan da ke sama.
Kamar yadda kake gani, akwai hanyoyi da yawa don sauya yanayin hoto zuwa wuri mai faɗi. Hanyoyi biyun farko da muka zayyana mana suna da canji don sauya sigogin takarda na yanzu. Bugu da ƙari, akwai ƙarin zaɓi wanda zai ba ku damar yin canje-canje a cikin shugabanci a kan zanen gado da yawa a lokaci guda.
