Kamoo U ka Bōpa Kateng / Tlosa Letšoao la ho Theoha ho Excel

Lenane la ho theoha fatše kapa menyetla e ka bōptjoa Excel ho fokotsa boitsebiso bo kenyelletsoeng seleng e itseng ho ea pele ho lenane la lipolelo. Melemo ea ho sebelisa lethathamo le theolelang bakeng sa ho netefatsa dintlha le kenyelletsa:

• ho nolofalletsa ho kena ha data;
• ho thibela liphoso tsa ho kena ha data;
• ho fokotsa palo ea libaka tsa ho kenya data.

Libaka le Litso tsa Ditshebeletso

Lintlha tse kenyelletsoang lenane le theoha-tlaase li ka ba teng ho:

1. leqephe le tšoanang le lethathamo.
2. leqepheng le fapaneng la leqephe la buka ea buka ea Excel .
3. ka buka e fapaneng ea Excel.

Mehato ea ho Hlasetsa Lethathamo Lethathamo

Mehato e sebelisetsoang ho hlahisa lethathamo la theolelo e bontšitsoeng seleng ea B3 (mefuta ea li-cookie) setšoantšong se ka holimo ke:

1. Tobetsa seleng ea B3 ho e etsa sele e sebetsang ;
2. Tlanya tabeng ea Data ea Ribbon ;
3. Tobetsa ho Tiisetso ea Data ho bula menyetla e theolelang ea ho netefatsa;
4. Lenaneng, tobetsa ho netefatsa ditshwantsho ho hlahisa lebokose la boitsebiso la ho netefatsa dintlha ;
5. Tobetsa ho Setup tab ho lebokoseng la lebokose la bobeli;
6. Tobetsa lebokose la Lumella ho lebokoseng la marang-rang ho bula menyetla e theoha-boleng ba kamehla ke boleng leha e le bofe;
7. Lenaneng lena, tobetsa Lenane ;
8. Tlanya Mohloling oa Mohloli lebokoseng la dialog;
9. Totobatsa lisele tsa E3 - E10 lefapheng la mosebetsi ho eketsa lintlha tsa lisele tse ngata lenaneng lena;
10. Tobetsa OK ho koala lebokose la lebokose mme u khutlele mosebetsing;
11. Motsu o tlase o lokela ho ba teng haufi le sele B3 e bontšang ho ba teng ha lenane le theoha;
12. Ha o tobetsa motsu, lethathamo le theoha le tla buleha ho bontša mabitso a robeli a li-cookie;

Tlhokomeliso: Motsu o ka tlase o bontšang hore ho na le lethathamo le theoha ho bonahala feela ha sele eo e etsoa sele e sebetsang.

Tlosa Letšoao la Tlosa ho Excel

Hang ha o qetile ka lethathamo le theoha ho ka tlosoa habonolo seleng ea lipampiri ho sebelisa lebokose la lebokose la boitsebiso la data joalokaha ho bontšoa setšoantšong se ka holimo.

Tlhokomeliso : Haeba u tsamaisa lethathamo la theolelo kapa mohloli oa mohloli sebakeng se secha leqepheng le le leng, hangata ha hoa hlokahala ho tlosa le ho hlahisa lethathamo le theoha ha Excel e tla ntlafatsa boitsebiso bo bongata bo sebelisetsoang lethathamong .

Ho tlosa lethathamo le theoha:

1. Tobetsa seleng e nang le lethathamo le theoha ho tlosoa;
2. Tobetsa Taba ea Data ea Ribbon ;
3. Tobetsa letšoao la Tiiso ea Data ho Ribbon ho bula menyetla e theoha;
4. Tobetsa konteraka ea Tlhaloso ea Ditshebeletso ho menu ho bula lebokose la boitsebiso la Litaba tsa Data.
5. Ka lebokoseng la lebokose, tobetsa tabeng ea Lisebelisoa - ha ho hlokahala;
6. Tobetsa konopo e hlakileng e le hore u tlose lenane le theoha-le-moea joalokaha ho bontšoa setšoantšong se ka holimo;
7. Tobetsa OK ho koala lebokose la lebokose le ho khutlela mosebetsing .

Lethathamo le khethiloeng le khethiloeng le lokela ho tlosoa seleng e khethiloeng, empa lintlha leha e le life tse kene ka seleng pele lethathamo le tlosoa li tla lula 'me li tlameha ho tlosoa ka thōko.

Ho Tlosa All Drop Down List ho Worksheet

Ho tlosa lintlha tsohle tse theoha tlase leqepheng le le leng ka nako e le 'ngoe:

1. Etsa mehato e le 'ngoe ho ea ho tse hlano ho ea ka holimo;
2. Hlahloba ho kenya liphetoho tsena lisele tse ling tsohle tse nang le lebokose le leng le le leng tabeng ea Lisebelisoa tsa lebokose la lebokose;
3. Tobetsa konopo e hlakileng ho tlosa lethathamo lohle la ho theoha fatše leqepheng la kajeno la mosebetsi.
4. Tobetsa OK ho koala lebokose la lebokose le ho khutlela mosebetsing.