Kodi 'Active Cell' ndi 'Active Sheet' mu Excel ndi Kodi Ndingapeze Kuti?
Mu mapulogalamu a spreadsheet monga Excel kapena Google Spreadsheets, selo yogwira ntchito imadziwika ndi malire achikuda kapena ndondomeko yozungulira selo , monga momwe tawonetsera pa chithunzi.
Selo yogwira ntchito imadziwikanso kuti selo yamakono kapena selo yomwe ili ndi cholinga .
Ngakhale kuti maselo angapo afotokozedwa, chimodzi chokha chimakhala choyang'ana, chomwe, mwachisankho, chimasankhidwa kuti chilandire.
Mwachitsanzo, deta inalowetsedwa ndi kambokosi kapena yolemba kuchokera ku bolodi la zojambulajambula imatumizidwa ku selo yomwe imayang'ana.
Mofananamo, pepala logwira ntchito kapena pepala laposachedwapa ndi sheetshe yomwe ili ndi selo yogwira ntchito.
Monga momwe tawonetsera pa chithunzi pamwambapa, dzina lamasamba ku Excel pansi pa chinsalu ndi mtundu wosiyana ndi wolimbitsa kuti chikhale chosavuta kuzindikira.
Monga selo yogwira ntchito, pepala yogwira ntchitoyo imalingaliridwa kuti ili ndi cholinga chochita zochitika zomwe zimakhudza maselo amodzi kapena angapo - monga kupanga maonekedwe - ndipo kusintha kumachitika pa pepala logwira ntchito mwachinsinsi.
Selo yogwira ntchito ndi pepala zingasinthe mosavuta. Pankhani ya selo yogwira ntchito, kudumpha pa selo ina ndi pointer ya mouse kapena kupanikizira makiyi ophikira pa kibodibodi zonse zidzasintha selo yatsopano yogwiritsidwa ntchito.
Kusintha pepala lothandizira lingathe kuchitidwa podutsa pazenera ina yomwe ili ndi pointer ya mouse kapena pogwiritsa ntchito njira yomasulira.
Maselo Ambiri Amasankhidwa - Alibe Mmodzi Ntchito Yokha Yogwira Ntchito
Ngati phokoso la mbewa kapena makina a makina akugwiritsidwa ntchito kuti musonyeze kapena musankhe maselo awiri kapena angapo pafupi ndi tsambali kuti mzere wakuda uzungulira maselo angapo, palinso selo limodzi logwira ntchito - selo ndi mtundu wakuda.
Kawirikawiri, ngati deta imalowa pamene selo limodzi liwonetsedwa, deta imalowa mu selo yogwira ntchito.
Zosiyana ndi izi zikanakhala pamene njira yowonjezera yalowa mu maselo ambiri nthawi imodzi.
Cell Active ndi Box Name
Chiwerengero cha selo cha selo yogwira ntchito chikuwonetsedwanso mu Bokosi la Dzina , lomwe liri pamwamba pa Phunziro A mu pepala lolemba.
Kupatulapo pa izi zimachitika ngati selo yogwira ntchito yapatsidwa dzina - mwina payekha kapena ngati mbali ya maselo osiyanasiyana. Muzochitika izi, dzina lazitali likuwonetsedwa mu Bokosi la Dzina.
Kusintha Cell Yogwira Ntchito mkati mwa Gulu la Maselo Otchuka
Ngati gulu kapena maselo ochuluka asankhidwa selo yogwira ntchito akhoza kusinthidwa popanda kusankhiranso mtunduwo pogwiritsa ntchito mafungulo otsatirawa pa kibokosilo:
- Lowetsani mthunzi: zimayambitsa zowonongeka za selo pansi pa selo limodzi mkati mwasankhidwa;
- Shift + Lowani : imayambitsa selo yogwira ntchito yowonetsa selo imodzi mkati mwasankhidwa;
- Makiyi a Tab: amachititsa selo yogwira ntchito selo imodzi kumanja kumalo osankhidwa;
- Shift + Lowani : imayendetsa selo imodzi yogwiritsira ntchito selo imodzi kumanzere mkati mwasankhidwa;
- Ctrl + . (nthawi): amasunthira selo yogwiritsira ntchito mofulumira mozungulira kumbali yotsatira ya mtundu wosankhidwa.
Kusuntha Cell Yogwira Ntchito ku Gulu Losiyanasiyana la Maselo Osankhidwa
Ngati oposa gulu limodzi kapena magulu osakhala pafupi akuwonetsedwa mu tsamba limodzi, mawonekedwe a maselo amatha kusuntha pakati pa magulu awa a maselo osankhidwa pogwiritsa ntchito makiyi otsatirawa pa kibokosilo:
- Tsamba la Ctrl + Alt + la Mzere Wakutsogolo : limasunthira mbali yosavuta ya selo kumbali yotsatira yosakhala yoyandikana nayo pomwe ili pomwepo
- Ctrl + Alt + Mzere wa Mzere wa Mzere : kumayendetseratu maselo osagwira ntchito kumbali yotsatira yosayandikana nayo kumanzere kwa malo omwe alipo
Kusankha Mapepala Ambiri ndi Tsamba Labwino
Ngakhale kuti n'zotheka kusankha kapena kuikapo pepala limodzi lamasewero panthawi imodzi, dzina lokha lamasewera liri lolimba ndipo kusintha kwakukulu komwe kumachitika pamene mapepala ambiri amasankhidwa sikungakhudze chabe pepala logwira ntchito.
Kusintha Mapepala Ogwira Ntchito ndi Shortcut Keys
Pulogalamu yogwira ntchito ingasinthidwe mwa kuwonekera pa tepi la pepala lina ndi ndondomeko ya mouse.
Kusinthasintha pakati pa mapepala kungathandizenso ndi makina osinthika.
Mu Excel
- Kusunthira ku pepala kumanzere: Ctrl + PgUp (tsamba loyamba pamwamba)
- Kusunthira ku pepala kumanja: Ctrl + PgDn (tsamba loyamba pansi)
Mu Google Spreadsheets
- Kusunthira ku pepala kumanzere: Ctrl + Shift + PgUp (tsamba la pamwamba)
- Kusunthira ku pepala kumanja: Ctrl key + Shift + PgDn (tsamba pansi)