I-Excel Ifomathi yoMdwebi: Ukukopa Ukufometha Phakathi Kweelesi

01 ka 03

I-Excel ne-Google Spreadsheets Ifomathi yoMdwebo

Ukufometha Iifom ezisebenzayo Ukusebenzisa i-Painter yefomathi

Ifomati yenkcazo ibonakala kwi-Excel kunye ne-Google Spreadsheets ikuvumela ukuba ukhuphe ngokukhawuleza kwaye ukope ukufomathiza kwiseli enye okanye iqela leeseli ukuya kwenye indawo kwiphepha lokusebenzela.

Kuzo zombini iinkqubo, umbandela uncedo xa ukwandisa ukufometha kwiphepha lokusebenzela kwiindawo eziqulethe idatha entsha kunokuba uzame ukwenza kwakhona ukufomatha okufumaneka kwi data ekhoyo,

Ku-Excel, ifomathi yokufomathiza ifomathi ifaka ukukopisha ifomathi yomthombo omnye okanye ngaphezulu kwiindawo okanye enye indawo efunyenweyo:

• Kwiphepha elifanayo lomsebenzi
• Kwimiqulu eyahlukileyo yamaphepha encwadini efanayo
• Kwiincwadi ezahlukeneyo zomsebenzi

02 ka 03

Ukukopisha amaninzi nge Painter Format

Ukufometha kweefowuni kwezinye iiselithi zeWindows Worksheet kwi-Excel

Amanyathelo alandelayo asetyenziswe ukusebenzisa iindlela ezahlukeneyo zokufomatha kwienkcukacha kwikholam B kwimfanekiso ongentla apha kwiedatha C kunye noD.

1. Yongeza zonke iindlela zokwenza ifomathi ofuna ukuzisebenzisa kwiiseluni (s).
2. Phakamisa iiseli zeB4 ukuya kwi-B8 kunye ne-mouse pointer.
3. Cofa kwiThebhu yasekhaya yerbhoni .
4. Cofa kwifayile yecalado (ibrashi yepende) kwicala lesobunxele le-ribbon-xa i-pointer ye mouse igxuma ngaphezulu kwiphepha lokusebenzela, ibrashi yepeyinti iboniswa ngesikhombisi ukuze ibonise ukuba ifomati yenziwe ifakwe.
5. Khanyisa iiseli C4 ukuya kwi-D8.
6. Izinketho zokufomathiza ziya kukopishwa kwindawo entsha kwaye ifomathi yendlela ifakwe.

Ukuqhafaza kabini i-Painter yeFomathi yeeKopi ezininzi

Njengoko kuchazwe ngasentla, ukhetho olongezelelweyo olutholakalayo kwi-Excel kuphela ukucofa kabini kwifayile yefayile yomdwebo kunye ne-mouse pointer.

Ukwenza njalo kugcina ifomathi yomfaki-fayile ifakelwe emva kokuchofoza kwelinye okanye iiseli ezingaphezulu.

Ukusebenzisa olu khetho kwenza kube lula ukukopa ukufometha kwiiselula ezininzi ezingekhoyo ezikuloo ndawo zifumaneka kwimiqulu okanye iincwadi zokusebenzela ezifanayo.

Ukukopa ukufomathiwa kumaqela angasondelene namaseli kwi-Google Spreadsheets, kuyimfuneko ukuphinda amanyathelo angentla ukukopisha ifomathi kwindawo yesibini yomsebenzi.

Ukuguqula Umdwebo weFomathi kwi-Excel

Izindlela ezimbini zokucima umdwebo wefriji xa kumodi yekopi ezininzi kwi-Excel yile:

1. Cinezela ikhi yeSc kwikhibhodi.
2. Nqakraza kanye kwifom yefayile yomboniso kwiTable yasekhaya yerbhoni.

Iqhosha leNqakraza yeComputer ye-Excel ifayile yoMdwebo

Indlela elula, iindlela ezinqamlezileyo ezibini azikho kwi-Excel ifayile yomdwebo.

Nangona kunjalo, ukuhlanganiswa kwezihlomelo ezilandelayo kungasetyenziselwa ukulinganisa ifomati yendlela. Ezi zitshixo zisebenzisa ukhetho lwefayile kwifayile ebhaliweyo yencoko yababini .

1. Cinezela Ctrl + C - ukukopisha okubhalwe kwifom (s) yesitrato-fata kunye nokufometha kwesicelo-iiself (s) zaso ziza kujikelezwa ziindlovu zokuhamba.
2. Gqamisa iseli yeendawo okanye iiseli eziseduze.
3. Cinezela i- Ctr + Alt + V - ukuvula ibhokisi yencoko yebhokisi ekhethekileyo .
4. Cinezela T + Faka ukuze unamathele ukufometha okufakwe kwisitishi (s).

Ekubeni iintuthwane ezijikelezayo kufuneka ziqhubeke zisebenza ngokujikeleza kwiseli (s), ukufometha kweeseli kunokudlulelwa ngamaxesha amaninzi ngokuphinda amanyathelo 2 ukuya ku-4 ngaphezulu.

Yenza iMacro

Ukuba usebenzisa umdwebo wefomathi rhoqo, indlela elula ukuyisebenzisa ngokusebenzisa ikhibhodi yayiza kubumba i-macro isebenzisa izibetho ezingundoqo ezingentla kwaye unike idibaniso yeqhosha elifutshane elingasetyenziselwa ukuvula i-macro.

03 ka 03

I-Google Spreadsheets Ifomati yePaint

Khuphela Ukufometha kwiSunithi enye okanye ezininzi ezisezantsi kwiGoogle Spreadsheets

Ukhetho lwefayili lweGoogle Spreadsheets, njengoko libizwa, alukwazi ukukwazi ukulingana ne-Excel, umlingani walo, njengoko kunqunyelwe ukukopisha ukufometha komthombo kwindawo enye kuphela ngexesha:

• Kwimihlaba yephepha elifanayo lomsebenzi
• Kwimiyalezo ehlukeneyo kwifayile efanayo

Isici seGoogle Spreadsheets 'asikwazi ukukopa ukufomatha phakathi kweefayile.

Amanyathelo asetyenziswa ukukopisha ifomathi yefomathi kwiiseli B4: B8 kwiiseli C4: D8 eboniswe kumfanekiso ongentla apha:

1. Yongeza zonke iindlela zokufomatha kwiiseli zentsusa.
2. Phakamisa iiseli zeB4 ukuya kwi-B8 kunye ne-mouse pointer.
3. Cofa kwi icon yohlobo lwepeyinti (i-roller roll) kwibha yesikhali.
4. Gqamisa iiseli ezikuyo C4 ukuya kwi-D8.
5. Izinketho zokufomatha ukusuka kwiiseli kumhlathi B ziza kukopishwa kwiiseli kwiikholomu C no-D kunye nefomati yefomati iyacinywa.

Ukukopisha amaninzi ngeFomathi yoPawulo

Njengoko kuchazwe ngentla, ifomathi yepende yecala ukukopisha ukufometha ukuya kwindawo enye kuphela ngexesha

Ukukopa ukufomathiwa kumaqela angasondelene namaseli kwi-Google Spreadsheets, kuyimfuneko ukuphinda amanyathelo angentla ukukopisha ifomathi kwindawo yesibini yomsebenzi.