Tanthauzo la Ma Columns ndi Mizere mu Excel ndi Google Spreadsheets

Tanthauzo la mizere ndi mizere ku Excel ndi Google spreadsheets

Mizere ndi mizere ndi gawo lalikulu la pulogalamu iliyonse ya spreadsheet monga Excel ndi Google Spreadsheets. Kwa mapulogalamu otere, tsamba lililonse lamasamba likuyikidwa mu grid ndi:

• zipilala zikuyenda;
• mizere yomwe imayenderera pang'onopang'ono.

Tsamba lililonse la Excel laposachedwapa lili ndi:

• Mipingo 16,384;
• Mizere 1,048,576.

Mu Google Spreadsheets kukula kosasintha kwa tsamba ndi:

• Mipingo 26;
• Mizere 100.

Mizere ndi mizere ikhoza kuwonjezeredwa mu Google Spreadsheets malinga ngati chiwerengero cha maselo pa tsamba sichiposa 400,000;

Kotero pakhoza kukhala nambala yosiyanasiyana ya mizere ndi mizere, monga:

• Mizati 50 ndi mizere 8,000;
• Mizere 100 ndi mizere 4,000;

Mizere ndi Mitu ya Mzere

Mu Excel onse ndi Google Spreadsheets,

• Mndandanda uliwonse umadziwika ndi kalata mu mutu wa mutuwu kuyambira pa A A komanso, pa nkhani ya Excel, kudutsa mpaka ku XFD.
• Mzere uliwonse umadziwika ndi nambala mu mutu wa mzere, kuyambira pa umodzi.

Mndandanda ndi Mitu ya Mzere ndi Maumboni a Maselo

Pakati pa ndime ndi mzere ndilo selo - mabokosi ang'onoang'ono omwe amawoneka pa tsamba.

Kuphatikizidwa pamodzi, zilembo za mzere ndi ziwerengero za mzere pamutu iwiri zimapanga mafotokozedwe a selo , omwe amadziwika malo omwe ali m'maselo.

Mafotokozedwe a magulu - monga A1, F56, kapena AC498 - amagwiritsidwa ntchito kwambiri m'mapiritsiti monga mafomu komanso popanga ma chati .

Kuunikira Mizere yonse ndi Mizere mu Excel

Kuwonetsera gawo lonse mu Excel,

• dinani pamutu wamutu;
• pindani makina a Ctrl + Spacebar pa makiyi.

Kuyika mzera wonse ku Excel,

• dinani pamutu wa mzere;
• onetsetsani Shift + Spacebar mafungulo.

Kuunikira Mizere yonse ndi Mizere mu Google Spreadsheets

Kwa zipilala zopanda deta,

• Kukanikiza makina a Spacebar Ctrl kamodzi kamasankha lonse mzere.

Kwa mazamu okhala ndi deta,

• Kukanikiza makina a Spacebar Ctrl kamodzi kamasankha gawo la ndime yomwe ili ndi data;
• kukakamiza makina a Spacebar Ctrl + kachiwiri amasankha lonselo.

Kwa mizera yopanda deta,

• Kukanikiza Shift + Spacebar makina kamodzi kamasankha mzera wonse.

Kwa mizera yomwe ili ndi deta,

• Kukanikiza Shift + Spacebar mafungulo kamodzi kamasankha gawo la mzere uli ndi data;
• Kukanikiza Shift + Spacebar mafungulo kachiwiri amasankha mzera wonse.

Kuyenda Mizere ndi Ma Columns

Ngakhale kugwiritsira ntchito phokoso la mbewa pakhomopo kapena kugwiritsa ntchito mipukutu ya mpukutu, nthawizonse ndi mwayi wosunthira kuzungulira pepala, pa masamba akuluakulu omwe angayambe kuyenda mwamsanga pogwiritsa ntchito makiyi. Zina zomwe zimagwiritsidwa ntchito kwambiri ndizo:

• Mtsinje wa Down + -imani ku mzere wotsiriza wa tsamba
• Mtsinje wa Ctrl + Up - Dumphirani ku mzere woyamba wa tsamba
• Tsinde lamanja la Ctrl - Dumphirani ku gawo lomaliza la tsamba
• Ctrl + Mzere wakumanzere - Dumphirani ku gawo loyamba la tsamba

Kuwonjezera Mazenera Amiyala ku Tsamba Labwino

Mgwirizanowu womwewo ungagwiritsidwe ntchito powonjezera zigawo zonse ndi mizera ku tsamba lokumbukira:

Ctrl + Shift + "+" (kuphatikizapo chizindikiro)

Kuwonjezera chimodzi mmalo mwake:

• sankhani ndime yonse kumanja kwa malo kwa chigawo chatsopano
• sankhani mzere wonse pamwamba pa malo kuti mukhale mzere watsopano

Zindikirani: Pa makibodi okhala ndi Number Pad kumanja kwa khibhodi yamakono, gwiritsani ntchito chizindikiro + kumeneko popanda chinsinsi cha Shift. Mgwirizano wambiri umakhala:

Ctrl + "+" (kuphatikizapo chizindikiro)