Izindlela ezingu-4 zokwengeza ishidi elisha ku-Microsoft Excel

Kuyaziwa kakhulu ukuthi encwadini eyodwa ye-Excel (ifayela) kukhona ngokuzenzakalelayo amashidi amathathu phakathi kokuthi ungashintsha. Lokhu kwenza kube lula ukudala amadokhumenti amaningana ahlobene efayeleni elilodwa. Kodwa yini okufanele uyenze uma inombolo elandelwe ngaphambilini yamathebhu angeziwe ayanele? Ake sibone ukuthi singeza kanjani into entsha ku-Excel.

Izindlela zokwengeza

Indlela yokushintsha phakathi kwamashidi, uyazi abasebenzisi abaningi. Ukuze wenze lokhu, chofoza kumunye wamagama abo, atholakala ngenhla kwesibalo sesimo engxenyeni engezansi engakwesokunxele kwesikrini.

Kodwa akuwona wonke umuntu owaziyo ukwengeza amashidi. Abanye abasebenzisi abazi ngisho nokuthi kukhona kungenzeka. Ake sibone ukuthi singakwenza kanjani ngezindlela ezihlukahlukene.

Indlela 1: usebenzisa inkinobho

Okukhethwa kukho okuvame ukusetshenziswa kakhulu ukusebenzisa inkinobho ebizwa "Faka iShidi". Lokhu kungenxa yokuthi le nketho iyona enembile kunazo zonke ezitholakalayo. Inkinobho yokwengeza itholakala ngenhla yesikhala sesimo ngakwesobunxele ohlwini lwento kakade kudokhumenti.

  1. Ukwengeza ishidi, mane uchofoze inkinobho engenhla.
  2. Igama leshidi elisha liboniswa ngokushesha esikrinini ngenhla ibha yesimo, futhi umsebenzisi angena kuwo.

Indlela 2: imenyu yokuqukethwe

Kungenzeka ukufaka into entsha usebenzisa imenyu yokuqukethwe.

  1. Sichofoza ngokuqondile kunoma yimaphi amashidi asevele encwadini. Emenyu yomongo evelayo, khetha into "Namathisela ...".
  2. Iwindi elisha livuleka. Kuyo kuzodingeka sikhethe ukuthi yini esifuna ukuyifaka. Khetha into "Ishidi". Sicindezela inkinobho "Kulungile".

Ngemuva kwalokho, ishidi elisha lizofakwa ohlwini lwezinto ezikhona ngenhla ibha yesimo.

Indlela 3: ithuluzi letheyipu

Enye ithuba lokudala ishidi elisha lihilela ukusetshenziswa kwamathuluzi afakwa kwi-tape.

Ukuba ngaphakathi kuthebhu "Ikhaya" chofoza esithombeni ngesimo soxantathu oluvuliwe eduze kwenkinobho Namathiselaokuyinto efakwe kwi-tape ebhodini lamathuluzi "Amaseli". Emenyu evelayo, khetha into "Faka iShidi".

Ngemuva kwezinyathelo, into ifakiwe.

Indlela 4: ama-hotkeys

Futhi, ukwenza lo msebenzi, ungasebenzisa okuthiwa okhiye abashisayo. Vele uthayiphe isinqamuleli sekhibhodi Shift + F11. Ishidi elisha ngeke lifakwe nje kuphela, kodwa futhi lizosebenza. Okusho ukuthi, ngokushesha ngemuva kokungezela umsebenzisi uzoshintshela kuyo ngokuzenzakalelayo.

Isifundo: Amakhadi ashisayo ku-Excel

Njengoba ungabona, kunezinketho ezine ezihluke ngokuphelele ngokufaka ishidi elisha encwadini ye-Excel. Umsebenzisi ngamunye ukhetha indlela ebonakala elula kakhulu kuye, ngoba akekho umehluko osebenza phakathi kwezinketho. Yiqiniso, kuyashesha futhi kulula kakhulu ukusebenzisa izinkinobho ezishisayo kulezi zinhloso, kodwa akuwona wonke umuntu ongagcina inhlanganisela engqondweni, ngakho-ke abasebenzisi abaningi basebenzisa izindlela ezizwakalayo zokuzifaka ngendlela engcono.