Umdwebo wefomethi ye-Excel: Ukufometha Ikhophi Phakathi kwama-Cell

01 ka-03

I-Excel ne-Google Spreadsheets Format Painter

Ukufometha Amashidi Emisebenzi Ukusebenzisa Umdwebo Wefomethi

Umdwebi wefomethi efakwe ku- b Ezinye i- Excel ne-Google Spreadsheets ikuvumela ukuba ukhiphe ngokushesha futhi kalula ukufometha kusuka kwelinye iseli noma iqembu lamaseli kuya kwenye indawo yeshidi lokusebenzela.

Kuzo zombili izinhlelo, lesi sici siwusizo ikakhulu lapho sithuthukisa ukufometha kwiphepha lokusebenzela ezindaweni eziqukethe idatha entsha kunokuba uzame ukwenza kabusha ukufometha okutholakala kumininingwane ekhona,

Ku-Excel, ukukhethwa kokufometha kokufometha kufaka ukukopisha ukufometha komthombo oyedwa noma izikhathi eziningi endaweni eyodwa noma ngaphezulu ezitholakala:

• Ekhasini lokusebenzela elifanayo
• Emakhasini asebenzayo ahlukene encwadini efanayo
• Ezincwadini zokusebenzela ezahlukene

02 ka-03

Ukukopisha Okuphindwe Ngomdwebo Wefomethi

Ukufometha kwe-Copy kwamanye amaseli we-Worksheet ku-Excel

Izinyathelo ezilandelayo zisetshenziselwa ukusebenzisa izinketho ezihlukahlukene zokufometha emininingwaneni kukholomu B esithombeni ngenhla kwedatha kumakholomu C no D.

1. Engeza zonke izinketho zokufometha ofuna ukuzisebenzisa kumakhalekhukhwini (s) omthombo.
2. Qinisekisa amaseli B4 kuya ku-B8 nge-pointer yegundane.
3. Chofoza kuthebhu yaseKhaya ye- ribbon .
4. Chofoza kusithonjana somdwebo wesithombe (umshini wokupenda) ohlangothini lwesobunxele we-ribbon-lapho isininisi segundane sibheke ngaphezu kwephepha lokusebenzela, ibrashi lokudweba iboniswa ngesikhombisi ukukhombisa ukuthi umdwebo womdwebo usebenziwe.
5. Gqamisa amaseli C4 kuya ku-D8.
6. Izinketho zokufometha zizokopishwa endaweni entsha futhi umdwebo womdwebo uvaliwe.

Ukuchofoza kabili i-Format Painter yokukopisha okuningi

Njengoba kushiwo ngenhla, ukhetho olwengeziwe olutholakalayo ku-Excel kuphela ukuchofoza kabili kwisithonjana somdwebo wesithombe nomdwebo wegundane.

Ukwenza kanjalo kugcina isici somdwebo wesakhiwo sishintshiwe ngisho nangemva kokuchofoza kumaseli owodwa noma ngaphezulu okuya khona.

Ukusebenzisa le nketho kwenza kube lula ukukopisha ukufometha kumaseli amaningi angasondelene (s) atholakale kumakhasi afanayo noma ahlukene noma izincwadi zokusebenza.

Ukuze ukopishe ukufometha kumaqembu angasondelene namaseli ku-Google Spreadsheets, kubalulekile ukuphinda izinyathelo ezingenhla ukuze ukopishe ukufometha endaweni yesibili yomsebenzi.

Ukuvala Umdwebo Wefomethi ku-Excel

Izindlela ezimbili zokuvala umdwebi wefomethi uma kumodi yekhophi eminingi ku-Excel yilokhu:

1. Cindezela ikhi ESC ekhibhodi.
2. Chofoza kanye ngesithonjana somdwebi wefomethi ekhabetheni laseKhaya lebhebhoni.

Isinqamuleli sekhibhodi se-Excel's Format Painter

I-simple simple, izinqamuleli ezimbili ezibalulekile azikho umdwebi wefomethi ye-Excel.

Noma kunjalo, izinhlanganisela ezilandelayo zamakhi zingasetshenziswa ukulingisa umdwebi wefomethi. Lezi zihluthulelo zisebenzisa okukhethwa kukho amafomethi okunamathisela ebhokisini lebhokisi lokubamba elikhethekile .

1. Cindezela i- Ctrl + C - ukuze ukopishe okuqukethwe kwamasethini omthombo wamagama (s) kanye nokufometha okusetshenzisiwe-i-cell (s) yomthombo izozungezwa izintuthwane ezihambayo.
2. Qinisekisa iseli eliya khona noma amaseli aseduze.
3. Cindezela i- Ctr + Alt + V - ukuze uvule ibhokisi lokungena elikhethekile lokunamathisela.
4. Cindezela u-T + Faka ukuze unamathisele ukufometha okusetshenzisiwe kumaseli okuphela.

Njengoba izintuthwane ezihambayo kufanele zisasebenza ngokuzungezile kumakhalekhukhwini (s), ukufometha kweseli kungadlulelwa izikhathi eziningi ngokuphinda izinyathelo ezimbili kuya ku-4 ngenhla.

Dala i-Macro

Uma usebenzisa umdwebi wesakhiwo njalo, indlela elula yokuyisebenzisa usebenzisa ikhibhodi kungaba ukudala i-macro ngokusebenzisa izinhlu zemikhakha engenhla bese unikeza inhlanganisela yokhiye wezinqamuleli ezingasetshenziswa ukuvuselela i-macro.

03 ka 03

I-Google Spreadsheets Paint Ifomethi

Kopisha Ukufometha Kwamanye Amaseli Ayisisodwa Ema-Google Amaspredishithi

Ukukhethwa kwefomethi yepayipi ye-Google Spreadsheet, njengoba kubizwa, ayikwazi kahle njengokwakhe okufanayo kwe-Excel, njengoba kunqunyelwe ukukopisha ukufometha komthombo endaweni eyodwa kuphela ngesikhathi:

• Endaweni yephepha lokusebenzela elifanayo
• Emafebhalini ahlukene efayela elifanayo

Isici se-Google Spreadsheets 'asikwazi ukukopisha ukufometha phakathi kwamafayela.

Izinyathelo ezisetshenziselwa ukukopisha izici zokufometha kusuka kumaseli B4: B8 kumaseli C4: D8 aboniswe esithombeni ngenhla yi:

1. Engeza zonke izinketho zokufometha kumaseli omthombo.
2. Qinisekisa amaseli B4 kuya ku-B8 nge-pointer yegundane.
3. Chofoza isithonjana sefomethi yokupenda (i-roller yokupenda) kwibha yamathuluzi.
4. Qinisekisa amaseli okufika C4 kuya ku-D8.
5. Izinketho zokufometha ezisuka kumaseli ekholomu B zizokopishwa kumaseli kukholomu C no-D futhi isici sefomethi yokupenda sivaliwe.

Ukukopisha Okuningi ngefomethi yePaint

Njengoba kushiwo ngenhla, ifomethi yokupenda inqunyelwe ukukopisha ukufometha endaweni eyodwa kuphela ngesikhathi

Ukuze ukopishe ukufometha kumaqembu angasondelene namaseli ku-Google Spreadsheets, kubalulekile ukuphinda izinyathelo ezingenhla ukuze ukopishe ukufometha endaweni yesibili yomsebenzi.