Canja Ƙarƙashin Maɓallin Cursor Movement a Excel

By tsoho, Excel ta atomatik motsa sautin mai aiki , ko siginan siginar ƙasa zuwa cell na gaba idan an danna maɓallin Shigar da keɓaɓɓen keyboard. Wannan jagorar tazarar don motsawa aka zaba siginar saboda an shigar da bayanai a cikin ginshiƙan tantanin halitta daya bayan daya don haka siginar yana motsawa lokacin da maɓallin Shigar da ke guga yana taimakawa shigar da bayanai.

Canja Jagorar mai ƙwaƙwalwar

Wannan hali na tsoho za a iya canza domin malamin ya motsa zuwa dama, hagu, ko sama maimakon ƙasa. Haka ma yana iya samun siginan kwamfuta ba motsawa ba, amma ya kasance a kan tantanin halitta a yanzu bayan an shigar da maballin Shigar. Canza jagoran mai siginan kwamfuta an yi ta amfani da Advanced zažužžukan a akwatin Excel Zabuka zane . Samo umarni game da yadda za a yi canje-canje a kasa.

01 na 02

Canja Ƙarƙashin Maɓallin Cursor Movement a Excel

Don canja jagorancin mai siginan kwamfuta yana motsawa:

1. Danna kan fayil na rubutun don bude menu na fayil
2. Danna Zaɓuɓɓuka a cikin menu don buɗe akwatin maganganu na Excel Zabuka
3. Danna Babba a cikin hagu na hannun hagu na akwatin maganganu
4. A karkashin Bayan latsa Shigar, motsa zaɓi a hannun dama, danna kan gefen ƙasa kusa da Jagora don zaɓar jagorancin mai siginan kwamfuta zai matsa lokacin da aka danna maɓallin Shigar.
5. Don samun siginar salula ya kasance a kan tantanin salula, cire alamar duba daga akwatin kusa da Bayan danna Shigar, motsa zaɓi

02 na 02

Amfani da Tab kuma Shigar da Keys lokacin shigar da bayanai

Idan lokaci-lokaci ka shigar da bayanai a fadin layuka maimakon ka sauka a ginshiƙai, zaka iya amfani da maɓallin Tab don matsawa hagu zuwa dama a fadin takardun aiki maimakon canza yanayin ta hanyar amfani da umarnin da aka jera a sama.

Bayan shigar da tantanin halitta na farko:

1. Latsa maɓallin Tab don motsa ɗaya cell zuwa dama a jere guda ɗaya
2. Ci gaba da shigar da bayanai kuma ta amfani da maɓallin Tab don matsawa zuwa cell ta gaba zuwa dama har zuwa ƙarshen jere na bayanan da aka isa
3. Latsa maɓallin shigarwa don komawa shafi na farko don fara jerin jere na gaba