Tlhaloso ea lihlopha le mela e Excel le Google spreadsheets
Lihlopha le mela ke karolo ea bohlokoa ea lenaneo leha e le lefe la spreadsheet tse kang Excel le Google Spreadsheets. Bakeng sa mananeo a joalo, leqephe le leng le le leng le ngotsoe ka tatellano ea gridi ka:
- litšiea tse mathang ka holimo;
- mela e mathang ka holimo.
Mongolo o mong le o mong oa Excel ea morao-rao o na le:
- Lipalo tse 16 384;
- Mela e 1 048 566.
Ka Google Spreadsheets boholo bo sa lekanyetsoang ba leqephe ke:
- Litšiea tse 26;
- Mela e 100.
Likhola le mela e ka kenngoa ho Google Spreadsheets hafeela palo ea lisele ka 'ngoe ea lipampiri e sa felle 400,000;
Kahoo e ka ba le palo e sa tšoaneng ea lihlopha le mela e kang:
- Litšiea tse 50 le mela e 8 000;
- Mela e 100 le mela e 4 000;
Lihlooho le Lihlooho tsa Row
Ho Excel ka bobeli le Google Spreadsheets,
- mongolo o mong le o mong o khetholloa ka lengolo le hlahang sehloohong se ka sehloohong ho qala ka khoeli ea A le, tabeng ea Excel, ho feta ho ea khoeling ea XFD.
- mola o mong le o mong o khetholloa ka nomoro molaleng oa sehlooho, ho qala ho o mong.
Lihlooho le Lihlooho tsa Row le Likarolo tsa Cell
Pale ea liphapano pakeng tsa mohala le mola ke sele - e 'ngoe le e' ngoe ea mabokose a menyenyane a bonngoeng lethathamong.
Ho kopantsoe hammoho, mangolo a mebala le linomoro tsa lihlooho lihloohong tse peli li etsa hore ho be le litšupiso tsa lisele , tse khethollang libaka tsa sele tsa selefouno.
Litlhaloso tsa lisele - tse kang A1, F56, kapa AC498 - li sebelisoa ka mokhoa o pharaletseng liketsong tsa spreadsheet tse kang litlhahlobo le ha ho thehoa lichate .
Ho totobatsa Liqhobo tsohle le Liholo ho Excel
Ho totobatsa setšoantšo se feletseng sa Excel,
- tobetsa mohlooho oa lihlooho;
- tobetsa konopo ea Ctrl + Spacebar lebokoseng.
Ho totobatsa mola o feletseng Excel,
- tobetsa hlooho ea molaetsa;
- tobetsa konopo ea Shift + Spacebar .
Ho totobatsa Liqhobo tsohle le Melao ho Google Spreadsheets
Bakeng sa lihlopha tse se nang data,
- ho hatella likarolo tsa Spacebar tsa Ctrl + ka nako e 'ngoe e khethile mohala oohle.
Bakeng sa lihlopha tse nang le data,
- ho hatella likarolo tsa Spacebar tsa Ctrl + ka nako e 'ngoe e khethile karolo ea karolo e nang le data;
- ho hatisa likarolo tsa Spacebar tsa Ctrl + ka lekhetlo la bobeli ho khetholla mohala oohle.
Bakeng sa mela e se nang data,
- ho hatella Shift + Spacebar ka nako e 'ngoe ho khetholla mola o mong kaofela.
Bakeng sa mela e nang le data,
- ho hatisa Shift + Spacebar keys ka nako e 'ngoe e khethile karolo ea mola o nang le data;
- ho hatisa Shift + Spacebar key ka lekhetlo la bobeli ho khetholla mola oohle.
Ho tsamaea Litora le Li-Columns
Le hoja u sebelisa pointer ea mouse ho tobetsa lisele kapa ho sebelisa mekoallo ea moqolo, kamehla ke khetho ea ho falla ho potoloha leqephe la lipampiri, bakeng sa maqephe a maholo a maqephe a ka potlakelang ho sebelisa lebokose. Lihlopha tse ling tse sebelisoang hangata li kenyelletsa:
- Phunya motsu -a fihla ho sethaleng sa ho qetela sa mosebetsi
- Motsu oa Ctrl + Up - qhomela molaong oa pele oa leqephe
- Ctrl + Letsoho le letona - qholela holong ea ho qetela ea leqephe la mosebetsi
- Ctrl + Motsu o motšehali - qhomela holong ea pele ea leqephe
Ho eketsa Li-Columns tsa Mela ho Worksheet
Kopano e le 'ngoe ea lihlooho tsa li-keyboard e ka sebelisoa bakeng sa ho eketsa lihlopha tse peli le melapo ho sheetshete:
Ctrl + Shift + "+" (hammoho le pontšo)Ho eketsa e mong ho e-na le e mong:
- khetha khalase eohle ho le letona la sebaka bakeng sa mohala o mocha
- khetha mola o feletseng ka holimo ho sebaka bakeng sa mola o mocha
Tlhokomeliso: Bakeng sa li-keyboards tse nang le Number Pad ho ea ka ho le letona la lebokose le tloaelehileng, sebelisa letšoao + moo ntle le senotlolo sa Shift. Sehlopha sa bohlokoa se fetoha:
Ctrl + "+" (hammoho le pontšo)