Tsanangudzo yeColumns uye Rows mu Excel neGoogle Spreadsheets

Tsanangudzo yemakoroni nemitsetse mu Excel neGoogle spreadsheets

Columns nemitsetse chikamu chinokosha chepurogiramu yepadheseti yakadai seExcel neGoogle Spreadsheets. Kune mapurogiramu akadaro, peji rimwe remabhuku rinowanikwa mukati mejeri yegrid ne:

• columns run run vertically;
• mitsetse inomhanya yakananga.

Purogiramu yega yega mune zvinyorwa zvekare zve Excel ine:

• 16 384 columns;
• 1,048,576 mitsetse.

MuGoogle Spreadsheets kushandiswa kwekushandiswa kwesheti ndeku:

• 26 columns;
• 100 mitsara.

Columns nemitsara inogona kuwedzerwa muGoogle Spreadsheets chero bedzi nhamba yemajeri pamusana pebasa haipfuuri 400,000;

Saka kunogona kuve nenhamba yakasiyana yemirasi nemitsetse, yakadai seyi:

• Makumi mashanu nemiromo 8,000;
• 100 ma column uye 4,000 rows;

Column uye Row Headings

Mune zvose Excel uye Google Spreadsheets,

• chikamu chimwe nechimwe chinoratidzwa netsamba iri mumusoro wepepeti inotanga ne column A uye, pane zvakaitika kuExcel, inopfuurira kusvika ku column XFD.
• mutsara mumwe nomumwe unoratidzwa nenhamba mumutsara we musoro, kutanga pane imwe.

Column uye Row Headings uye Cell References

Nhamba yepakati-kati pakati pendarama nemutsara ndiwo sero - rimwe nerimwe mabhokisi mashoma anoonekwa mune pepa rekushanda.

Zvakatorwa pamwe chete, mavara emakoromoni uye mutsara mumatafura maviri anoita sezvikamu zvinyorwa , izvo zvinosarudza nzvimbo imwe neimwe yesero mune pepa rekushanda.

Nhamba dzezviratidzo - dzakadai seA1, F56, kana AC498 - dzinoshandiswa zvakanyanya mumashandi eparashiriti zvakadai semafomu uye pakuumba marati .

Kuratidza Mamwe Columns uye Rows muExpcel

Kuchengetedza yose yakafuridzirwa mu Excel,

• tora pa column columner;
• shandisa Ctrl + Spacebar keys pane keyboard.

Kuisa mutsara wose muExcel,

• tora pamutsara wemusoro;
• shandisa Shift + Spacebar keys.

Kuratidza Mamwe Columns uye Ropa muGoogle Spreadsheets

Nokuda kwemashoko asina data,

• kuomesa Ctrl + Spacebar keys kamwechete inosarudza iyo yose yakarowuni.

Nehurukuro dzine data,

• kuomesa Ctrl + Spacebar keys pane imwechete yakasarudza chikamu che column yaine data;
• kuomesa Ctrl + Spacebar keys kechipiri inosarudza iyo yose column.

Kwemitsara isina data,

• kuomesa Shift + Spacebar keys kamwe chete inosarudza mutambo wose.

Kwemasara ane data,

• kudzvinyirira Shift + Spacebar keys kamwechete inosarudza chikamu chemutsara ane data;
• kuomesa Shift + Spacebar keys kechipiri inosarudza musara wose.

Kufamba Ropa uye Makorumoni

Kunyange zvazvo uchishandisa iyo mouse pointer kuti uise pane masero kana kuti uwane mipumburu yepumburu, nguva dzose inosarudza yekufamba-famba kune pepa pepaji, pamashizha makuru emafaro anogona kukurumidza kufamba kushandisa keyboard. Zvimwe zvinowanzoshandiswa zvinobatanidzwa zvikuru zvinosanganisira:

• Ctrl + Down arrow -uya kumugumo wokupedzisira webhesi
• Ctrl + Up arrow - svetera kumutsara wekutanga webhesi
• Ctrl + Right arrow - svetera kumugumo wokupedzisira webhesi
• Ctrl + Mutsara weboshwe - svetera kuhorosi yekutanga yepepaiti

Kuwedzera Rows Columns kune Pepa Rokushanda

Izvochete keyboard keyboard inosanganiswa inogona kushandiswa kuwedzera zvinyorwa zviviri uye mitsetse pane pepa rekushanda:

Ctrl + Shift + "+" (pamwe nechiratidzo)

Kuwedzera imwe pane pane imwe:

• Sarudza iyo yose yakakorodzwa kusvika kurudyi yenzvimbo yekomba itsva
• Sarudza mutsara wose pamusoro apa nzvimbo yemutsara mutsva

Cherechedza: Kwemabhobhobho ane Number Pad kusvika kurudyi rwekombiji nguva dzose, shandisa chiratidzo + ipapo kunze kweShift key. Iko inosanganiswa inova:

Ctrl + "+" (pamwe nechiratidzo)