Yadda ake canza yanayin takardar Excel zuwa shimfidar wuri. Yadda ake yin takarda mai faɗi a cikin Excel

Kamfanoni suna buƙatar takardu ta nau'i daban-daban. Ga wasu takardu, tsarin layi na kwance na bayanai ya dace, ga wasu - a tsaye. Sau da yawa yakan faru cewa bayan bugu, tebur na Excel bai cika ba ya bayyana akan takardar - an yanke mahimman bayanai saboda tebur bai dace da takardar ba. Ba za a iya ba da irin wannan takarda ga abokan ciniki ko gudanarwa ba, don haka dole ne a warware matsalar kafin bugawa. Canja yanayin allo yana taimakawa a yawancin waɗannan lokuta. Bari mu dubi hanyoyi da yawa don jujjuya takardar Excel a kwance.

Nemo Wayar Hannu a cikin Excel

Sheets a cikin daftarin aiki na Microsoft Excel na iya zama nau'i biyu na daidaitawa - hoto da shimfidar wuri. Bambance-bambancen da ke tsakanin su yana cikin yanayin yanayin. Hoton hoton ya fi tsayi tsayinsa - kamar shafi a cikin littafi. Tsarin shimfidar wuri - wannan shine yanayin lokacin da nisa na takarda ya fi tsayi, kuma an shimfiɗa takardar a kwance.

Shirin yana saita yanayin hoton kowane takarda ta tsohuwa. Idan an karɓi takaddun daga wani mai amfani, kuma ana buƙatar a aika wasu zanen gado don bugawa, yana da kyau a bincika wace daidaitawar aka saita. Idan ba ku kula da wannan ba, za ku iya ɓata lokaci, takarda da tawada daga harsashi. Bari mu gano abin da ya kamata a yi don ƙayyade yanayin takardar:

1. Bari mu cika takardar – ya kamata ya ƙunshi aƙalla wasu bayanai domin a ƙara ganin fuskar allo. Idan akwai bayanai akan takardar, ci gaba.
2. Bude Fayil shafin kuma nemo abin menu "Buga". Ba kome idan akwai firinta a kusa da ko an haɗa ta da kwamfuta - bayanan da ake buƙata zasu bayyana akan allon ta wata hanya.
3. Bari mu dubi jerin zaɓuɓɓukan da ke kusa da takardar, ɗaya daga cikin shafukan ya ce menene ma'anar takardar (a wannan yanayin, hoto). Hakanan zaka iya tantance wannan ta bayyanar takardar, tunda samfotin sa yana buɗewa a gefen dama na allo. Idan takardar tana tsaye - tsarin littafi ne, idan a kwance - shimfidar wuri.

Muhimmin! Bayan dubawa, layi mai digo ya bayyana akan takardar, yana rarraba filin zuwa sassa. Yana nufin iyakokin shafi idan an buga. Idan an raba tebur ta irin wannan layi zuwa sassa, ba za a buga shi gaba daya ba, kuma kuna buƙatar yin tsarin takarda don buga a kwance.

Yi la'akari da hanyoyi da yawa don canza matsayi na takardar mataki-mataki.

Canza Gabatarwa Ta Hanyar Buga Preferences

Kafin bugu, ba za ku iya kawai duba yadda takardar da shafukan da ke kan ta ke daidaitawa ba, amma kuma canza yanayinta.

1. Bude shafin "Fayil" kuma a kan kayan aiki kuma je zuwa sashin "Print".
2. Muna duba cikin jerin zaɓuɓɓuka kuma mu sami panel a ciki tare da rubutun "Portrait orientation". Kuna buƙatar danna kibiya a gefen dama na wannan rukunin ko kuma a kowane wuri a cikinsa.

3. Wani ƙaramin menu zai bayyana. Matsayin kwance na takardar ya zama dole, don haka za mu zaɓi yanayin shimfidar wuri.

Kula! Bayan canza daidaitawa zuwa samfoti, takarda a kwance ya kamata ya bayyana. Bari mu bincika ko duk ginshiƙan tebur yanzu an haɗa su a shafin. A cikin misali, komai ya yi aiki, amma wannan ba koyaushe yake faruwa ba. Idan, bayan saita yanayin shimfidar wuri, tebur bai dace da cikakken shafi akan shafin ba, kuna buƙatar ɗaukar wasu matakan, alal misali, canza sikelin fitarwar bayanai zuwa shafin lokacin bugawa.

Canjin daidaitawa ta hanyar kayan aiki

Sashen tare da kayan aikin Saita Shafi shima zai taimaka wajen yin shimfidar wuri a cikin tsari. Kuna iya zuwa gare ta ta hanyar zaɓuɓɓukan bugawa, amma ba shi da amfani idan za ku iya amfani da maɓallin "Portrait / landscape". Bari mu gano abin da za a iya yi don canza yanayin rabon takardar.

1. Bude shafin Layout shafi akan kayan aiki. A gefen hagu na shi akwai sashin “Page Setup”, nemi zabin “Orientation” a cikinsa, danna shi.

2. Abun "Tsarin yanayin ƙasa" shine wanda kuke buƙatar zaɓar. Bayan haka, layin dige-dige da ke raba takardar zuwa shafuka yakamata ya motsa.

Canza daidaitawar zanen gado da yawa a cikin littafi

Hanyoyin da suka gabata don juya takarda zuwa matsayi a kwance suna aiki ne kawai don takarda ɗaya na littafi. Wani lokaci yana da mahimmanci don buga zanen gado da yawa tare da daidaitawa daban-daban, don wannan za mu yi amfani da hanya mai zuwa. Ka yi tunanin cewa kana buƙatar canza matsayi na zanen gado da ke tafiya cikin tsari. Ga abin da kuke buƙatar yi don wannan:

1. Riƙe maɓallin "Shift" kuma nemo shafin farko mai alaƙa da takardar da kake son canzawa.
2. Zaɓi shafuka da yawa har sai an zaɓi duk takaddun da ake so. Launi na shafuka zai zama haske.

Algorithm don zaɓar zanen gado waɗanda ba su cikin tsari ya ɗan bambanta.

1. Riƙe maɓallin "Ctrl" kuma danna kan shafin da ake so na farko.
2. Zaɓi shafuka masu zuwa tare da danna linzamin kwamfuta ba tare da sakewa "Ctrl".

3. Lokacin da aka zaɓi duk shafuka, zaku iya sakin "Ctrl". Kuna iya gano zaɓin shafuka ta launi.

Na gaba, kuna buƙatar canza daidaitawar zanen gadon da aka zaɓa. Muna aiki bisa ga algorithm mai zuwa:

1. Bude shafin "Layout Page", nemo zabin "Orientation".
2. Zaɓi yanayin shimfidar wuri daga lissafin.

Yana da daraja a duba fuskantarwa na zanen gado tare da digege Lines. Idan suna nan kamar yadda ake buƙata, zaku iya ci gaba da buga daftarin aiki. In ba haka ba, kuna buƙatar maimaita matakan daidai gwargwadon algorithm.

Bayan an gama bugawa, yakamata ku cire rukunin zanen gadon don kada wannan rukunin ya tsoma baki tare da ayyukan gaba tare da tebur a cikin wannan takaddar. Mun danna ɗaya daga cikin zaɓaɓɓun zanen gado tare da maɓallin linzamin kwamfuta na dama kuma nemo maɓallin "Ƙungiyoyin Ƙungiya" a cikin menu wanda ya bayyana.

Hankali! Wasu masu amfani suna neman ikon canza daidaitawar shafuka da yawa a cikin takarda ɗaya. Abin takaici, wannan ba zai yiwu ba - babu irin waɗannan zaɓuɓɓuka a cikin Microsoft Excel. Ba za a iya samun canjin daidaitawar shafi ɗaya ba tare da ƙari ko dai.

Kammalawa

Matsakaicin takardar Excel hoto ne da shimfidar wuri, bambanci tsakanin su yana cikin yanayin yanayin. Kuna iya canza yanayin daidaitawa ta amfani da saitunan bugawa ko zaɓuɓɓuka akan shafin Layout Page, kuma kuna iya jujjuya zanen gado da yawa, koda basu da tsari.