Makiyi otentha kwambiri

Anonim

Makiyi otentha mu Microsoft Excel

Makiyi otentha ndi ntchito yomwe imagwiritsa ntchito malo osungirako kiyibodi yofunikira kwambiri, imapereka mwayi wogwiritsa ntchito mabotolo ena, kapena pulogalamu ina. Chida ichi chimapezekanso kuchokera ku Microsoft Excel. Tiyeni tiwone zomwe Hotkeys amapezeka pa ntchito yopambana, komanso kuti mutha kuchita nawo.

Wa zonse

Choyamba, ziyenera kudziwika kuti mndandanda womwe uli pansipa, "chizindikiro chimodzi + chimakhala chizindikiro chomwe chimatanthawuza kuphatikiza kwakukulu. Ngati chizindikiro cha "++" chimafotokozedwa - izi zikutanthauza kuti pa kiyibodi yomwe muyenera kukanikiza batani la "" "limodzi ndi kiyi ina, yomwe ikuwonetsedwa. Dzinalo la makiyi limasonyezedwa popeza amatchedwa kiyibodi: F1, F2, F3, etc.

Komanso, ziyenera kunenedwa kuti choyamba chofuna kukanikiza makiyi a ntchito. Izi zimaphatikizapo kusintha, Ctrl ndi Alt. Ndipo atatha, kugwira makiyi awa, kanikizani makiyi a ntchito, mabatani okhala ndi zilembo, manambala, ndi ena.

Zosintha General

Zida zapamwamba za Microsoft ndizomwe zimachitika mu pulogalamuyi: Kutsegulira, kupulumutsa, kupanga fayilo, ndi zina zambiri. Makiyi otentha omwe amapereka mwayi kwa ntchitozi ndi motere:

  • Ctrl + n - kupanga fayilo;
  • Ctrl S - Kusungidwa kwa Bukhu;
  • F12 - kusankha mtundu ndi malo a bukulo kupulumutsa;
  • Ctrl + O - Kutsegula buku latsopano;
  • Ctrl + F4 - kutsekedwa kwa bukulo;
  • Ctrl + p - Pririney.
  • Ctrl + a ndikuwunikira pepala lonse.

Kugawidwa kwa pepala lonse ku Microsoft Excel

Makiyi oyenda

Kuyang'ana pepalalo kapena buku, palinso makiyi otentha.

  • Ctrl + F6 - kuyenda pakati pa mabuku angapo omwe ali otseguka;
  • Tabu - kuyenda ku chipinda chotsatira;
  • Shift + Tab - kusuntha kupita ku selo yapita;
  • Tsamba - kayendedwe ka oyang'anira;
  • Tsamba pansi - kuyenda mpaka kukula kwa wowunikira;
  • Ctrl + Tsamba - Kuyenda ku pepala lapita;
  • Ctrl + Tsamba pansi - Kuyenda ku pepala lotsatira;
  • Ctrl + kumapeto - kuyenda pa khungu lomaliza;
  • Ctrl + kunyumba - kuyenda ku chipinda choyamba.

Pitani ku foni yoyamba ku Microsoft Excel

Makiyi otentha ogwiritsira ntchito zochitika

Microsoft Excel imagwiritsidwa ntchito osati zomangamanga za patebulo, komanso chifukwa chophatikizana mwa iwo, mwa kulowa njira. Kuti muthe kugwiritsa ntchito izi, pali hotsys yoyenera.

  • Alt + = - Kuyambitsa avosomima;
  • Ctrl + ~ - Kuwonetsa zotsatira za kuwerengera m'maselo;
  • F9 - Kubwerezanso kwa njira zonse mu fayilo;
  • Shift + F9 - Kubwezeretsanso kwa njira zogwirizira;
  • Shift + F3 - itanani ntchito ya Wizard.

Imbani master ntchito ku Microsoft Excel

Cholakwika

Makiyi otentha omwe adapangidwira kuti asinthe deta imakupatsani mwayi wodzaza patebulo ndi chidziwitso mwachangu.

  • F2 - Njira yosinthira ya khungu lotchedwa;
  • Ctrl ++ - kuwonjezera mizere kapena mizere;
  • Ctrl + - - Chotsani mizere yosankhidwa kapena mizere pa pepala la Microsoft;
  • Ctrl + Fufutsani - kuchotsa zolemba zomwe zasankhidwa;
  • Ctrl + h - Sakani / Sinthani zenera;
  • Ctrl + z - Kuletsa kuchitapo kanthu komaliza;
  • Ctrl + Alt + V ndi mawonekedwe apadera.

Kuyitanitsa kuyika kwapadera mu Microsoft Excel

Kuyemanga

Chimodzi mwazinthu zofunika kwambiri za matebulo ndi ma cell zimapangidwa. Kuphatikiza apo, mawonekedwe amakhudzanso kugwiritsa ntchito njira zomwe zimachitika.

  • Ctrl + Shift +% - kuphatikiza mitundu ya anthu ambiri;
  • Ctrl + Shift + $ - mtundu wa ziganizo;
  • Ctrl + yosasunthika + # - mtundu wa Tsiku;
  • Ctrl + Shift +! - Mtundu wa manambala;
  • Ctrl + Shift + ~ - Velani mtundu;
  • Ctrl + 1 - kutsegula kwa zenera la khungu.

Kuyimbira zenera loumba ku Microsoft Excel

Ma hotsko ena

Kuphatikiza pa makiyi otentha omwe adalembedwa m'magulu omwe ali pamwambawa, ntchito yopambana imakhala ndi kuphatikiza kofunikira kwa mabatani pa kiyibodi kuti iyitane ntchito:

  • Alt + '- kusankha kapangidwe kake;
  • F11 - kupanga chithunzi patsamba latsopano;
  • Shift + F2 - Sinthani ndemanga mu khungu;
  • F7 - Chongani mawu a zolakwa.

Onani mawu pa zolakwika mu Microsoft Excel

Inde, sikuti kugwiritsa ntchito makiyi otentha onse mu mapulogalamu a Microsoft Chuma Chuma chinaperekedwa pamwamba. Komabe, tinali kuganizira kwambiri zothandiza kwambiri, ndipo tinawafunafuna. Inde, kugwiritsa ntchito mafungulo otentha kumatha kusintha pulogalamu yothandiza kwambiri komanso kufulumizitsa pulogalamu ya Microsoft.

Werengani zambiri