Uzisebenzisa Kanjani Izitayela kuMicrosoft Excel - Ingxenye 2

Engxenyeni yesibili ye-athikili, uzofunda amasu athuthuke kakhulu okusebenza ngezitayela ku-Microsoft Excel.

Kule ngxenye, uzobona ukuthi ungazishintsha kanjani izitayela ze-Excel ezizenzakalelayo futhi wabelane ngazo phakathi kwezincwadi zokusebenza. Lapha uzothola eminye imibono engakusiza ukuthi uthole okuningi ngokusebenzisa izitayela ku-Microsoft Excel.

Ungasishintsha kanjani isitayela esethiwe?

Ungashintsha noma yisiphi isitayela esethiwe, nokho, ngeke ukwazi ukushintsha igama laso!

Ukushintsha i-elementi yesinye sezibaluli zesitayela:

1. Ku-Excel Ribbon yiya ku: Ikhaya (Ekhaya) > izitayela (Isitayela) > Izitayela zamaseli (izitayela zamaseli).
2. Chofoza kwesokudla isitayela ofuna ukusishintsha bese uchofoza Shintsha (Shintsha).
3. Susa ukumaka amabhokisi aseduze kwezibaluli ezinikwe amandla, noma chofoza inkinobho Usayizi (Fometha) bese ushintsha izimfanelo ezisebhokisini lengxoxo lokufometha kweseli.
4. Khetha ukufometha okufunayo bese uchofoza OK.
5. Cindezela OK ebhokisini lengxoxo isitayela (Isitayela) ukuze uqedele ukuhlela.

Ungazakha kanjani isitayela sakho esisha?

Ngokwami, ngincamela ukudala izitayela ezintsha kunokushintsha izitayela ezizenzakalelayo zeMicrosoft, ngesizathu esilula sokuthi unganikeza isitayela esidaliwe igama elinengqondo. Kodwa lokhu kuyindaba yokuzikhethela komuntu siqu!

Kunezindlela ezimbili zokudala isitayela esisha:

Indlela 1: Kopisha isitayela kuseli

Ukuze ukopishe ukufometha kweseli ngesitayela esisha:

1. Fometha iseli ngendlela ofuna isitayela esisha sibukeke ngayo.
2. Cindezela Ikhaya (Ekhaya) > izitayela (Isitayela) > Izitayela zamaseli (Izitayela Zeseli) ku-Microsoft Excel Ribbon.
3. Khetha into Isitayela Seseli Esisha (Dala Isitayela Seseli), ibhokisi lengxoxo lokufometha lizovela. Qaphela ukuthi izinto zokufometha kuleli windi zigcwele izilungiselelo ezilungiselelwe esinyathelweni 1.
4. Nikeza isitayela igama elifanele.
5. Cindezela OK. Sicela uqaphele ukuthi manje isitayela sakho esisha siyatholakala efasiteleni lokukhetha isitayela ngaphansi Custom (Ngokwezifiso).

Indlela yesi-2: Dala Isitayela Esisha Ebhokisini Lengxoxo yokufometha

Kungenjalo, ungakha isitayela esisha engxoxweni yokufometha. Kwalokhu:

1. Cindezela Ikhaya (Ekhaya) > izitayela (Isitayela) > Izitayela zamaseli (Izitayela Zeseli) ku-Microsoft Excel Ribbon
2. Khetha into Isitayela Seseli Esisha (Dala Isitayela Seseli) ukuze uvule ibhokisi lengxoxo yokufometha.
3. Chofoza inkinobho Usayizi (Fometha) ukuze uvule ibhokisi lengxoxo lezilungiselelo zefomethi yeseli.
4. Cacisa izinketho zokufometha kweseli oyifunayo bese uchofoza OK.
5. Cindezela OK efasiteleni isitayela (Isitayela) ukuze udale isitayela esisha.

Zombili lezi zindlela zizokwakha isitayela sangokwezifiso encwadini yakho yokusebenza.

Izeluleko eziwusizo: Ungaphinde uchithe isikhathi ngokuzenzela ukufometha kweseli, sebenzisa izitayela emsebenzini, lawula izilungiselelo zokufometha ngokushesha nangempumelelo kakhudlwana ngemenyu yezilungiselelo zesitayela.

Ungalokothi udale isitayela esifanayo kabili! Nakuba isitayela silondolozwa kuphela encwadini yokusebenzela lapho sakhiwe khona, kusengenzeka ukuthekelisa (ukuhlanganisa) izitayela ebhukwini lokusebenza elisha usebenzisa umsebenzi wokuhlanganisa.

Ungahlanganisa kanjani izitayela zezincwadi zokusebenza ezimbili?

Ukuhambisa izitayela phakathi kwezincwadi zokusebenza:

1. Vula ibhuku lokusebenza eliqukethe isitayela osifunayo kanye nebhuku lokusebenza okuzothunyelwa kulo isitayela.
2. Encwadini lapho ufuna ukunamathisela khona isitayela, chofoza Ikhaya (Ekhaya) > izitayela (Isitayela) > Izitayela zamaseli (Izitayela Zeseli) ku-Microsoft Excel Ribbon
3. Khetha into Hlanganisa Izitayela (Hlanganisa Izitayela) ukuze uvule ibhokisi lengxoxo njengoba kukhonjisiwe ngezansi.
4. Khetha incwadi equkethe isitayela osifunayo (kwami ​​yincwadi izitayela isifanekiso.xlsx, okuwukuphela kwencwadi yokusebenzela evuliwe ngaphandle kwaleyo esebenzayo).
5. Cindezela OK. Qaphela ukuthi izitayela zangokwezifiso zihlanganisiwe futhi manje seziyatholakala ukuthi zisetshenziswe encwadini yomsebenzi oyifunayo.

Izeluleko eziwusizo: Ungagcina izitayela zamaseli ozithandayo ebhukwini lokusebenza elihlukile ukuze wenze kube lula ukuhlanganisa nezincwadi zokusebenza, kunokuba ucinge ngokungapheli amafayela asabalele kumafolda amaningi kudrayivu yekhompyutha yakho.

Indlela yokususa isitayela sangokwezifiso?

Ukususa isitayela kulula njengokusidala. Ukuze ususe isitayela sangokwezifiso:

1. Run: Ikhaya (Ekhaya) > izitayela (Isitayela) > Izitayela zamaseli (Izitayela Zeseli) ku-Microsoft Excel Ribbon.
2. Chofoza kwesokudla isitayela ofuna ukusisusa.
3. Khetha umyalo kumenyu Susa (Susa).

Konke kuyisisekelo! Akekho ozophika ubulula baleli thuluzi!

Ngokusobala, umuntu ngamunye uzonquma ngezindlela ithuluzi elinikeziwe elingasetshenziswa ngazo ukuthuthukisa ukusebenza kahle. Ukuze ngikunikeze okucabangayo, ngizokunikeza eminye yemibono yami yokusebenzisa izitayela ku-Microsoft Excel.

Ungazisebenzisa Kanjani Izitayela kuMicrosoft Excel

• Ukudala ukuvumelana okuphelele kumadokhumenti akho noma imibhalo yeqembu / inkampani yakho.
• Ukwehliswa okukhulu komzamo ngenkathi isekela ukufometha kweseli esikhathini esizayo.
• Ikhono lokwabelana ngesitayela sangokwezifiso nomuntu ongakwazi ukuzidalela esakhe isitayela ngenxa yezinkinga zobuchwepheshe noma zesikhathi.
• Ukusetha isitayela esiqukethe ifomethi yenombolo yangokwezifiso oyisebenzisa njalo. Ngijabulile ekugcineni sengilungise ukufometha ngokwezifiso: # ##0;[Bomvu]-# ##0njengesitayela.
• Ukwengeza izinkomba ezibukwayo ezikhombisa umsebenzi nenjongo yeseli. Amaseli okokufaka - ngesitayela esisodwa, amaseli anamafomula - kwesinye, amaseli okukhiphayo - ngesitayela sesithathu, izixhumanisi - kwesine.

Ingabe unqume ukusebenzisa izitayela ku-Microsoft Excel? Ngiyaqiniseka ukuthi leli thuluzi lingakwazi futhi lizothuthukisa ukusebenza kahle kwakho. Kungani ehlala engathandwa kangaka? - lombuzo uyangidida ngempela!!!

Ingabe unayo eminye imibono yokuthi zisetshenziswa kanjani izitayela kumaspredishithi e-Excel? Kungani ucabanga ukuthi sikubukela phansi ukuba wusizo kwaleli thuluzi? Ingabe uthole lesi sihloko siwusizo?

Sicela ushiye imibono yakho ngezansi! Imibono kanye nempendulo wamukelekile!