Zo a cikin Excel: Canza Maɓallin Ɗaukaka Hanya

Zoɓuka Zabuka a cikin Excel: Zangon Zuƙowa da Zuƙowa tare da Keyboard

Hoton zuƙowa a cikin Excel yana canza sikelin aikin aiki akan allon, ba da damar masu amfani don fadada yankunan musamman ta hanyar zuƙowa ko zuƙowa don ganin dukkanin ɗawainiya duk lokaci daya.

Daidaita matakin matakin zuƙowa ba, duk da haka, ya shafi ainihin ainihin wani aikin rubutu don haka alamomi na takardun yanzu suna kasancewa ɗaya, ba tare da matakin zuƙowa da aka zaɓa ba.

Zoom wuri

Kamar yadda aka nuna a cikin hoton da ke sama, a cikin sababbin sutura na Excel (2007 da daga baya), zuƙowa a cikin wani aikin aiki za a iya cika ta amfani da:

  1. zanewar zuƙowa wanda yake a kan tashar matsayi kamar yadda aka nuna a hoton da ke sama;
  2. Zaɓin zuƙowa da aka samo akan shafin Tabbaccen Ribbon ;
  3. da Zoom a kan mirgine tare da zaɓi IntelliMouse;

Zama Zama

Canza ƙarfin ɗaukar takarda ta amfani da zanewar zuƙowa an cika ta hanyar jawo akwatin akwatin zanewa da baya.

Jawabin akwatin zane-zane zuwa haɓakar dama ta hanyar haifar da ƙananan aikin aiki da ake gani kuma ƙara girman abubuwa - irin su sel , jigogi da kuma rubutun shafi, da kuma bayanai - a cikin takardun aiki.

Jawabin akwatin zane-zane zuwa hagu na hagu yana da ƙananan sakamako. Adadin aikin aiki yana ƙaruwa kuma abubuwa a cikin takardun aiki suna karuwa a girman.

Ƙarin madadin yin amfani da akwatin zane-zane shine danna kan Zoom Out da Zoom In maballin dake a ko wane ɓangaren mai zanewa. Maɓallai suna zubo aikin ɗawainiya a ko fita a cikin increments na 10%.

Zoom Option - Duba Tab

A Duba shafin shafin Zoom na rubutun ya ƙunshi sauƙaƙa uku:

Zaɓi zaɓi na Zoom a kan shafin Duba na riqon ya buɗe akwatin maganganun Zoom kamar yadda aka nuna a gefen hagu na hoto. Wannan akwatin maganganun ya ƙunshi zaɓuɓɓukan ƙarfafawa na farko da suka kasance daga 25% zuwa 200%, da zaɓuɓɓuka don girman girman al'adu da zuƙowa don dace da zaɓin yanzu .

Wannan zaɓi na karshe zai ba ka damar haskaka ɗakunan sel sannan ka daidaita matakin zuƙowa don nuna yankin da aka zaɓa a cikin allon.

Zuƙowa tare da Gajerun hanyoyi

Maɓallin maɓallin kebul maɓalli wanda za'a iya amfani dashi don zuƙowa ciki da fita daga wani ɗimbin ayyuka yana amfani da maɓallin ALT. Waɗannan gajerun hanyoyi suna samun damar zuƙowa a kan shafin Duba ta rubutun ta amfani da maɓallan keyboard maimakon nau'i.

Don gajerun hanyoyin da aka jera a ƙasa, latsa kuma saki maɓallan da aka jera a cikin tsari daidai.

Da zarar akwatin zangon Zuƙowa ya buɗe, latsa ɗaya daga maɓallan da ke ƙasa ya biyo da maɓallin Shigar zai canza matakin ɗaukakawa.

Custom Zoom

Amfani da maɓallin kewayawa na sama don kunna Abubuwan Zuƙowa na al'ada yana buƙatar ƙarin keystrokes ban da waɗanda ake buƙatar bude akwatin maganganun Zoom .

Bayan buga : ALT + Q + C, shigar da lambobi - kamar 33 don matakin ƙarfafawa na 33%. Kammala jerin ta latsa maɓallin Shigar .

Zoƙo a kan Roll tare da IntelliMouse

Idan ka sau da yawa daidaita matakin zuƙowa na takardun aiki, zaka iya amfani da Zoom a kan mirgine tare da zaɓi IntelliMouse

Lokacin da aka kunna, wannan zaɓi ya baka damar zuƙowa ko fita ta amfani da tayin a IntelliMouse ko kowane linzamin kwamfuta tare da gungun wutan lantarki maimakon juyawa sama da ƙasa a cikin takarda.

Ana kunna wannan zaɓin ta amfani da akwatin maganganu na Excel Zabuka - kamar yadda aka nuna a gefen dama na hoton.

A cikin sassan Excel (2010 da daga baya):

  1. Danna kan fayil na rubutun don buɗe hanyar menu;
  2. Danna Zaɓuɓɓuka a cikin menu don buɗe akwatin maganganu na Excel Options;
  3. Danna Ci gaba a cikin sashin hagu na akwatin maganganu;
  4. Danna Zoƙo a kan mirgine tare da IntelliMouse a cikin maɓallin dama don kunna wannan zaɓi.

Zuƙowa zuwa Ƙungiyoyin da aka Lissafi

Idan ɗayan aiki ya ƙunshi ɗaya ko fiye da jeri na mai suna , matakan zuƙowa a kasa da 40% za su nuna waɗannan jeri sunaye kewaye da iyaka, samar da hanya mai sauƙi da sauƙi wurin wurin su a cikin takarda.