Indlela yokudibanisa iiseli kwi-Excel kunye ne-Google Spreadsheets

01 ngo 01

Hlanganisa iiseli kwi-Excel kunye ne-Google Spreadsheets

Ukudibana kunye neesekethe zeDatha kwi-Excel kunye ne-Google Spreadsheets. © Ted French

Kwi-Excel kunye ne-Google Spreadsheets, iseli edibeneyo yiseli enye eyenziwe ngokudibanisa okanye ukudibanisa iiseli ezimbini okanye ngaphezulu kunye.

Zombini iinkqubo zinokukhetha:

Ukongeza, i-Excel inokhetho lokudibanisa nedatha yedatha ebonakalayo ifomathi xa usebenzisa izihloko okanye izihloko.

Ukudibanisa kunye neziko kwenza kube lula ukubeka izihloko kwiikholeji ezininzi zephepha lokusebenzela.

Hlanganisa elinye iSeli leDatha kuphela

Hlanganisa iiseli kwii-Excel kunye ne-Google Spreadsheets inomda omnye - azinako ukudibanisa idatha kwiiseli ezininzi.

Ukuba iiseli ezininzi zeedatha ziyahlanganiswa, kuphela idatha kwi-cell ephezulu yesele egcinwe kuyo yonke indawo - yonke enye idatha iya kulahleka xa kuhlanganiswa.

Iselferensi yeseli yesisele edibeneyo yiseli kwinqona elingasentla elingasese lebala lokuqala elikhethiweyo okanye iqela leeseli.

Kuphi ukufumana ukudibanisa

Ku-Excel, ukhetho lokudibanisa lufumaneka kwiTebhu yaseKhaya yerbhoni. Ikhonkco yefayile inelungelo lokudibanisa kunye neCandelo, kodwa ngokuchofoza kwisicatshulwa esingaphantsi kwegama njengoko kuboniswe kumfanekiso ongentla, imenyu ehlayo yonke into yokudibanisa ivula.

Kwi-Google Spreadsheets, ukudibanisa iiseli zeenketho kufumaneka kwimenyu yefomathi . Uphawu lusebenza kuphela xa kusetyenziswa iiseli ezininzi ezikufutshane.

Kwi-Excel, ukuba idibanisa kunye neCentral isebenze xa kusetyenziswa enye iseli enye, umphumo kuphela ukuguqula ukulungelelaniswa kwesisele kwiziko.

Indlela yokudibanisa iiseli

Kwi Excel,

  1. Khetha iiseli ezininzi ukudibanisa;
  2. Cofa kwi-Ikhonkco lokudibanisa neZiko kwiTable yasekhaya yerbhoni ukudibanisa iiseli kunye nedatha yedatha kuloluhlu olukhethiweyo;
  3. Ukusebenzisa enye yezinye izixhobo zokudibanisa, nqakraza kwelohlise phantsi kwe-icon ye-Merge & Centre kwaye ukhethe kwizinto ezikhoyo:
    • Hlanganisa & Iziko;
    • Hlanganisa yonke into (idibanisa iiseli ngokuzenzekelayo - kwiikholam);
    • Hlanganisa iiseli (idibanisa iiseli ngokuzenzekelayo, ngokuzenzekelayo, okanye zombini);
    • Ukwandisa iiseli.

Kwi Google Spreadsheets:

  1. Khetha iiseli ezininzi ukudibanisa;
  2. Cofa kwiFomathi> Hlanganisa iiseli kwimenyu ukuvula imenyu yemeko yokukhetha okudibeneyo;
  3. Khetha ezikhetho ezikhoyo:
    • Hlanganisa konke (hlanganisa iiseli ngokuzenzekelayo, ngokuzenzekelayo, okanye zombini);
    • Hlanganisa nendawo;
    • Hlanganisa ngokuzenzekelayo;
    • Ukumisa.

I-Excel Ukudibanisa kunye neCandelo elongezelelweyo

Enye inketho yokwenza i-centered data kwiikholamu ezininzi kukusebenzisa iCentral Across Selection kwibhokisi yebhokisi yencoko yefayile .

Inzuzo yokusebenzisa le mpawu kunokuba idibene kunye neZiko kukuba ayihlanganisi iiseli ezikhethiweyo.

Ukongeza, ukuba ngaphezulu kweeseli enye iqulethe idatha xa isalathiso sisetyenzisiweyo, idatha kwiiseli zijoliswe ngokubanzi ngokufana nokutshintsha ukulungelelaniswa kweseli.

Njengoko kudibanisa neZiko, izihloko eziphambili kwiikholamu ezininzi zenza kube lula ukubona ukuba isihloko sisebenza kulo lonke uluhlu.

Ukusekwa kwisihloko okanye isihloko sobume kwiikholamu ezininzi, yenza oku kulandelayo:

  1. Khetha iiseli ezahlukeneyo eziqulethe isicatshulwa.
  2. Cofa kwiThebhu yasekhaya yerbhoni;
  3. Kwiqela lokulungelelanisa , cofa iqhosha lokuvula ibhokisi yencoko yokuvula ibhokisi yencoko yebhokisi yefomathi;
  4. Kwibhokisi yencoko, nqakraza kwiTygnment tab;
  5. Ngaphantsi kombhalo olungelelanisiweyo , nqakraza ibhokisi loluhlu ngaphantsi kwe- Horizontal ukubona uluhlu lwezinto ezikhoyo;
  6. Cofa kwiZiko loNyulo ukuya kwiziko elikhethiweyo kulo lonke uluhlu lweeseli;
  7. Cofa OK ukuvala ibhokisi yencoko kwaye ubuyele kwiphepha lokusebenzela.

I-Pre-Excel 2007 Ukudibanisa kunye neNcinci zeZiko

Ngaphambi kwe-Excel 2007, ukusebenzisa i-Merge & Centre kungabangela iingxaki xa wenza utshintsho olulandelayo kwiindawo ezidibeneyo zephepha lokusebenzela .

Ngokomzekelo, kwakungenakwenzeka ukufaka iikholomu ezintsha kwindawo edibanisiweyo yephepha lokusebenzela.

Ngaphambi kokuba ungeze iikholomu ezintsha, amanyathelo okulandela aya kuba:

  1. ukudibanisa iiseli ezidibeneyo eziqulethe isihloko okanye ukuhamba;
  2. yongeza iikholomu ezintsha kwiphepha lokusebenzela;
  3. kuphinda usetyenzise ukudibanisa kunye neziko lokukhetha.

Ukususela kwi-Excel 2007, kunjalo, kunokwenzeka ukuba ungeze iikholomu ezongezelelweyo kwindawo edibeneyo ngendlela efanayo neyezinye iindawo zephepha lokusebenzela ngaphandle kokulandela amanyathelo angentla.