Etsa Lethathamo la Ho theoha ho Excel ho tswa ho Phatlalatso e 'ngoe

Ho hlahisa lethathamo la theoha ho Excel ho u fa ho kenya data ka seleng e itseng ea leqephe ho tsoa lenaneng la lipolelo tse thathamisitsoeng pele.

Melemo ea ho sebelisa lethathamo la theolelo e tlaase e kenyeletsa:

• Ho nolofalletsa ho kena ha data
• Ho thibela liphoso tsa ho kena ha data
• E thibela palo ea libaka bakeng sa ho kenya data

Excel Drop-Down List Lethathamo le Mehato Thuto-taba

• Ho kenya Tutorial Data
• Ho theha Boemo bo Boleloang ka Ditaba
• Ho qala lethathamo le theoha
• Ho sebelisa Lethathamo la Tiiso ea Data
• Ho kenya Mohloli oa Data le ho Finyella Lethathamo la Ho theoha
• Ho fetola Lintho tsa Lintlha
• Mekhoa ea ho sireletsa ho theoha tlaase

Ho kenya Tutorial Data

Mohato oa pele oa ho theha lethathamo la theoha ho Excel ke ho kenya data .

Tlhokomeliso: Litaelo tsa lithupelo ha li kenyeletse mehato ea ho etsa litlhahiso bakeng sa leqephe la mosebetsi.

Sena se ke ke sa kena-kenana le ho tlatsa thupelo. Leqephe la hau la mosebetsi le tla shebahala le fapaneng ho feta mohlala o leqepheng la 1, empa lethathamo la theolelo le tla u fa liphetho tse tšoanang.

Kenya data mona ka tlase ka lisele tse bontšitsoeng maqepheng a le mong le a mabeli a buka ea Excel.

Lithuto tsa Thuto

1. Kenya dipatlisiso tse latelang ka lisele tse nepahetseng ho Sheetara ea 1 ea leqephe la mosebetsi: D1 - Mofuta oa Cookie:
2. Tobetsa Thabiso ea Lethathamo la Sheet 2.
   
3. Kenya data e latelang ka lisele tse nepahetseng ho Sheet 2 ea leqephe la mosebetsi:
   A1 - Gingerbread A2 - Lemon A3 - Oatmeal Raine A4 - Chocolate Chip

Lenane la theolelo le tla theoleloa seleng E1 leqepheng la 1.

Ho theha Lebitso la Lebitso la Lethathamo la Litaba

Sebaka se bitsoang lebitso se u lumella hore u bue leboteng le itseng la lisele tsa buka ea Excel.

Mebala e mengata e sebelisitsoe ho Excel ho akarelletsa ho e sebelisa ka litlhahlobo le ha ho thehoa lichate.

Maemong 'ohle, lebitso le bitsoang lebitso le sebelisitsoe sebakeng sa mefuta e mengata ea lisele tse bonts'ang sebaka sa lintlha lefapheng la lipampiri.

Ha e sebelisoa lethathamong la theoha, lebitso le rehetsoeng le sebelisoa e le mohloli oa lintlha tsa lenane.

Lithuto tsa Thuto

1. Etsa lisele lisele tse A1 - A4 leqepheng la 2.
2. Tobetsa lebokose la lebitso le fumanehang ka holimo ho lintlha tsa A
3. Tšoaea "li-cookie" (ha ho na litlhaku) ho Lebokose la Lebitso
4. Tobetsa konter ENTER ho lebokose
5. Lisele tse A1 ho A4 leqepheng la 2 joale li na le lebitso la "cookies"
6. Boloka mokhoa oa hau oa mosebetsi

Ho bula Lebokose la Dijo la Tiiso ea Data

Litsela tsohle tsa ho netefatsa dintlha tsa Excel, ho kenyelletsa lethathamo la theoha, li behoa ho sebelisa boitsebiso ba boitsebiso ba boitsebiso ba data.

Lebokose la lebokose la boitsebiso la dintlha le ka tlase tabeng ea dibboni .

Lithuto tsa Thuto

1. Tobetsa Lethathamong 1 lebobase ka tlase ea skrine ho ea lethatong la 1
2. Tobetsa ho cell E1 ho etsa hore e be sele e sebetsang - ena ke moo lenane la theoha le tla fumanoa teng
3. Tobetsa Taba ea Data ea menu ea lekareche ka holimo ho leqephe la mosebetsi
4. Tobetsa ho Letšoao la Tlhaloso ea Data ho Ribbon ho bula menu ea theoha
5. Tobetsa ho Tlhaloso ea Tlhaloso ea Data ho menu ho bula lebokose la boitsebiso la Dintlha

Ho sebelisa Lethathamo la Tiiso ea Data

Ntle le ho eketsa lethathamo la theolelo ho leqephe la lipampiri, ho netefatsa dintlha ho Excel ho ka boela ha sebelisoa ho laola kapa ho fokotsa mofuta oa data o ka kenang liseleng tse itseng.

Tse ling tsa mekhoa e sebelisoang haholo:

• Thathamisa
• Matsatsi le / kapa linako
• Linomoro tsohle
• Mongolo
• Litlhahlobo (beha tlas'a khetho ea Mokhoa )

Mohato ona, re tla khetha kgetho ea Lethathamo ha mofuta oa ho netefatsa ha data o sebelisoa bakeng sa sele E1 leqepheng la 1.

Mehato

1. Tobetsa ho Litebelisoa tab ho lebokoseng la lebokose
2. Tobetsa motsu o ka tlaase ho qetellong ea Let line ea ho lumella ho bula menyetla e theoha
3. Tobetsa Lethathamong ho khetha lethathamo la theoha bakeng sa ho netefatsa dintlha ka seleng ea D1 le ho kenya mohloli oa Mohloli lebokoseng la lebokose

Ho kenya mohloli oa Data le ho Finyella Letšoao la ho Hlaseloa

Kaha mohloli oa data oa lethathamo le theohileng le fumaneha leqepheng le fapaneng la marang-rang, lebitso le rehiloeng le le leng pele le tla kenngoa mohloling oa Mohloli lebokoseng la lebokose .

Mehato

1. Tobetsa Mohloli oa Mohloli
2. Tšoaea "= cookies" (ha ho litemana) Mohloling oa Mohloli
3. Tlanya Kantle ho tlatsa lenane le theoha le ho koala lebokose la lebokose le tiisitsoeng la Data
4. Setšoantšo se senyenyane sa motsu se ka tlas'a lehlakore le letona la sele E1
5. Ho tobetsa motsu o tlase o lokela ho bula lenane le theoha le nang le mabitso a mane a cookie a kenngoa liseleng tsa A1 ho ea A4 leqepheng la 2
6. Ho tobetsa ho le leng la mabitso o lokela ho kenya lebitso leo ka seleng ea E1

Ho hlophisa Lintho tsa Lintlha

Ho boloka letoto la theoha ho fihlela joale le liphetoho tsa data, ho ka 'na ha hlokahala hore nako le nako u fetole liqeto tsethathamong.

Kaha re sebelisitse mabitso a mangata e le mohloli oa lintho tsa rona tsa lenane ho e-na le mabitso a lenane la lenane, ho fetola mabitso a cookie lebitsong le boletsoeng ka har'a lisele tse A1 ho ea A4 leqepheng la 2 hang-hang ho fetola mabitso hothathamong le theoha.

Haeba data e kenngoa ka ho toba ka lebokose la lebokose, ho etsa liphetoho lenaneng ho akarelletsa ho khutlela ka lebokoseng la lebokose le ho fetola mohloli oa mohloli.

Mohato ona, re tla fetola Shortbread ho Oatmeal Raisin ka lenane la theoha ka ho fetola boitsebiso ka seleng ea A3 ea lebitso le bitsoang.

Mehato

1. Tobetsa seleng A3 ka leqhepe la 2 (Nako e khutšoanyane) ho etsa hore e be sele e sebetsang
2. Tšoaea Mohla oa Oatmeal ka seleng A3 mme o tobetsa konopo ea Kena lebokoseng
3. Tobetsa motsu o ka tlaase bakeng sa lenane la theoha ka seleng ea E1 ea leqephe 1 ho bula lenane
4. Karolo ea 3 lethathamong le lokela ho bala Oatmeal Raisin ho e-na le Shortbread

Mekhoa ea ho sireletsa ho theoha tlaase

Ho tloha ha dintlha tsa rona li fumaneha lethathamong le fapaneng lethathamong la theoha, dikgetho tse peli tse fumanehang bakeng sa ho sireletsa lethathamo la dintlha ke tsena:

• Pata lipampiri tse nang le data (sheet 2)
• Sireletsa leqephe la mosebetsi le akarelletsang ho thibela lisele tse A1 ho A4 leqepheng la 2

Haeba ts'ireletso e sa amehe, ho pata leqephe la lipampiri le nang le lintlha tsa boitsebiso ke khetho e ntle hobane e nolofalletsa ho ntlafatsa lenane ha ho hlokahala.

Haeba ts'ireletso e ameha ka password e ka eketsoa ha u sireletsa leqephe la mosebetsi ho thibela liphetoho hothathamong.

Ho theha ho theoha holimo Lethathamong le Fapaneng la Mosebetsi

Lenane la theoha le tlaase le u lumella hore u kene dintlha ho Excel spreadsheet ho tloha lenaneong la setlhophiso sa setlhophiso.

Karolo ea 1 e akaretsa mehato ea ho theha lethathamo la theoha le lintlha tse lekaneng le tšoanang le lethathamo le theoha.

Thupelo ena e akaretsa ho theha lethathamo la theolelo leqepheng le fapaneng.

Mohlala: Ho hlahisa lethathamo la theoha le dintlha tse fapaneng

Kenya data e latelang ka lisele tse nepahetseng ho Lethathamo la 1 la leqephe la lipatlisiso:
E1 - The Cookie Shop
D2 - Mofuta oa Cookie:
Tobetsa Thabiso ea Lethathamo la Sheet 2.
Kenya data e latelang ka lisele tse nepahetseng ho Sheet 2 kapa leqephe la lipatlisiso:
A1 - Gingerbread
A2 - Lemon
A3 - Oatmeal Raisin
A4 - Chocolate Chip
Totobolla lisele tse A1 - A4 leqepheng la 2.
Tlanya "di-cookie" (ha ho na litlhaku) ka Lebitso la Lebokose 'me u tobetse konopo ea Kena lebokoseng.
Tobetsa Taba ea Sheetere ea Sheetara ea 1
Tobetsa ho cell E2 - sebaka seo liphetho li tla bonahala ho sona
Tobetsa tabeng ea Data
Tobetsa ho Kgetho ea Tlhahiso ea Data ho tswa ho lekareche ho bula menu
Tobetsa ho Tiiso ea Dintlha ho menu ho hlahisa lebokose la lebokose
Tobetsa ho Litebelisoa tab ho lebokoseng la lebokose
Ho tswa ho Lumella menyu khetha Lintlha
Tlhapa = di-cookie ho Mohloli oa mohloli lebokoseng la lebokose
Tobetsa OK ho koala lebokose la lebokose le ho khutlela mosebetsing
Motsu o tlase o lokela ho hlaha haufi le sele E2
Ha o tobetsa motsu, lethathamo la theoha le lokela ho bula ho bontša mabitso a mane a cookie