Indlela Yokuqamba kabusha Iphepha Lomsebenzi ku-Excel

01 ngo-02

Qamba kabusha i-Worksheet ku-Excel

Iqamba kabusha futhi ibuyisela kabusha amathebhu okusebenzela

Izinguquko ezimbili ezenza kube lula ukuhlela nokukhomba ama-worksheet nedatha abakuqukethe kufanele baqambe kabusha ishidi lokusebenzela futhi bashintshe umbala wethebhu lokusebenzela eliqukethe igama phansi komsebenzi womsebenzi.

Iqamba kabusha i-Excel Worksheet

Kunezindlela eziningi zokuqamba kabusha ishidi lokusebenzela ku-Excel, kodwa konke kuhilela ukusebenzisa amathebhu wephepha ngaphansi kweskrini se-Excel noma izinketho ezisendaweni yekhaya lebhande .

Inketho 1 - Ukusebenzisa ama-Keys Key Key:

Qaphela : Ikhi le- Alt akudingeki ligcinwe phansi ngenkathi ezinye izinkinobho zicindezelwa, njengezinye izinqamuleli zekhibhodi. Isihluthulelo ngasinye sicindezelwe futhi sikhululwe ngokulandelana.

Lokho kusetjenziswa kwamacrosoft kusenza kusebenze imiyalo ye-ribbon. Uma ukhiye wokugcina ekulandelaneni - i-R - igxiliwe futhi ikhishwe, igama lamanje kuthebhu leshidi lekhasi lamanje noma elisebenzayo ligqanyisiwe .

1. Cindezela bese ukhulula ngokulandelana ngenhlanganisela eyinhloko elandelayo ukugqamisa igama lephepha elisebenzayo;

I-Alt + H + O + R

2. Thayipha igama elisha lephepha lokusebenzela;

3. Cindezela ukhiye wokungena kwikhibhodi ukuqedela kabusha kabusha ishidi lokusebenzela.

Ukushintsha ama-Worksheets Ishothikhathi yekhibhodi

Ukunqamulela kwekhibhodi ehlobene ukushintsha phakathi kwamashidi okusebenzela - ngoba ishidi elisebenzayo yilona elizobizwa kabusha ngokusebenzisa inhlanganisela eyinhloko ngenhla. Sebenzisa izinhlanganisela ezilandelayo eziyisihluthulelo ukuqinisekisa ukuthi iphepha lokusebenzela elifanele libizwa kabusha:

Ctrl + PgDn - thuthela kushidi ngakwesokudla Ctrl + PgUp - thuthela eshadini ngakwesokunxele

Ithebhu Ithebhu Ukuqamba Izinketho

Iphepha lokusebenzela lingaqanjwa kabusha ngokuchofoza kuthebhu leshidi ngezinketho ezimbili ezilandelayo.

Inketho 2 - Chofoza kabili ithebhu yephepha:

1. Chofoza kabili igama lamanje kuthebhu lokusebenzela ukuze ugcizelele igama lamanje kuthebhu;
2. Thayipha igama elisha lephepha lokusebenzela;
3. Cindezela ukhiye wokungena kwikhibhodi ukuqedela kabusha kabusha ishidi lokusebenzela;
4. Igama elisha kufanele libonakale kuthebhu lokusebenzela.

Inketho 3 - Chofoza ngakwesokudla ithebhu yethebhu:

1. Chofoza ngakwesokudla kuthebhu yoshicilelo ofuna ukuyiqamba kabusha ukuvula imenyu yomongo;
2. Chofoza okuthi Qamba kabusha kabusha ohlwini lwamenyu ukugqamisa igama lamanje lokusebenzela;
3. Landela izinyathelo ezimbili kuya ku-4 ngenhla.

Inketho 4 - Finyelela Option Ribbon nge Mouse:

1. Chofoza kuthebhu yephepha lokusebenzela elizobizwa kabusha ukuze lenze ishidi elisebenzayo
2. Chofoza kuthebhu yaseKhaya ye-ribbon
3. Chofoza kwikhompyutheni yefomathi ebhodini ukuvula imenyu ehlayo
4. Esikhathini Sokuhlela Amashidi Amashidi emenyu, chofoza okuthi Qamba kabusha kabusha ishidi ukugqamisa ithebhu leshidi ngaphansi kweskrini
5. Thayipha igama elisha lephepha lokusebenzela
6. Cindezela ukhiye wokungena kwikhibhodi ukuqedela kabusha kabusha ishidi lokusebenzela

Buka Wonke Amathebhu Amashidi Encwadini Yomsebenzi

Uma ibhuku lezincwadi liqukethe inani elikhulu lamashidi okusebenza noma ibha yokuphenya evundlile iye yandiswa ngaphambilini, akuwona wonke amathebhu wepheshana angase abonakale ngesikhathi esisodwa - ikakhulukazi njengoba amagama amashidi efinyelela isikhathi eside, ngakho-ke amathebhu.

Ukulungisa lesi simo,

1. Faka i-pointer yegundane phezu kwe- ellipsis eqondile (amachashazi amathathu aqondile) eduze kwebhayli yokupheqa enezingqimba;
2. I-pointer yegundane izoshintsha kumcibisholo ohlosiwe kabili - njengoba kuboniswe esithombeni esingenhla uma sikhiwe kahle;
3. Cindezela bese ubamba inkinobho yegundane lesokunxele bese uhudula umdwebo ngakwesokudla ukuze ukwandise indawo yamathebhu wephepha ukuze uboniswe - noma ngakwesobunxele ukukhulisa ibha yokuphenya.

I-Excel Worksheet Yezimpawu Zegama

Kunemikhawulo embalwa uma kuziwa ekuqanjeni kabusha ishidi lokusebenzela le-Excel:

• Igama alikwazi ukudlula izinhlamvu ezingu-31 ngobude
• Igama lokushicilela alikwazi ukushiywa lingenalutho
• Izinhlamvu ezilandelayo azikwazi ukusetshenziswa egameni: \ /? : * [

Ukusebenzisa Amagama E-Worksheet emafomula e-Excel

Ukuqamba kabusha ishidi lokusebenzela akukwenzi kube lula ukugcina ithrekhi yamashidi ngamanye emabhukwini amakhulu, kodwa kunenzuzo eyengeziwe yokwenza kube lula ukuqonda amafomula ahlukanisa amashidi amaningi okusebenza.

Lapho ifomula ihlanganisa ireferensi yeseli kusuka kwiphepha lokusebenzela elihlukile igama lephepha lokusebenzela lifakwe kufomula.

Uma amagama asetshenzisiwe okuzenzakalelayo asetshenzisiwe - njengeSheet2 , Sheet3 - ifomula izobukeka into enjengale:

= Ishidi3! C7 + Sheet4! C10

Ukunikeza amafomu okusebenza igama elichazayo - njengezindleko zangoMeyi nezindleko zikaJuni - kungenza ifomula ibe lula ukuyiqonda. Ngokwesibonelo:

= 'Kwangathi Ungadla'! C7 + 'June Imali'! C10

02 ka 02

Ukushintsha Amashidi Amathebhu Wethebhu

Ukuguqulwa kokubukwa kweThebhu yeThabhu yeShidi

Ukukusiza ukuthi uthole ulwazi oluthile kumafayili ama-spreadsheet amakhulu, kuvame ukusiza ikhodi yombala amathebhu ama-worksheet ngamanye aqukethe idatha ehlobene.

Ngokufanayo, ungasebenzisa amathebhu ahlukene ahlukene ukuze uhlukanise phakathi kwamashidi aqukethe ulwazi olungathintana.

Enye indlela ukudala uhlelo lwemibala yamathebhu enikeza izinkomba zokubuka okusheshayo ngokuya esiteji sokuphelela kwamaphrojekthi - njengokuhlaza okuqhubekayo nokubomvu okuphelile.

Ukushintsha Umbala Wethebhu weWebhu Yokusebenzela Elilodwa

Inketho 1 - Ukusebenzisa ama-Keys Key Key:

Qaphela : Njengokuqamba kabusha i-worksheet usebenzisa okhiye abashisayo , ukhiye we- Alt akudingeki ugcinwe phansi ngenkathi ezinye izinkinobho zicindezelwa, njengezinye izinqamuleli zekhibhodi. Isihluthulelo ngasinye sicindezelwe futhi sikhululwe ngokulandelana.

1. Cindezela bese ukhulula ngokulandelana ngenhlanganisela eyinhloko elandelayo ukuze uvule i-palette yombala esekelwe ngaphansi kokukhethwa kwefomathi kuthebhu lasekhaya lebhande:

I-Alt + H + O + T

2. Ngokuzenzakalelayo, isikwele sombala ekhoneni eliphezulu lesokunxele se-palette - esimhlophe esithombeni ngenhla - sikhethiwe. Chofoza nge-pointer yegundane noma sebenzisa okhiye bomcibisholo ekhibhodi ukuze uhambise okugqamile kumbala oyifunayo;

3. Uma usebenzisa imicibisholo yomcibisholo, cindezela ukhiye wokungena kwikhibhodi ukuqedela kabusha kabusha ishidi lokusebenzela;

4. Ukubona imibala engaphezulu, cindezela ikhi le-M ekhibhodi ukuvula iphalethi yombala ongokwezifiso.

Inketho yesibili - Chofoza ngakwesokudla ithebhu yephepha:

1. Chofoza ngakwesokudla kuthebhu yephepha lokusebenzela ofuna ukuphinde umbala ukuze wenze ishidi elisebenzayo futhi uvule imenyu yokuqukethwe;
2. Khetha Umbala weThabhu ohlwini lwamenyu ukuvula iphalethi yombala;
3. Chofoza kumbala ukuze ukhethe;
4. Ukubona imibala engaphezulu, chofoza ku- Colors Eningi ngaphansi kwephalethi yombala ukuvula iphalethi yombala ongokwezifiso.

Indlela 3 - Finyelela Option Ribbon nge Mouse:

1. Chofoza kuthebhu yephepha lokusebenzela elizobizwa kabusha ukuze lenze ishidi elisebenzayo;
2. Chofoza kuthebhu yaseKhaya yebhebhoni;
3. Chofoza ku- Fomathi yokukhetha kwi-ribbon ukuze uvule imenyu ehlayo;
4. Esikhathini sokuhlela Amashidi Amashidi emenyu, chofoza umbala weThabhu ukuvula iphalethi yombala;
5. Chofoza kumbala ukuze ukhethe;
6. Ukubona imibala engaphezulu, chofoza ku- Colors Eningi ngaphansi kwephalethi yombala ukuvula iphalethi yombala ongokwezifiso.

Ukushintsha Umbala weThabhu Wama-Worksheets amaningi

Qaphela: Wonke amathebhu womsebenzi akhethiwe azoba umbala ofanayo.

1. Ukuze ukhethe ithebhu yesikhwama esingaphezulu kweyodwa, gcina ikhi Ctrl ekhibhodi bese uchofoza kuthebhu ngayinye nge-pointer yegundane.
   Chofoza ngakwesokudla kwamathebhu wekhasi elikhethiwe ukuze uvule imenyu yehla.
2. Khetha Umbala weThabhu ohlwini lwamenyu ukuvula i-palette yombala.
3. Ukuze ubone imibala engaphezulu, chofoza ku- Colour More ngaphansi kwephalethi yombala ukuvula i-Custom Color Palette.

Imiphumela

1. Ukushintsha umbala wethebhu wephepha lokusebenzela elilodwa:
   • Igama lephepha lokusebenzela likhonjiswe kumbala okhethiwe.
2. Ukushintsha umbala wethebhu wephepha lokusebenzela elingaphezu kwelilodwa:
   • Ithebhu yokusebenza esebenzayo igcizelelwe kumbala okhethiwe.
   • Wonke amanye amathebhu womsebenzi abonisa umbala okhethiwe.