Muchidzidzo chekupedzisira, takaziva izvo zvekutanga zvekugadzirisa muExcel, takaongorora mirairo yekutanga uye mhando dzemhando. Chinyorwa ichi chinotarisa pakurongeka kwetsika, kureva kugadzikwa nemushandisi. Pamusoro pezvo, isu tichaongorora sarudzo inobatsira yakadai sekurongedza nesero fomati, kunyanya nemuvara wayo.
Dzimwe nguva unogona kusangana nenyaya yekuti maturusi ekurongedza muExcel haakwanise kuronga data muhurongwa hunodiwa. Sezvineiwo, Excel inokutendera iwe kuti ugadzire rondedzero yemaitiro ako ega odha.
Gadzira rudzi rwetsika muExcel
Mumuenzaniso uri pasi apa, tinoda kuronga data pane pepa rekushanda nehukuru hweT-shirt (column D). Kurongeka kwakajairwa kunoronga hukuru mukutevedzana kwearufabheti, izvo zvisingazove zvakakwana. Ngatigadzirei rondedzero yekusarudza saizi kubva padiki kusvika pakukura.
- Sarudza chero sero muExcel tafura yaunoda kuronga. Mumuenzaniso uyu, tichasarudza sero D2.
- Baya Data, wobva wadzvanya command Kuronga.
- A dialog box richavhura Kuronga. Sarudza iyo column yaunoda kuronga nayo tafura. Muchiitiko ichi, tichasarudza kurongedza nehukuru hweT-shirt. Zvino mumunda hurongwa watinya Custom List.
- A dialog box ichaonekwa Lists… Sarudza NEW LIST muchikamu Lists.
- Pinda saizi yeT-shirt mumunda Nyora zvinhu muhurongwa hunodiwa. Mumuenzaniso wedu, tinoda kurongedza hukuru kubva padiki kusvika pahukuru, saka isu tichapinda tichichinjana: Diki, Pakati, Hombe uye X-Makuru nekudzvanya kiyi. pinda mushure mechimwe nechimwe chinhu.
- Baya wedzerakuchengetedza iyo nyowani yekuronga. Rondedzero yacho ichawedzerwa kuchikamu Lists. Ita shuwa kuti yakasarudzwa uye tinya OK.
- Dialog window Lists ichavhara. Dzvanya OK mubhokisi rekutaura Kuronga kuitira kuti uite kusarura kwetsika.
- Iyo Excel spreadsheet icharongwa muhurongwa hunodiwa, kwatiri isu, nehukuru hweT-shirt kubva padiki kusvika pakukura.
Ronga muExcel necell fomati
Mukuwedzera, iwe unogona kuronga Excel spreadsheet nesero fomati kwete zvirimo. Kuronga uku kunonyanya kubatsira kana ukashandisa coding yemavara mune mamwe maseru. Mumuenzaniso wedu, ticharongedza data neruvara rwesero kuti tione kuti ndeapi maodha ane mubhadharo usina kuunganidzwa.
- Sarudza chero sero muExcel tafura yaunoda kuronga. Mumuenzaniso uyu, tichasarudza sero E2.
- Baya Data, wobva wadzvanya command Kuronga.
- A dialog box richavhura Kuronga. Sarudza iyo column yaunoda kuronga nayo tafura. Zvino mumunda Kuronga tsanangura rudzi rwemhando: Rudzi Rwesero, Ruvara rwefonti, kana Sero Icon. Mumuenzaniso wedu, ticharonga tafura nekoromo Payment nzira (column E) uye ne cell color.
- Mu hurongwa sarudza ruvara rwekuronga. Muchiitiko chedu, tichasarudza ruvara rutsvuku rwakajeka.
- dzvanya OK. Tafura yarongerwa neruvara, ine masero matsvuku akareruka kumusoro. Odha iyi inotibvumira kuona zvakajeka maodha akasarudzika.