Yadda za a ci gaba da tebur a Excel

Anonim

Yadda za a ci gaba da tebur a Excel

Hanyar 1: Kayan aikin Kayan Kayan aiki

A "Table Sie" kayan aiki yana ba ka damar shirya teburin da aka gama ta hanyar canza kewayon ta hanyar shiga sabbin dabi'u. Idan baku haifar da irin wannan tebur da zaku iya gyara ba, yi shi, bin kwatancin da ke ƙasa, sannan gano yadda ake canza girmansa idan akwai buƙata.

  1. Yayin ƙirƙirar sel na cikakken tebur na cikakken tebur, zaka iya tantance layuka tare da gefe don kada ya ci gaba. Don yin wannan, haskaka duk ƙwayoyin da ake buƙata ta hanyar riƙe maɓallin linzamin kwamfuta na hagu.
  2. Zaɓi kewayon sel don ƙirƙirar tebur lokacin fadada don fice

  3. Bude shafin Inda.
  4. Ka je wa shafin Inda don ƙirƙirar tebur lokacin da fadada shi zuwa fice

  5. Fadada sashin farko na "Tables".
  6. Zabi tebur don ƙirƙirar tebur lokacin da fadada zuwa fice

  7. A cikin menu wanda ya bayyana, zaɓi zaɓi da ya dace don ƙirƙirar tebur ta hanyar koyo game da fasali na kowane ɗayan bayanan masu tasowa.
  8. Zabi zabi zaɓi na tebur don fadada shi a fice

  9. Lokacin ƙirƙirar wurin da bayanan ana nuna shi ya danganta da ƙiyayyun da aka zaɓa, don haka ba lallai ba ne don canja siga.
  10. Zaɓi kewayon sel don ƙirƙirar tebur lokacin fadada fice

  11. An riga an ƙirƙiri teburin tare da layin kirtani, don haka ci gaba ba zai zama dole ba.
  12. Haƙiƙa latsar kan tebur yayin fadada shi a fice

Idan an ƙirƙiri teburin a baya, kuna buƙatar yin bambanci daban:

  1. A kan mai ƙira, danna maɓallin "tebur girma" maɓallin ".
  2. Button don fadada tebur lokacin da ya ci gaba a cikin shirin Excel

  3. Taggawa zai bayyana wanda ya shiga sabon kewayon tare da lissafin fadada tebur, sannan kuma tabbatar da canje-canje.
  4. Shiga sabon kewayon bayanai don mika tebur a cikin shirin Excel Shirin

  5. Komawa tebur kuma tabbatar da cewa duk ayyukan da aka kammala daidai kuma sakamakon ya dace da kai.
  6. Nasarar karin haske game da tebur ta hanyar kayan aiki a fice

Yanzu, da zaran tsawaita tebur ana buƙatar sake buƙatar sake buƙatar sake buƙatar sake buƙatar sake kunna wannan kayan aiki kuma saita sabon ƙimar da ake buƙata na layuka.

Hanyar 2: Tabilolin menu

Lokacin aiki tare da tebur da aka gama don fadada, zaku iya amfani da menu na mahallin sa da "Saka" aikin. Wannan zai ƙara layi ɗaya kawai, amma babu abin da zai hana menu don fadada tebur.

  1. Danna ɗayan layuka na tebur tare da maɓallin linzamin kwamfuta na dama.
  2. Kira menu na mahallin don mika tebur a cikin shirin Excel

  3. A cikin menu na mahallin, zaɓi maɓallin "Saka".
  4. Zaɓi Saka Aikin ta hanyar menu na mahallin don fadada tebur a fice

  5. Za'a ƙara kirtani mara waya zuwa wurin tebur inda aka yi fayilolin pkm.
  6. Nasara ci gaba da tebur ta hanyar menu na menu a fice

Hanyar 3: "Menu na Sell"

A menu na "tantanin halitta, akwai wani fasali na daban don shigar da kirtani wanda zai zama da amfani idan wurin a teburin ya riga ya ƙare. Yana aiki da wannan kayan aiki ta hanyar misalin tare da wanda ya gabata, amma ana kiranta daban.

  1. A shafin gida, fadada "sel na sel".
  2. Canja zuwa sel sel don fadada tebur a fice

  3. A cikin kwamitin da ya bayyana, danna "Manna".
  4. Kira kayan aiki don ci gaba da tebur ta hanyar menu na menu na Forevie

  5. Zaɓi zaɓi da aka shigar da kirtani zuwa takarda ko ginshiƙai, ya danganta da abin da tebur ke ci gaba.
  6. Amfani da Kayan Shirya Tebur ta hanyar menu na tantanin halitta

Idan sau da yawa gamuwa da buƙatar faɗaɗa kwamfyutocin, kula da zaɓuɓɓukan "Smart". Game da ƙirƙirar irin waɗannan abubuwa a Excel, karanta labarin da ke ƙasa.

Kara karantawa: Amfani da "Tables masu wayo" a Microsoft Excel

Kara karantawa