A sauki amsar wannan tambaya: "Ta yaya ka ƙirƙiri wani tebur a Excel?"

A wannan labarin, za mu duba a cikin tsari na samar da wani falle. Mafi na kowa edita domin wannan - MS Office Excel. A shirin a tambaya ne wani ofishin aikace-aikace, da kuma shigar da shi da aka yi ta atomatik tare da dukan Microsoft Office suite na ofishin shirye-shirye.

A Excel, yafi amfani ga hadaddun lissafin, shirye-shiryen da Charts da jadawalai, kazalika da samar da allunan. Yadda za ka ƙirƙiri wani tebur a Excel? Don amsa wannan tambaya ba wuya a fara domin sanin version na Office shirye-shirye shigar a kan PC. Magana game da 2003 version.

Don fara, bude shirin:

• "Fara" button

• Menu abu "All Programs"

• Sashen "Microsoft ofishin"

• karamin sashe "Microsoft Office Excel 2003"

By tsoho, na farko page na edita zai kasance ne kawai biyu na asali bangarori amfani da kayan aikin, "Standard" da "format". Tare da kai tsaye halittar tebur, za ka bukatar wani toolbar mai suna "Tsara". Saboda haka, edita ne bude, amma yadda za a haifar da wani tebur a Excel?

Kowane cell farantin (cell) na da mutum adireshin kunshi jere lambar da shafi sunan. Mun ƙayyade yawan layuka da kuma ginshikan fitarwa tebur kuma zaɓi lambar da ake so na sel. Don ware da ake so gutsure ne Dole a saka siginan kwamfuta a cikin cell, wanda za a located a saman kwanar hagu na tebur, da kuma rike hagu linzamin kwamfuta button, kawo siginan kwamfuta zuwa kasa daga cikin nisa dama cell. Tare da ta dace mataki, za ku ga wani blue m bango na fitarwa tebur a baki firam.

Bugu da ari hanya ne za a samu a cikin toolbar mai suna "Tsara" button "Iyaka" da kuma zabi a kan iyakokin nan gaba tebur. Yadda za a yi a tebur a Excel dama size? Don yin haka, sanin da nisa daga ginshikan da layuka. A mafi sauki - dai kawai ya tura layuka da kuma ginshikan "da ido" saboda haka yin magana da zabin da fadi da tsawo. Lokacin da kibiyar linzamin kwamfuta a iyakar tsakanin m ginshikan ko layuka (a kan tafiya farantin) icon bayyana a matsayin tsaye line tare da biyu a kwance kibiyoyi. Tura ginshikan ko layuka iya zama kawai a gaban icon tare da hagu linzamin kwamfuta button.

Lura cewa bayyanar sama hali ga resizing layuka da kuma ginshikan gaba da rubutu "nisa" bayyana ko "tsawo" da na lamba tamanin da cell size. Idan ka akai-akai aiki da Tables a Excel edita mafi sauki ga saka da size a lambobin nan da nan, amma ba karba "da ido".

Yadda za ka ƙirƙiri wani tebur a Excel, idan wasu "taga" tebur dole a haɗa juna? Domin mu hada wasu daga cikin sel tare da juna, shi wajibi ne su gano waɗanda waxanda suke da shi a sãdar, kuma amfani da button "Ci & Center." Maimakon mahara Kwayoyin a daya bayyana a allon fi girma.

Yadda za ka ƙirƙiri wani Excel na wani launi daban-daban? Idan kana so ka zaɓa da daftarin aiki tebur a kowane launi, dole ku:

1. Zaɓi tebur.

2. Call dama linzamin kwamfuta button mahallin menu.

3. Zabi "Format Sel."

4. Ka je wa "View" tab.

5. Zaži so cika launi.

A cikin "Format Sel" menu kuma samar da wadannan ayyuka:

• Canza lambar girma na sel.

• Canza wuri daga cikin cell abinda ke ciki (rufi).

• Shirya rubutu shugabanci.

• Canza rubuta fuskantarwa.

• zabi na style kuma font style, da launi da kuma size.

• canje-canje a cikin cell / tebur kan iyakoki, kazalika da irin da kuma launi da aka zaba Lines.

Mu yanzu juya zuwa 2010-th version na Microsoft Office Excel. Yadda za ka ƙirƙiri wani tebur a Excel 2010? A cikin sabon version, an yi shi da daidai da wannan algorithm kamar yadda aka bayyana a sama, ko da sauƙin. Sauƙi na amfani ne da cewa a cikin Excel 2010 toolbar ne sosai fiye da a 2003. Akwai fassara kusan dukkan zama dole, kuma akai-akai amfani da mashiga, wanda a baya versions sun kawai samuwa ta yin amfani da mahallin menu kuma kira ƙarin windows.

Excel - daya daga cikin mafi amfani-friendly shirin for sauki halittar alluna! Muna fatan cewa ta hanyar karanta wannan talifin da kuma yin amfani da sama tips, za ka gan shi da misali!