Don aiki a cikin Microsoft Excel, babban fifiko shine a koyi yadda za a saka layuka da ginshiƙai a cikin tebur. Ba tare da wannan karfin ba, ba shi yiwuwa a yi aiki tare da bayanan rubutu. Bari mu kwatanta yadda zaka kara wani shafi a Excel.
Darasi: Yadda za a ƙara wani shafi zuwa tebur na Microsoft Word
Saka shafi
A cikin Excel, akwai hanyoyi da dama don saka wani shafi akan takardar. Mafi yawansu ba su da sauki, amma mai amfani ba tare da amfani ba zai iya magance duk wani abu ba. Bugu da ƙari, akwai zaɓi don shigar da layuka ta atomatik zuwa dama na tebur.
Hanyar hanyar 1: sakawa ta hanyar rukunin kulawa
Ɗaya daga cikin hanyoyin da za a iya sakawa shine ta hanyar daidaitaccen tsarin kula da Excel.
- Mun danna a cikin rukunin kula da kwance tare da sunayen sunaye a kan bangaren da ke hagu wanda muke buƙatar shigar da shafi. A wannan yanayin, ana nuna alama a shafi. Danna maballin linzamin dama. A cikin menu da ya bayyana, zaɓi abu Manna.
- Bayan haka, an sanya sabon shafi a gaba a gefen hagu na yankin da aka zaba.
Hanyar 2: Ƙara ta hanyar menu na mahallin tantanin halitta
Zaka iya yin wannan aiki ta hanyoyi daban-daban, wato ta hanyar mahallin mahallin tantanin halitta.
- Danna kan kowane tantanin da ke cikin shafi zuwa dama na shafi da aka shirya don ƙarawa. Danna wannan abu tare da maɓallin linzamin linzamin dama. A cikin mahallin menu wanda ya bayyana, zaɓi abu "Manna ...".
- Wannan lokaci kari baya faruwa ta atomatik. Ƙananan taga yana buɗewa inda kake buƙatar bayanin abin da mai amfani zai saka:
- Gurbin;
- Hada;
- Shift Down Cell;
- An canza cell din zuwa dama.
Matsar da canjin zuwa matsayi "Shafi" kuma danna maballin "Ok".
- Bayan wadannan ayyukan, za a kara shafi.
Hanyar 3: Kullin Rubuta
Ana sanya ginshiƙai ginshiƙai ta amfani da maɓalli na musamman akan kintinkiri.
- Zaɓi tantanin halitta zuwa gefen hagu wadda kake son ƙarawa a shafi. Da yake cikin shafin "Gida", danna kan gunkin a cikin nau'in triangle maras kyau wanda ke kusa da button Manna a cikin asalin kayan aiki "Sel" a kan tef. A cikin menu da ya buɗe, zaɓi abu "Saka ginshikan akan takarda".
- Bayan haka, za a kara shafi a hagu na abin da aka zaɓa.
Hanyar 4: amfani da hotkeys
Har ila yau, sabon shafi za a iya kara ta amfani da hotkeys. Kuma akwai zaɓi biyu don ƙarawa
- Ɗaya daga cikinsu yana kama da hanyar shigarwa ta farko. Kuna buƙatar danna kan bangarori a kan gwargwadon ginin kwance wanda ke gefen hagu na yanki da aka sanya da kuma sanya maɓallin haɗin Ctrl ++.
- Don amfani da zaɓi na biyu, kana buƙatar danna kan kowane tantanin halitta a cikin shafi zuwa dama na yankin sakawa. Sa'an nan kuma rubuta a kan keyboard Ctrl ++. Bayan haka, karamin taga zai bayyana tare da zabi irin nau'in, wanda aka bayyana a hanyar na biyu na yin aiki. Ƙarin ayyuka suna daidai daidai: zaɓi abu "Shafi" kuma danna maballin "Ok".
Darasi: Hotunan Hot a Excel
Hanyar 5: Saka Siffofin Alloli
Idan kana buƙatar shigar da ginshiƙai da dama a lokaci daya, to Excel babu buƙatar ta don gudanar da wani aiki na dabam ga kowane ɓangaren, tun da za'a iya haɗa wannan hanya zuwa aikin daya.
- Dole ne ku fara zaɓar yawancin sel a cikin jeri na kwance ko sassan a cikin kwamiti na kula yadda kuna buƙatar ƙara ginshiƙai.
- Sa'an nan kuma amfani da ɗaya daga cikin ayyukan ta hanyar mahallin menu ko ta amfani da hotkeys waɗanda aka bayyana a cikin hanyoyin da suka gabata. Za a kara yawan ginshiƙai masu yawa a hagu na yankin da aka zaba.
Hanyar 6: Ƙara shafi a ƙarshen tebur
Duk hanyoyin da aka sama sun dace don ƙara ginshiƙai a farkon da a tsakiyar teburin. Za a iya amfani da su don saka ginshiƙai a ƙarshen tebur, amma a wannan yanayin dole ne ka yi tsarin dacewa. Amma akwai hanyoyi don ƙara wani shafi zuwa karshen teburin don haka an gane shi nan da nan ta hanyar shirinsa. Don yin wannan, kana buƙatar yin abin da ake kira "smart" tebur.
- Zaɓi layin tebur da muke son shiga cikin "mai kaifin baki".
- Da yake cikin shafin "Gida", danna kan maɓallin "Girma a matsayin tebur"wanda aka samo a cikin kayan aiki "Sanya" a kan tef. A cikin jerin da ke buɗewa, zaɓi ɗaya daga cikin jerin manyan styles don teburin a hankali.
- Bayan haka, taga yana buɗe inda za'a nuna alamar yankin da aka zaɓa. Idan ka zaɓi wani abu ba daidai ba, to, a nan za ka iya shirya shi. Abinda ya kamata a yi a wannan mataki shine duba ko an saita alamar rajistan. "Launin da rubutun". Idan teburinku yana da rubutun kai (kuma a mafi yawan lokuta akwai), amma wannan abu ba'a duba, to, kana buƙatar shigar da shi. Idan an saita dukkan saituna daidai, to danna danna maɓallin kawai. "Ok".
- Bayan wadannan ayyukan, an tsara zangon da aka zaba a matsayin tebur.
- Yanzu, domin ya haɗa da sabon shafi a cikin wannan tebur, ya isa ya cika kowane cell zuwa dama da shi tare da bayanai. Gurbin da wannan tantanin salula ɗin ke samuwa za ta zamanto ya zama tabular.
Kamar yadda kake gani, akwai hanyoyi da dama don ƙara sabon ginshiƙai zuwa takardar Excel, duka a tsakiyar teburin da kuma cikin matsanancin jeri. Don yin ƙarin asali kuma mai sauƙi kamar yadda ya yiwu, zai fi dacewa don ƙirƙirar tebur mai kira da ake kira. A wannan yanayin, lokacin da ƙara bayanai zuwa gawayin zuwa dama na teburin, za a haɗa shi ta atomatik a cikin hanyar sabon shafi.
