Kashe shimfidar shafi a Microsoft Excel

Yanayin shimfidar shafin a cikin Excel kayan aiki ne mai matukar dacewa wanda zaku iya gani nan da nan yadda abubuwa zasu bayyana akan shafin yayin bugawa da shirya su a can. Bugu da ƙari, a cikin wannan yanayin, ana samun ƙafafu na gani - bayanin kula na musamman akan ɓangaren saman da saman shafukan da basu iya gani cikin yanayin aiki na al'ada. Amma, duk da haka, nesa da aiki koyaushe a irin wannan yanayin yana dacewa ga duk masu amfani. Haka kuma, bayan mai amfani ya sauya yanayin aiki na al'ada, zai lura cewa koda layin da ya fasa zai kasance a bayyane wanda ke nuna iyakokin shafin.

Share markup

Bari mu gano yadda za a kashe yanayin shimfiɗar shafi kuma mu rabu da zanen iyakokin iyakokin a kan takardar.

Hanyar 1: kashe shimfidar shafi a sandar hali

Hanya mafi sauƙaƙa don ficewa daga yanayin shimfidar shafi shine canza shi ta hanyar gunki akan sandar matsayin.

Maballin abubuwa uku a cikin gumakan don sauya yanayin gani suna a gefen dama daga sandar matsayi zuwa hagu na ikon zuƙowa. Amfani da su, zaku iya saita hanyoyin aiki masu zuwa:

• talakawa;
• shafi;
• shimfidar shafi

A cikin hanyoyi biyu na ƙarshe, an rarraba faren ɗin zuwa sassa. Don cire wannan rabuwa, kawai danna kan gunkin "Al'ada". Yanayin ya sauya.

Wannan hanyar tana da kyau a cikin wannan ana iya amfani dashi a cikin dannawa ɗaya, kasancewa cikin kowane shafin shirin.

Hanyar 2: Duba shafin

Hakanan zaka iya canza yanayin aiki a cikin Excel ta amfani da maɓallin maballin akan kintinkiri a cikin shafin "Duba".

1. Je zuwa shafin "Duba". A kan kintinkiri a cikin akwatin kayan aiki Tsarin Canjin Littafin danna maballin "Al'ada".



2. Bayan haka, shirin zai sauya daga yanayin aiki a yanayin sakawa zuwa al'ada.

Wannan hanyar, ba kamar wacce ta gabata ba, ta ƙunshi ƙarin manipulations masu alaƙa da juyawa zuwa wani shafin, amma, duk da haka, wasu masu amfani sun fi son amfani da shi.

Hanyar 3: cire layin da ya lalace

Amma, koda kun sauya daga shafi ko yanayin shimfidar shafi zuwa al'ada, layin da ya lalace tare da gajeren layuka, ya karya takardar cikin gundarin, zai kasance har yanzu. A gefe guda, yana taimakawa wajen kewayawa ko abubuwan cikin fayil ɗin zasu dace da takardar da aka buga. A gefe guda, ba kowane mai amfani ba ne zai son irin wannan ɓangaren takardar; zai iya karkatar da hankalin sa. Haka kuma, ba kowane takaddara aka tsara musamman don bugawa ba, wanda ke nufin cewa irin wannan aikin ya zama mara amfani.

Ya kamata a sani yanzunnan hanya mai sauƙi ta rabu da waɗannan layin gajeren layuka shine sake kunna fayil ɗin.

1. Kafin rufe taga, kar a manta don adana sakamakon canje-canje ta danna kan gunkin a wani nau'in diskette a kusurwar hagu ta sama.



2. Bayan haka, danna kan gunkin a cikin farin farin giciye wanda aka rubuto a cikin wani murabba'in ja a saman kusurwar dama ta window, wato, danna maballin kusa. Ba lallai ba ne a rufe dukkanin windows ɗin idan kuna da fayiloli da yawa da ke gudana a lokaci guda, tunda ya isa ya kammala aikin a waccan takaddar takaddama inda layin da aka lila yake.



3. Za a rufe takaddun, kuma lokacin da kuka sake kunna shi, layin gajeren layuka da suka fasa takardar ba za su kasance ba.

Hanyar 4: cire fashewar shafi

Kari akan haka, za'a iya yiwa alamar takardar aikin Excel tare da dogayen layuka masu tsayi. Wannan abun ana kiransa hutu shafi. Ana iya kunna shi da hannu kawai, don yin amfani da shi don kashe shi kuna buƙatar yin wasu jan hankali a cikin shirin. Irin waɗannan gibba an haɗa su idan kuna son buga wasu sassa na takaddun daban daga babban ɓangaren. Amma, irin wannan buƙata ba ta kasancewa koyaushe, ƙari, wannan aikin ana iya kunna shi ta hanyar sakaci, kuma sabanin layout shafi mai sauƙi, ana iya gani ne kawai daga allon mai duba, waɗannan gibin za su tsage takaddama a zahiri yayin bugawa, wanda a mafi yawan lokuta ba a yarda da su ba . Sannan batun batun cire wannan fasalin ya zama ya dace.

1. Je zuwa shafin Alama. A kan kintinkiri a cikin akwatin kayan aiki Saitunan Shafi danna maballin Hutu. Droparin saukar menu yana buɗewa. Je zuwa kayan Sake saita Shafin hutu. Idan ka danna abun "A share hutun shafi", sannan abu guda kawai za'a share, sauran kuma zasu rage akan takardar.



2. Bayan haka, za a cire gibba a cikin nau'i na layin dogon da ya fasa. Amma kananan lamuran layi na alamar za su bayyana. Su, idan kun yi la'akari da shi wajibi ne, za a iya cire su, kamar yadda aka bayyana a cikin hanyar da ta gabata.

Kamar yadda kake gani, kashe yanayin layout shafi abu ne mai sauki. Don yin wannan, kawai kuna buƙatar canzawa ta latsa maɓallin dacewa a cikin dubawar shirin. Domin cire alamun nuna farin ciki, idan ya rikitar da mai amfani, kuna buƙatar sake kunna shirin. Ana cire gibin a cikin hanyar Lines tare da layi mai tsayi mai tsayi ta hanyar maɓallin akan kintinkiri. Saboda haka, don cire kowane bambance-bambancen na kayan talla, akwai keɓaɓɓen fasaha.