Yadda za a buga tebur mai kyau a kan takarda ɗaya. Canza daidaituwa, saita iyakokin iyakokin da layuka, shafi da sigogi

A karshen aikin a Microsoft Office Excel, masu amfani suna da buƙatar buga takaddar. Kayan aikin da aka gina cikin shirin yana ba ku damar buga teburin gaba ɗaya a kan takardar A4. Koyaya, wannan zai buƙaci ƙirar da yawa waɗanda za a tattauna a wannan labarin.

Kafa Page Page

Da farko dai, dole ne ka duba saitunan don takardar aiki na yanzu ka canza su idan ya cancanta. Akwai waɗannan sigogi da yawa cikin Forevicel, don cikakken fahimtar taken, wajibi ne don lura da cikakken bayanin kowannensu.

Hanya zuwa "sigogi na shafi" taga. Algorithm ya dace da duk juyi na shafuka

Wannan shine dubawa daga saman taga shirin. Wasu daga abubuwan sa dole suyi amfani da lokacin saita sigogin takardar.

Shafi

Don bincika kwatancen takardar kuma daidaita shi, ya zama dole a yi ayyukan da ke gaba akan algorithm:

1. Canja zuwa "Page Markup" Tab a saman Microsoft Excel.
2. A kasan bangare don nemo shafin "Saitunan Page" kuma ka latsa Dattijon, wanda yake a kusurwar dama. Taga mai dacewa ya kamata a buɗe.
3. Matsa zuwa sashin "Shafin" don yin saitunan da suka dace.

Ayyukan da ke buƙatar kashe su a ɓangaren "Shafin" don sanya teburin akan takardar aiki ɗaya

Lokacin da aka buga tebur a Excel, yana da mahimmanci don la'akari da girman filin. Wannan shine nesa wanda yake daɗaɗɗa daga gefen ganye kafin farkon rubutun. Duba abubuwan da aka nuna don filayen kamar haka:

1. Dangane da makirci iri daya ne aka tattauna a sakin layi na baya, matsa zuwa sashin "Page Markup" a saman shirin, sannan ka latsa lkm akan maɓallin "Page".
2. A cikin taga na saba, wanda za a nuna bayan aiwatar da waɗannan magudi na, kuna buƙatar zuwa shafin "filayen" shafin.
3. Wannan sashin mai amfani yana da sha'awar abu "Cibiyar Pages". Ya danganta da gabaɗaya takardar a nan kuna buƙatar saka alama ko a gaban filin "a tsaye" ko kusa da darajar "a kwance".
4. Canza ƙimar saman da kasan ƙafa idan ya cancanta. Koyaya, wannan ba za a iya yi a wannan matakin ba.

Canza ƙimar babba da ƙarami a cikin filayen shafin. Hakanan ana bada shawarar yin amfani da aikin cibiyar.

Wannan shine shafin ƙarshe a shafin "Saitunan Page", wanda ke da alhakin ingancin da aka buga. A cikin wannan ɓangaren, zaku iya tantance ɗayan nau'ikan bugu: Grid, baki da fari, m, sitters da kuma ginshiƙai. Hakanan yana yiwuwa a ayyana wani ɓangare na tebur don bugawa idan ba'a sanya farantin "a kan takarda ɗaya ba a cikin" buga kewayon layin "Buga.

Bayanin canzawa "Sheet" a cikin sigogin shafin "Window na footers

Waɗannan sune wasu wurare na takaddar da za a buga ta atomatik a kowane yanki. Rage ƙimar ƙafa, mai amfani yana sa ƙarin sarari akan takardar aikin, wanda zai taimaka wajen haskaka alamar. Don cire gaba daya ta hanyar rubutun daga duk takardun da zasu bayyana lokacin bugawa, dole ne kuyi aiki bisa ga umarnin:

1. Je zuwa shafin Markup "Page Markup" a saman menu na babban shirin.
2. Latsa sau ɗaya akan maɓallin "Page" maɓallin "Page".
3. Danna kan kalmar "footers" a cikin Windows da aka nuna a cikin Interface Windows.
4. A cikin filayen "ƙafa mai girma" da "ƙafa" saita darajar "(a'a)" don ware ta cikin rubutun.

Kashe kai a cikin sashin da ya dace

Lokacin da mai amfani yana nuna duk sigogi masu mahimmanci, zai yuwu a canza zuwa Takaran buga littattafan. A saboda wannan dalili, dole ne kuyi matakan masu zuwa:

1. Hakanan, shiga cikin taga "Page" taga.
2. A cikin taga da ke buɗe, je zuwa shafin "shafin" shafin.
3. A kasan menu, kuna buƙatar danna maɓallin "Duba", bayan wanda babban menu ɗin menu ke buɗewa.
4. A hannun dama na taga wanda ya buɗe za a nuna wurin da tebur a kan takardar aiki. Idan komai ya dace da duk, to, kuna buƙatar danna maɓallin "Buga" wanda ke cikin kusurwar hagu na sama. Idan ya cancanta, a wannan taga, zaku iya gyara sigogin Buga kuma suna duba canje-canje.

Fitar da takaddar bugawa tare da samfoti

Yadda za a rage (damfara) don bugawa a takarda ɗaya na tsarin A4

Wani lokacin manyan masu girma a teburin inform ba su dace da takarda ɗaya ba. A halin da ake ciki yanzu, zaku iya rage teburin da aka yiwa girman da ake so don dacewa da shi akan takardar A4. Ana yin wannan hanya a cikin matakai da yawa, kowane ɗayan za a bayyana a ƙasa.

Shigar da takarda a shafi ɗaya

Wannan hanyar tana dacewa idan wasu ƙananan ɓangaren tebur sun wuce wani aiki mai aiki na tsarin A4. Don dacewa da farantin zuwa takardar daya, zaku buƙaci yin ayyukan da ba a haɗa su ba:

• Fadada ɓangaren fayil a saman kusurwar hagu na shirin ta hanyar danna shi sau ɗaya lkm.
• A cikin menu na mahallin, danna kan layin "Buga".

Hanyar zuwa "Buga sigogi" taga a Excel

• A gefen dama na taga nuni duk bayani kan buga takaddar. Anan mai amfani zai buƙaci nemo sashin "saitin".
• Danna dattijo da radom tare da ma'anar "na yanzu" kuma danna kan zabin "Shigar da takardar daya shafi."
• Jira har zuwa Microsoft Office Exceler ya ƙare da tsarin dacewa da teburin da rufe taga tare da saiti.
• Duba sakamakon.

Canjin filin

Matsakaicin darajar filin da aka nuna a excele yana ɗaukar wuri mai yawa a cikin takardar. Don kunna sarari, ya kamata a rage wannan sigin. Sannan tebur na iya sanya sanya shi a kan takardar daya. Wajibi ne a aikata kamar haka:

• A cewar makircin da aka tattauna a sama, je sashen "Shafi shafi", sannan danna maɓallin "Saitin Page".

Bude shafin "Saitunan Page". Mataki mataki-mataki Algorithm

• A cikin taga da aka nuna, canzawa zuwa sashin "filayen".
• Rage saman, ƙasa, hagu da dama na filayen ko sanya waɗannan sigogi, danna "Ok".

Canza girman filayen a cikin shafin da ya dace na "sigogi na shafi" Yanayin Page

Wannan zaɓi a Excel, wanda ya ba ka damar gani da iyakokin takardar aiki, kimanta girman su. Tsarin damfara tebur ta amfani da yanayin shafi ya kasu kashi matakai da yawa, kowannensu ya cancanci yin nazari a hankali:

• Bude takarda na yanzu kuma canzawa zuwa shafin "Duba", wanda yake saman menu na babban shirin.
• A cikin bude kayan aiki, danna maɓallin "Share Yanayin" don kunna zaɓi.

Ayyuka don kunna yanayin shafin a Foreved

• A cikin sabon taga, nemo layin shudi na biyu kuma motsa shi daga matsayin hagu zuwa matsanancin dama. Kamar yadda wannan tsiri motsa, girman tebur zai ragu.

Leafwa

Don dacewa da teburin tsari a kan takarda ɗaya, yana da mahimmanci don zaɓar yanayin sa daidai. Algorithm mai zuwa zai taimaka canza yanayin karatun na yanzu na daftarin aiki:

1. Juya yanayin hanya, wanda zai yuwu a fahimci yanayin wani yunƙuri a kan takardar aikin. Don kunna yanayin, dole ne ka je shafin "Duba" a saman menu na babban shirin, sannan a cikin kayan aikin da ke ƙasa, danna maɓallin "Page Markup".
2. Yanzu kuna buƙatar zuwa ɓangaren "Shafi shafi na Markup" kuma danna kan "fuskantarwa".
3. Canza daidaituwa na yanzu ka kalli wurin tebur. Idan an haɗa da tsararrun takardar aikin, to za a iya barin daidaituwa.

Canza daidaituwa na zanen a cikin fifita canza girman sel

Wani lokacin farantin baya tsoma baki tare da takardar guda ɗaya saboda manyan sel. Don gyara matsalar sel, ya zama dole a rage ko dai a tsaye ko madaidaiciyar hanya dangane da takamaiman yanayin. Domin raba abubuwan na tebur da tsari, dole ne a yi wadannan magidano:

• Cikakke shafi da ake so ko igiya a cikin tebur tare da maɓallin hagu na m faipulator.
• Danna kwayar lkm a kan iyaka na shafi na kusa ko layin kuma motsa shi a cikin hanyar da ta dace: a tsaye ko a kwance. Mafi hankali wanda aka nuna a cikin hotunan allo da ke ƙasa.

Adadin Jagora a cikin sel ya girma a Microsoft Office Excel

• Idan ya cancanta, canza girman duk sel. A saboda wannan dalili, da farko kuna buƙatar canjawa zuwa shafin "gida", sannan ku je sashen Sashe na "sel".
• Na gaba, tura subsection "kuma a cikin menu na mahallin, danna kan layi" layin tsayi na layin ".

Kunna aikin cika aikin tsawo

Buga bangare ko yanki mai kafawa

Are Excel, zaku iya buga wani ɓangare na tebur kawai. Don yin wannan, kuna buƙatar yin matakai da yawa akan algorithm:

1. Zaɓi yankin da ake so na teburin da aka sauya maɓallin linzamin kwamfuta na hagu.
2. Latsa maɓallin "fayil" a saman kusurwar hagu na allo.
3. Latsa layin "Buga".
4. A cikin karamin sashe, da kafa a gefen dama na allo, latsa LKM bisa ga "Print Dedicated gutsure" zaɓi.
5. Duba sakamakon. Aka zaɓa a baya ɓangare na tebur ya kamata a buga.

Buga alamomin da aka zaba kawai

Yadda za a buga tebur mara komai don cika da sel ga shafin gaba ɗaya

Don yin aikin da kuke buƙata:

1. Hakanan kunna maɓallin "Yanayin Page" ta hanyar juyawa zuwa shafin "Duba" shafin. Lines na Dotted cewa yankin za a yi alama sune iyakokin zanen gado.
2. Zaɓi wani tantanin halitta ta latsa maɓallin hagu na m faipulator.
3. Danna sel na PCM kuma zaɓi zaɓi na "tsarin tantanin halitta a cikin taga.
4. Placesarin menu na buɗe, wanda kuke buƙatar canzawa zuwa sashin "iyaka" daga sama.
5. Latsa "na waje" da kuma maɓallin "na ciki ta hanyar zaɓin pictormam.

Kunna Suttura na ciki don Table Blank

1. Latsa "Ok" a kasan taga kuma duba sakamakon.

Buga shafuka guda biyu na daftarin aiki akan takardar daya

Wannan aikin ya ƙunshi kunna buga busar buhuwa. Don aiwatar da wannan ikon buƙata:

1. Danna LkM akan maɓallin "fayil" a saman menu na ainihi.
2. Je zuwa sashe na "Buga" sashe.
3. Fadada da "Buga Buga" Buga "kuma zaɓi ɗaya daga cikin yiwuwar zaɓuɓɓuka ta hanyar karanta bayanin su.

Kunna buga bugu mai sau biyu a Fight

Ƙarshe

Don haka, a Excel, ya dace da tebur tare da adadi mai yawa akan takarda ɗaya yana da sauƙi. Babban abu don yin adadin magunguna da dama, babban wanda aka bayyana a sama.

Saƙo Yadda za a buga tebur mai kyau a kan takarda ɗaya. Canza daidaituwa, saita iyakokin iyakoki da layuka, sigogi na shafin da kuma buga da ya bayyana akan fasahar bayanai.