Sonderani mu Excel: Kusintha Kabukhu Kakang'ono ka Ntchito

Zosankha Zowoneka mu Excel: Sungani Slider ndi Zoowera ndi Keyboard

Zojambula zowonjezera mu Excel zimasintha kukula kwa pepala lolemba pazenera, kulola ogwiritsa ntchito kukulitsa madera ena polowera kapena kuyang'ana kuti awone zonse zolemba palimodzi.

Kusintha mlingo wa zojambula sizimakhudza kukula kwenikweni kwa pepala lamasamba kotero kuti zolemba za pepalali zikukhala zofanana, mosasamala kanthu zazithunzi zosankhidwa.

Malo Osangalatsa

Monga momwe tawonetsera pa chithunzi pamwambapa, mu ma Excel atsopano (2007 ndi mtsogolo), kufotokozera pa tsambali kungatheke pogwiritsa ntchito:

1. zojambula zowonjezera zili pazenera zazomwe zikuwonetsedwa pa chithunzi pamwambapa;
2. Zotsatira zojambula zopezeka pa Tsambali la View of Excel riboni ;
3. Zondetsani pazembera ndi njira ya IntelliMouse;

Sula Slider

Kusintha kukula kwa kapepala kogwiritsira ntchito zojambulazo zimakwaniritsidwa mwa kukoketsa bokosi lojambula mobwerezabwereza.

Kutambasula bokosi lochezera ku zoo zolondola pochititsa kuti mapepala osamvetsetseka awoneke ndikuwonjezera kukula kwa zinthu - monga maselo , mzere ndi mitu ya pamutu, ndi deta - muzenera.

Kudula bokosi lochezera kumalo osanja lamanzere ndipo liri ndi zotsatira zosiyana. Chiwerengero cha worksheet chimawoneka chikuwonjezeka ndipo zinthu zomwe zili mu worksheet zimachepa kukula.

Njira ina yogwiritsira ntchito bokosi lotsegula ndikutsegula Zobola Zojambula ndi Zoom mu Makatani omwe ali kumapeto kwa zojambulazo. Mabataniwo amayendetsa kapepala kamene kali mkati kapena kunja kwa 10%.

Zosankha Zojambula - Onani Tab

Pa tsamba lachiwonetsero Chigawo cha Zoom ndizomwe mungasankhe:

• Sondani;
• 100%;
• Sonderani ku Kusankha.

Kusankha Zoom kusankha pa Tsambali labuboni likutsegula Bokosi la Zoom monga momwe yasonyezera kumanzere kwa chithunzi. Bukhuli lili ndi makonzedwe okulitsa kukonzekera kuyambira 25% mpaka 200%, komanso zosankha zowonjezera mwambo ndi zozama kuti zigwirizane ndi zosankhidwa zamakono .

Njira yotsirizayi ikulolani kuti muwonetse maselo osiyanasiyana ndikusintha mlingo woyenera kuti muwonetse malo omwe mwasankha pazenera.

Zowonjezera ndi Zingwe zadule

Kuphatikiza kwa makiyi a makiyi omwe angagwiritsidwe ntchito polowera mkati ndi kunja kwa tsambali kumaphatikizapo kugwiritsa ntchito fungulo la ALT. Mafupi awa amatha kupeza zojambulazo pa Tsatani labuboni pogwiritsa ntchito makiyi osakanikira kusiyana ndi mbewa.

Kwa zidule zomwe zalembedwa m'munsimu, pezani ndi kumasula makiyi omwe ali mu dongosolo lolondola.

• ALT + W + J - imayambitsa zojambula 100% pamzere;
• ALT + W + G - imachititsa Zoom kuti Kusankhidwe pa riboni;
• ALT + V + Z - imatsegula bokosi la zobo;
• ALT + W + Q - imatsegula bokosi la zobo;

Bokosi la Zoom loyamba likatsegulidwa, kusindikiza limodzi la mafungulo pansipa lotsatila ndi Key lolowamo lidzasintha mlingo wokweza.

• 0 + Lowani - 200% zojambula
• 1 + Lowani masentimita 100%
• 7 + Lowani - 75% zojambula
• 5 + Lowani - masentimita 50%
• 2 + Lowani - 25% zojambula

Zoomanga Zachikhalidwe

Kugwiritsa ntchito makiyi a pamwambawa kuti mutsegule zojambulazo za Mwambo kumafuna makina owonjezera powonjezera omwe akufunikira kutsegula Bokosi la Zoom .

Pambuyo polemba : ALT + W + Q + C, lowetsani manambala - monga 33 kuti mukhale okwera 33%. Lembani mndandandawu mwa kukanikiza fungulo lolowamo .

Sungani pa Pukutani ndi IntelliMouse

Ngati nthawi zambiri mumasintha mazenera a zolemba, mungagwiritse ntchito Zowonjezera pazembera ndi njira ya IntelliMouse

Mukatsegulidwa, njirayi imakulolani kuti mufufuze kapena kutuluka pogwiritsa ntchito gudumu pa IntelliMouse kapena mouse iliyonse yokhala ndi chikuku m'malo mwa kupukuta ndi kutsika mu tsamba.

Njirayi imatsegulidwa pogwiritsira ntchito Excel Options dialog box - monga momwe zilili kumbali yakumanja ya chithunzicho.

Zotsatira za Excel (2010 ndi kenako):

1. Dinani pa Fayilo ya tabu ya riboni kuti mutsegule Fayilo menyu;
2. Dinani pa Zosankha mu menyu kuti mutsegula Excel Options dialog box;
3. Dinani Patsogolo mu gulu lamanzere la bokosi;
4. Dinani pa Zowani pa pukuthala ndi IntelliMouse mu malo abwino kuti mutsegule njirayi.

Sungani kunja kuti muwonetse Mapangidwe

Ngati pepala lamasewera liri ndi mzere umodzi kapena maina ena , mazenera ochepa pansi pa 40% adzawonetsera mndandanda wa mainawa omwe akuzunguliridwa ndi malire, kupereka njira yofulumira komanso yosavuta yowunika malo awo pa tsamba.