Yadda zaka saka shafi a fice

Don aiki a Microsoft Excel, fifikon farko shine don koyon saka kirtani da ginshiƙai a cikin tebur. Ba tare da wannan fasaha ba, kusan ba zai yiwu ba a yi aiki tare da bayanan tabulul. Bari muyi ma'amala da yadda ake ƙara shafi a cikin eathel.

Darasi: Yadda ake ƙara shafi a cikin tsarin Microsoft Word

Saka Shuka

Areo Excel, akwai hanyoyi da yawa don saka shafi a kan takardar. Yawancinsu suna da sauƙi mai sauƙi, amma mai amfani na novice bazai magance komai ba nan da nan. Bugu da kari, akwai wani zaɓi don ƙara tuntuɓar kirtani zuwa dama na tebur.

Hanyar 1: Saka Ta Hanyar Gudanar da

Daya daga cikin hanyoyin mafi sauki na saka aiki ne ta hanyar aiki a kwance na A kwance.

1. Danna a cikin kwamiti na kwance tare da sunayen ginshikan bisa ga bangaren, zuwa hagu wanda kuke buƙatar sakawa ginshiƙai. A wannan yanayin, shafi an sanya shi gaba daya. Danna dama linzamin kwamfuta. A cikin menu wanda ya bayyana, zaɓi abu "Manna".



2. Bayan haka, ana ƙara sabon shafi nan da nan zuwa hagu na zaɓaɓɓen yankin da aka zaɓa.

Hanyar 2: Dingara tantanin halitta ta menu

Kuna iya aiwatar da wannan aikin kuma da ɗan bambanta, wato ta menu na menu na tantanin halitta.

1. Danna kan kowane tantanin halitta a cikin shafi zuwa dama na shafi da aka shirya don ƙarawa. Danna wannan kashi dama maɓallin linzamin kwamfuta. A cikin menu na mahallin wanda ya bayyana, zaɓi "Manna ...".



2. Wannan lokacin ƙara ba ta atomatik. Karamin taga yana buɗewa, wanda kake son tantance cewa mai amfani zai saka:
   • Shafi;
   • Layi;
   • Tantanin halitta tare da juyawa;
   • Tantanin halitta tare da motsi zuwa dama.

   Muna sake canzawa zuwa matsayin "shafi" kuma danna maɓallin "Ok".



3. Bayan waɗannan ayyukan, za a ƙara shafi.

Hanyar 3: button akan kintinkiri

Saurin kayan ginshiƙai za a iya yin amfani da maɓallin musamman akan tef.

1. Zaɓi tantanin halitta zuwa hagu wanda aka shirya don ƙara shafi. Kasancewa cikin "gida", danna maɓallin alamar alwatika, wanda ke kusa da maɓallin "Manna" a cikin tef ɗin. A cikin menu wanda ya buɗe, zaɓi ginshiƙai "Saka da ginshiƙai zuwa takardar" abu.



2. Bayan haka, za a ƙara shafi a hannun hagu na zaɓaɓɓen abun da aka zaɓa.

Hanyar 4: Amfani da makullin zafi

Hakanan, ana iya ƙara sabon shafi tare da makullin zafi. Kuma akwai zaɓuɓɓuka biyu don ƙara

1. Daya daga cikinsu ya yi kama da na farko da aka shigar. Kuna buƙatar danna ɓangare akan ɓangaren daidaitawa a kwance wanda yake hannun dama na yankin shigarwar da aka nufa da buga haɗin Ctrl ++ maɓallin Ctrl ++.



2. Don amfani da zaɓi na biyu, kuna buƙatar danna danna kan kowane sel a cikin shafi zuwa dama na yankin Saka. Sannan buga buga a cikin Ctrl ++ Myboard. Bayan haka, to, karamin taga tare da zabi na nau'in akwati, wanda aka bayyana a hanyar ta biyu na yin aikin. Gaba da ayyuka daidai iri ɗaya ne: Zaɓi jumlar "shafi" kuma danna maɓallin "Ok" maɓallin "Ok".

Darasi: Makullin zafi a cikin excele

Hanyar 5: Sanya ginshiƙai da yawa

Idan kana son manna nan manna ginshiƙai da yawa, to, ba lallai ba lallai ba ne don yin wani yanki don wannan, tunda ana iya haɗe wannan hanyar zuwa aiki ɗaya.

1. Dole ne ka fara zaɓar sel da yawa a cikin jerin kwance ko sassan akan allurar samar, guda nawa ake buƙatar ƙara abubuwa nawa.



2. Sa'an nan kuma shafa ɗayan ayyukan ta menu na mahallin ko tare da makullin zafi waɗanda aka bayyana a hanyoyin da suka gabata. Za'a ƙara adadin ginshiƙai a hannun hagu na yankin da aka zaɓa.

Hanyar 6: Dingara shafi a ƙarshen tebur

Dukkanin hanyoyin da ke sama sun dace da ƙara masu magana a farkon da kuma a tsakiyar tebur. Hakanan ana iya amfani dasu don saka ginshiƙai a ƙarshen tebur, amma a wannan yanayin dole ne kuyi tsarin da ya dace. Amma akwai hanyoyi don ƙara shafi zuwa ƙarshen tebur don nan da nan shirin ya gane shi nan da nan zuwa sashinsa na nan. Don yin wannan, kuna buƙatar yi, abin da ake kira "Smart" tebur.

1. Muna haskaka kewayon tebur da muke son juya zuwa "mai wayo" tebur.



2. Kasancewa a cikin gida, danna maɓallin "azaman tebur", wanda yake a cikin kayan aikin "salon" akan tef. A cikin jerin abubuwan dakatarwa, zaɓi ɗaya daga cikin manyan jerin salon ƙirar tebur a hankali.



3. Bayan haka, taga ta buɗe, wanda ke nuna masu tsara abubuwan da aka zaɓa. Idan kun lura da wani abu ba daidai ba, to, zaku iya shirya a nan. Babban abu shine cewa kana buƙatar yin a wannan matakin shine a bincika ko an shigar da shi kusa da taken "Table tare da kanun labarai". Idan teburinku yana da hat (kuma a mafi yawan lokuta haka ne), amma babu kasafu da wannan abun, to kuna buƙatar shigar da shi. Idan aka saita duk saitunan daidai, to kawai danna maɓallin "Ok".



4. Bayan waɗannan ayyukan, an tsara yankin da aka ƙaddamar azaman tebur.



5. Yanzu don kunna sabon shafi a cikin wannan tebur, ya isa ya cika kowane sel ga hannun dama. Shafin da wannan tantanin halitta zai zama nan da nan.

Kamar yadda kake gani, akwai hanyoyi da yawa don ƙara sabbin kayan aiki zuwa takardar farko da aka fice a tsakiyar tebur da kuma lokacin kwanakin. Don ƙara zuwa mafi sauƙi da dacewa, ya fi dacewa a ƙirƙiri, abin da ake kira "Smart" Tebur. A wannan yanayin, lokacin daɗa bayanai zuwa kewayon zuwa dama na tebur, za a haɗa ta atomatik a ciki azaman sabon shafi.