Ukusebenzisa isinqamuleli se-Excel ekwengezeni ama-Worksheets

Ubani owazi ukuthi lokhu kwakulula ukwenza?

Njengezinketho eziningi ze-Excel, kunezindlela eziningi zokufaka ishidi elilodwa noma ngaphezulu emsebenzini wokusebenza .

Nazi iziqondiso zezindlela ezintathu ezahlukene:

1. Ukusebenzisa ukhiye wezinqamuleli kwikhibhodi.
2. Ukusebenzisa igundane neshidi leshidi.
3. Ukusebenzisa izinketho ezisendaweni yekhaya le Ribbon .

Faka iWindows Worksheet usebenzisa isinqamuleli sekhibhodi

Kukhona ngempela inhlanganisela yekhibhodi emibili yokufaka ishidi elisha lokusebenzela ku-Excel:

Shift + F11
noma
I-Alt + Shift + F1

Isibonelo, ukufaka ishidi lokusebenzela nge-Shift + F11:

1. Cindezela bese ubamba ukhiye we- Shift kukhibhodi.
2. Cindezela bese ukhulula ukhiye we- F11 - ongekho ngaphezu komugqa wenombolo kukhibhodi.
3. Khipha ukhiye we- Shift .
4. Iphepha lokusebenzela elisha lizofakwa ebhukwini lamanje kuya kwesokudla kuwo wonke ama-worksheets asekhona.
5. Ukwengeza ama-worksheets amaningi aqhubeka nokucindezela bese ukhulula ukhiye we- F11 ngenkathi ubamba ukhiye we- Shift .

Faka ama-Worksheets amaningi Asebenzisa isinqamuleli sekhibhodi

Ukwengeza ama-worksheet amaningi ngesikhathi esisodwa usebenzisa izinqamuleli zekhibhodi ezingenhla, kumele uqale ugcizelele inani lamathebhu okusebenza okukhona ukuze utshele i-Excel ukuthi mangaki amashidi amasha okumelwe afakwe ngaphambi kokusebenzisa ukusinqamulela kwekhibhodi

Qaphela: Amathebhu womsebenzi akhethiwe kumele abe eduze komunye nomunye ukuze le ndlela isebenze.

Ukukhetha amashidi amaningi kungenziwa ngekhi Shift negundane noma ngezinye zalezi izinqamuleli zekhibhodi:

Ctrl + Shift + PgDn - ukhetha amashidi ngakwesokudla.
Ctrl + Shift + PgUp - ukhetha amashidi kwesobunxele.

Isibonelo, ukufaka ama-smartsheets amathathu omusha:

1. Chofoza kuthebhu eyodwa yephepha lokusebenzela encwadini yokusebenzela ukuze uyiqokomise.
2. Cindezela bese ubamba izinkinobho ze- Ctrl + Shift ekhibhodi.
3. Cindezela bese ukhulula ukhiye we- PgDn kabili ukugqamisa amashidi amabili ngakwesokudla - amashidi amathathu kufanele aqokonyiswe manje.
4. Landela imiyalo engenhla ngokufaka ama-worksheets usebenzisa iShift + F11.
5. Ama-papersheets amathathu amasha kufanele afakwe ebhukwini lokusebenzela ngakwesokudla kuwo wonke ama-worksheets asekhona.

Faka ama-Worksheets New Excel usebenzisa i-Mouse ne-Tab Sheets

Ukwengeza ishidi elilodwa lokusebenzela usebenzisa i-mouse, chofoza isithonjana seShesha esisha esiseduze namathebhu wezansi ngaphansi kwesikrini se-Excel, njengoba kuboniswe kusithombe esingenhla.

Ku-Excel 2013, isithonjana seshidi elisha yisisignali esengeziwe njengoba kuboniswa esithombeni sokuqala ngenhla. Ku-Excel ka-2010 no-2007, isithonjana isithombe seshidi kodwa sisekhona eduze kwamathebhu eshidi ngaphansi kwesikrini.

Ishidi elisha lifakwa ngakwesokudla kwe- shee esebenzayo .

Faka Ama-Worksheets amaningi Asebenzisa Amathebhu Amashidi noMouse

Ngenkathi kungenzeka ukufaka ama-worksheet amaningi ngokuchofoza izikhathi eziningi esithonjana seshidi elisha, enye inketho i:

1. Chofoza kwelinye ithebhu ithebhu ukuze ukhethe.
2. Cindezela bese ubamba ukhiye we- Shift kukhibhodi.
3. Chofoza kuzithebhu ezengeziwe eziseduze ukuze uzinqokomise - gcizelela inombolo efanayo yamathebhu wamashidi njengamashidi amasha okungeziwe.
4. Chofoza ngakwesokudla kwamathebhu akhethiwe ukuvula ibhokisi lokufaka le- Insert .
5. Chofoza kusikripthi seWebhu ebhodini lebhokisi lebhokisi.
6. Chofoza OK ukufaka amashidi amasha bese uvala ibhokisi lengxoxo.

Amashashethi amasha azokwengezwa ngakwesokudla kuwo wonke ama-worksheets asekhona.

Faka iWindows Worksheet usebenzisa iRibhoni

Enye indlela yokwengeza ishidi elisha lomsebenzi ukusebenzisa inketho yokungenisa etholakala kuthebhu lasekhaya lebhande:

1. Chofoza kuthebhu yaseKhaya ye-ribbon.
2. Chofoza ku-Isithonjana sokufaka ukuze uvule imenyu yokudonsa yezinketho.
3. Chofoza ku Faka Ishidi ukuze ungeze ishidi elisha ngakwesobunxele beshidi elisebenzayo.

Faka ama-Worksheets amaningi Asebenzisa iRibhoni

1. Landela izinyathelo 1 kuya ku-3 ngenhla ukuze ukhethe inombolo efanayo yamathebhu wamashidi njengamashidi amasha okungeziwe.
2. Chofoza kuthebhu yaseKhaya ye-ribbon.
3. Chofoza ku-Isithonjana sokufaka ukuze uvule imenyu yokudonsa yezinketho.
4. Chofoza ku Faka Ishidi ukuze ungeze ama-worksheets amasha ngakwesobunxele beshidi elisebenzayo.