Contents
A cikin wannan labarin mai kashi 2, Terry yayi magana game da manufar salo a cikin Microsoft Excel. A kashi na farko, za ku koyi yadda ake tsara ƙwayoyin sel da wayo, a kashi na biyu kuma, za ku koyi ƙarin zaɓuɓɓukan tsara tsarin.
Styles a cikin Microsoft Excel Babu shakka yana ɗaya daga cikin abubuwan da aka yi watsi da su, da rashin amfani da su, da kuma rashin kima na Excel.
Duk da karuwar sararin samaniya akan Ribbon na Microsoft Excel 2007 da aka keɓe don wannan fasalin, yawancin masu amfani (na haɗa da kaina) suna yin kuskuren daidaita tsarin tantanin halitta da hannu akan takardar aiki, maimakon ciyar da ƴan mintuna na lokacinsu mai daraja tweaking na al'ada. za a iya amfani da kawai biyu na linzamin kwamfuta dannawa.
Kun saba da wannan saƙon kuskure:Tsarin tantanin halitta daban-daban da yawa.“? Idan eh, to tabbas za ku ga yana da amfani don amfani da salo a cikin Microsoft Excel.
Salon Excel da aka yi amfani da su da wayo zai cece ku lokaci a cikin dogon lokaci! Ba a ma maganar gagarumin taimako a cikin tsara sel, da uniform bayyanar da tebur da kuma saukin fahimtar su. Duk da haka, har ma a cikin ƙwararrun masu amfani da Excel, kayan aikin har yanzu ba a san su ba.
Ba a yi nufin wannan labarin don amsa tambayar me yasa ba ma amfani da salo a cikin Microsoft Excel. A zahiri, da kuma tattaunawa game da ƙarfafa littattafan aikin Microsoft Excel ta hanyar haɗa salo tare da kayan aikin tabbatar da bayanai.
A cikin wannan labarin, za mu dubi aiki tare da salo, inda zan ba ku umarni mataki-mataki yadda ake aiki da wannan kayan aiki, sa'an nan kuma, a kashi na biyu na darasin, za mu yi nazarin dabaru da saitunan daban-daban. . Zan nuna muku yadda ake sarrafa salo, raba wasu ra'ayoyi don amfani da salon Microsoft Excel a cikin aikinku na yau da kullun, kuma koyaushe za ku sami wasu shawarwari masu amfani da ƙarfi a cikin labarina.
A ƙarshe, ya kamata a ambata cewa, kamar yadda yake tare da kayan aikin Microsoft da yawa, salon suna cikin duk aikace-aikacen Microsoft Office suite. Anan za mu mai da hankali kan salo a cikin Microsoft Excel, amma abubuwan yau da kullun da dabarun da aka kwatanta za su shafi kowane aikace-aikacen Microsoft Office.
Don haka menene salo a cikin Microsoft Excel?
Styles a cikin Microsoft Excel kayan aiki ne da aka isa a ƙarƙashin shafin Gida (Gida). Yana ba ku damar aiwatar da zaɓuɓɓukan tsarawa da aka riga aka tsara zuwa tantanin halitta ko rukuni na sel tare da dannawa biyu kawai.
Akwai tarin sifofi da aka riga aka tsara kuma an shirya don amfani. Kuna iya samun damar su ta hanyar danna gunkin kawai. styles (Styles) kamar yadda aka nuna a hoton da ke sama.
Za a gabatar muku da zaɓuɓɓuka da yawa (duba hoton da ke ƙasa). Hasali ma amfaninsu abin tambaya ne. Amma kada ku damu, yana yiwuwa a daidaita salon da aka saita don dacewa da bukatun ku, ko kuma, ma fi ban sha'awa, ƙirƙirar salon ku na iri ɗaya! Za mu dakata a kan wannan dalla-dalla a kashi na biyu na labarin.
Aiwatar da salo a cikin Excel yana ba ku kwarin gwiwa cewa tsarawa gaba ɗaya yana ƙarƙashin ikon ku. Yin amfani da salo yana ceton ku lokacin da kuke kashewa akan tsara sel tebur da hannu kuma yana ba ku ƙarin zurfin gogewa, musamman lokacin da kuke haɗin gwiwa (zamu ƙara magana game da ƙwarewar mai amfani kaɗan daga baya).
Me kuke buƙatar sani don amfani da salo a cikin Microsoft Excel?
Za ku yi farin cikin jin cewa babu cikakkun abubuwan da ake buƙata don amfani da salo a cikin Microsoft Excel.
Tabbas, yana da amfani ku saba da maganganun tsarawa da abubuwan salo na daidaikun mutane, musamman idan kuna shirin ƙirƙirar salon ku, amma wannan ba buƙatu bane. A zahiri, wannan kayan aikin yana da sauƙin aiki tare, har ma ga waɗanda suka fara Excel a karon farko!
Zaɓuɓɓukan tsara salon da ake da su sun ƙunshi halayen tantanin halitta guda shida, waɗanda suka dace da shafuka shida a cikin akwatin maganganu. Tsarin Sel (tsarin salula).
Za mu iya amfani da kowane adadin abubuwan da aka tsara don kowane sifa, abu mafi mahimmanci shine daidaitawa cikin iyakokin da Microsoft Excel ya tsara, wanda shine kusan nau'ikan tantanin halitta 4000 a cikin littafin aiki ɗaya (don guje wa saƙon kuskuren Excel da aka ambata).
Bayanan Fassara: Don Excel 2003 da baya (.xls tsawo), matsakaicin adadin tsarin da za a iya ajiyewa a cikin fayil shine haɗuwa na musamman 4000. A cikin Excel 2007 da kuma daga baya (extension .xlsx), wannan lambar ta ƙaru zuwa nau'ikan 64000.
Yana da mahimmanci a tuna cewa, kamar macro, kowane sabon salon tsarawa na Microsoft ƙayyadaddun littafi ne. Wannan yana nufin cewa an ajiye su a cikin wani littafin aiki na musamman kuma za su kasance a cikin wancan littafin aikin har sai kun shigo da salon cikin wani littafin aiki. Za mu ga yadda ake yin hakan a kashi na biyu na labarin.
Yaya ake amfani da salon saiti?
Don amfani da salon da aka riga aka tsara zuwa Kwayoyin Excel:
- Zaɓi sel waɗanda ya kamata a yi amfani da salon.
- Bude akan Ribbon Microsoft Excel: Gida (Gida) > styles (Style) > Salon salula (Salon salula)
Nasiha mai taimako! Lura cewa lokacin zabar salo, samfoti na mu'amala yana aiki - wannan yana nufin cewa lokacin da kuke shawagi akan zaɓuɓɓukan salo daban-daban, sel da aka zaɓa suna canzawa. Kyakkyawan ra'ayi, Microsoft!
- Zaɓi kowane salo don sel ta danna shi tare da linzamin kwamfuta.
Shi ke nan! Duk sel da aka zaɓa za a tsara su bisa ga salon da aka zaɓa!
Nasiha mai taimako! Da zarar kun ayyana salon sel, canza kowane nau'in tsarawa a lokaci guda zai zama aikin kwata na minti ɗaya a gare ku, rage zuwa canza sigogin salon, maimakon yiwuwar sa'o'i da kuka yi ta maimaitawa da canza tsarin da hannu. a cikin tebur!
Ga duk mai sha'awar ƙarin koyo game da zaɓuɓɓukan salo na ci-gaba a cikin Microsoft Excel, duba kashi na biyu na labarina.