Ƙayyade ginshiƙai da layuka a cikin Excel da kuma shafukan Google
Taswirai da layuka su ne muhimmin ɓangare na kowane tsarin tsare- tsaren irin su Excel da Google Spreadsheets. Don irin waɗannan shirye-shiryen, kowane ɗigon rubutu an saita shi a cikin wani tsarin grid tare da:
- ginshiƙan gudu a tsaye;
- layuka da ke gudana a sarari.
Kowace ɗawainiya a cikin 'yan kwanan nan na Excel ya ƙunshi:
- 16,384 ginshiƙai;
- 1,048,576 layuka.
A cikin Shafukan Lissafi na Google iyakar girman takardun aiki shine:
- Ginshiƙai 26;
- 100 layuka.
Za'a iya ƙara ginshiƙai da layuka a cikin Shafukan Lissafi na Google idan dai yawan yawan kwayoyin halitta da takaddun aiki ba ya wuce 400,000;
Saboda haka za'a iya samun yawan lambobi masu yawa da layuka, kamar:
- 50 ginshiƙai da 8,000 layuka;
- 100 ginshiƙai da 4,000 layuka;
Rubutun Shafi da Layi
A cikin Excel da Google Spreadsheets,
- Kowane shafi an gano shi ta wata wasika a cikin rubutun shafi wanda ya fara da shafi na A kuma, a cikin yanayin Excel, yana gudana ta hanyar XFD shafi.
- Kowane jere an gano ta da dama a cikin jigo na jere, farawa ɗaya.
Rubutun shafi da kuma jigon Hoto da Siffofin Siffar
Hanya tsakanin tsakanin shafi da jere shi ne tantanin halitta - kowanne daga cikin kananan ƙananan da aka gani a cikin takardun aiki.
Haɗuwa, ginshiƙan haruffa da jere na lambobi a cikin rubutun biyu suna ƙirƙirar nassin tantancewa , wanda ya gano wuraren salula na mutum a cikin takardun aiki.
Siffofin salula - irin su A1, F56, ko AC498 - ana amfani da su a cikin aikace-aikacen layi kamar su dabara da lokacin tsara sigogi .
Gyara dukkanin ginshiƙai da Rukunai a cikin Excel
Don haskaka duk wani shafi a Excel,
- danna kan rubutun shafi;
- danna maɓallin Ctrl + Spacebar a kan keyboard.
Don nuna alama ga dukan jimla a Excel,
- danna kan rubutun jeri;
- danna maɓallin Shift + Spacebar .
Ganyama dukkanin ginshiƙai da Rukunai a cikin Shafukan Google
Don ginshikan da ba su da bayanai,
- danna maɓallin Ctrl + Spacebar da zarar zaba dukan shafi.
Don ginshikan dauke da bayanai,
- danna maɓallin Ctrl + Spacebar sau ɗaya zaɓi ɗayan ɓangaren shafi wanda ya ƙunshi bayanai;
- latsa maɓallan Ctrl + Spacebar a karo na biyu zaba cikin dukan shafi.
Don layuka ba tare da bayanai ba,
- danna maɓallin Shift + Spacebar da zarar zaba dukan jere.
Don layuka dauke da bayanai,
- danna maɓallin Shift + Spacebar da zarar zaɓin sashen ɓangaren da ke dauke da bayanai;
- danna maɓallin Shift + Spacebar a karo na biyu zaɓi dukan jere.
Binciken Rukunai da ginshiƙai
Kodayake amfani da maɓallin linzamin kwamfuta don danna kan kwayoyin ko amfani da sandan gungurawa, koyaushe wani zaɓi don motsawa a kusa da takardun aiki, don manyan ayyuka da yawa zai iya sauri don kewaya ta amfani da keyboard. Wasu haɗin keɓaɓɓun amfani da sun hada da:
- Ctrl + Down arrow -Go zuwa jere na karshe na wani takarda
- Ctrl + Up arrow - yi tsalle zuwa jere na farko na takardun aiki
- Ctrl + Hanya ta dama - Yi tsalle zuwa shafi na ƙarshe na takardun aiki
- Ctrl + arrow na hagu - yi tsalle zuwa shafi na farko na wani takarda
Ƙara ginshiƙai Rukunin zuwa shafi
Ana iya amfani da wannan maɓallin maɓallin keyboard don ƙara dukkan ginshiƙai da layuka zuwa takardar aiki:
Ctrl + Shift + "" (karin alama)Don ƙara ɗaya maimakon ɗayan:
- zaɓi dukan shafi zuwa dama na wurin don sabon shafi
- zaɓi dukan jere a sama da wurin don sabon jere
Lura: Don masu amfani da maɓallin kebul tare da Lambar lambar zuwa dama na keyboard na yau da kullum, yi amfani da alamar + a can ba tare da maɓallin Shift. Maɓallin haɗin kai ya zama:
Ctrl + "+" (karin alama)