Momwe mungatsegule Excel yatsopano pawindo lina

Kodi mudadikirirapo mphindi zingapo kuti buku lanu la Excel ligwiritse ntchito macro, kusintha Power Query, kapena kuwerengeranso ma formula olemetsa? Mukhoza, ndithudi, kudzaza kapu ndi kapu ya tiyi ndi khofi pa zifukwa zovomerezeka, koma mwinamwake munali ndi lingaliro lina: bwanji osatsegula buku lina la Excel pafupi ndikugwira ntchito nalo panopa?

Koma sizophweka.

Ngati mutsegula mafayilo angapo a Excel mwanjira yanthawi zonse (dinani kawiri mu Explorer kapena kudzera pa Fayilo - Open mu Excel), amangotsegula chimodzimodzi mu Microsoft Excel. Chifukwa chake, ngati muthamangitsa kuwerengeranso kapena macro mu imodzi mwamafayilowa, ndiye kuti ntchito yonseyo ikhala yotanganidwa ndipo mabuku onse otseguka adzaundana, chifukwa ali ndi machitidwe wamba a Excel.

Vutoli limathetsedwa mosavuta - muyenera kuyambitsa Excel mwanjira ina. Idzakhala yodziimira payokha yoyamba ndipo idzakulolani kuti mugwiritse ntchito mafayilo ena mwamtendere pamene chitsanzo chapitalo cha Excel chikugwira ntchito yolemetsa mofanana. Pali njira zingapo zochitira izi, zina zomwe zingagwire ntchito kapena sizingagwire ntchito kutengera mtundu wanu wa Excel ndi zosintha zomwe mwayika. Choncho yesani chilichonse chimodzi ndi chimodzi.

Njira 1. Patsogolo

Njira yosavuta komanso yodziwikiratu ndikusankha kuchokera pamenyu yayikulu Yambani - Mapulogalamu - Excel (Yambani - Mapulogalamu - Excel). Tsoka ilo, njira yakaleyi imagwira ntchito m'mitundu yakale ya Excel.

Njira 2: batani lapakati kapena Alt

Momwe mungatsegule Excel yatsopano pawindo lina

  1. Dinani kulondola podina chizindikiro cha Excel pa taskbar - menyu yankhani idzatsegulidwa ndi mndandanda wamafayilo aposachedwa.
  2. Pansi pa menyu iyi padzakhala mzere wa Excel - dinani pamenepo anasiya batani la mbewa, atagwira pamene key alt.

Excel ina iyenera kuyamba ndi njira yatsopano. Komanso, m'malo modina kumanzere ndi alt mutha kugwiritsa ntchito batani lapakati la mbewa - ngati mbewa yanu ili nayo (kapena gudumu lopanikizika limagwira ntchito yake).

Njira 3. Mzere wa lamulo

Sankhani kuchokera ku menyu yayikulu Yambani - Thamanga (Yambani - Thamangani) kapena dinani njira yachidule ya kiyibodi Win+R. M'munda womwe ukuwoneka, lowetsani lamulo:

Momwe mungatsegule Excel yatsopano pawindo lina

Pambuyo pang'anani OK mtundu watsopano wa Excel uyenera kuyamba mwanjira ina.

Njira 4. Macro

Njira iyi ndi yovuta kwambiri kuposa yam'mbuyomu, koma imagwira ntchito mumtundu uliwonse wa Excel malinga ndi zomwe ndawonera:

  1. Kutsegula Visual Basic Editor kudzera pa tabu Wopanga - Visual Basic (Wopanga - Visual Basic) kapena njira yachidule ya kiyibodi alt + F11. Ngati ma tabo Woyambitsa sizikuwoneka, mutha kuziwonetsa Fayilo - Zosankha - Kukhazikitsa Riboni (Fayilo - Zosankha - Sinthani Riboni).
  2. Pazenera la Visual Basic, ikani gawo latsopano lopanda kanthu la code kudzera pa menyu Ikani - Module.
  3. Lembani khodi ili pamenepo:
Sub Run_New_Excel() Khazikitsani NewExcel = CreateObject("Excel.Application") NewExcel.Workbooks.Add NewExcel.Visible = True End Sub

Ngati mutayendetsa macro omwe adapangidwa tsopano kudzera Wopanga - Macros (Wopanga - Macro) kapena njira yachidule ya kiyibodi alt+F8, ndiye chitsanzo china cha Excel chidzapangidwa, monga momwe timafunira.

Kuti zikhale zosavuta, nambala yomwe ili pamwambapa ikhoza kuwonjezeredwa osati m'buku lamakono, koma ku Personal Book of Macros ndikuyika batani lapadera la njirayi pagawo lolowera mwamsanga - ndiye kuti izi zidzakhala pafupi.

Njira 5: Fayilo ya VBScript

Njirayi ndi yofanana ndi yapitayi, koma imagwiritsa ntchito VBScript, chinenero chosavuta cha Visual Basic, kuti achite zinthu zosavuta mu Windows. Kuti mugwiritse ntchito chitani zotsatirazi:

Choyamba, yambitsani chiwonetsero chazowonjezera za mafayilo mu Explorer kudzera Onani - Zowonjezera Fayilo (Onani - Zowonjezera Mafayilo):

Momwe mungatsegule Excel yatsopano pawindo lina

Kenako timapanga fayilo mufoda iliyonse kapena pakompyuta (mwachitsanzo NewExcel.txt) ndikukopera nambala ya VBScript ili pamenepo:

Khazikitsani NewExcel = CreateObject("Excel.Application") NewExcel.Workbooks.Onjezani NewExcel.Visible = Seti yeniyeni NewExcel = Palibe

Sungani ndi kutseka fayilo, ndiyeno sinthani kufalikira kwake txt on mavu a. Mukasinthanso, chenjezo lidzawonekera lomwe muyenera kuvomereza, ndipo chithunzi cha fayilo chidzasintha:

Momwe mungatsegule Excel yatsopano pawindo lina

Chirichonse. Tsopano kudina kawiri batani lakumanzere pafayiloyi kudzayambitsa chitsanzo chatsopano cha Excel mukachifuna.

PS

Kumbukirani kuti kuphatikiza pazabwino, kuyendetsa ma Excel angapo kulinso ndi zovuta zake. machitidwe awa "sawonana" wina ndi mzake. Mwachitsanzo, simungathe kupanga ulalo wolunjika pakati pa ma cell abukhu lantchito mu Excel. Komanso, kukopera pakati pa zochitika zosiyanasiyana za pulogalamuyo, ndi zina zotero kudzakhala kochepa kwambiri. Nthawi zambiri, komabe, uwu si mtengo waukulu wolipira chifukwa chosataya nthawi kudikirira.

  • Momwe mungachepetse kukula kwa fayilo ndikufulumizitsa
  • Kodi Personal Macro Book ndi momwe mungagwiritsire ntchito

Siyani Mumakonda