Nanunso zingakuchitikireni.
Mukamagwira ntchito ndi bukhu lalikulu lantchito ku Excel, nthawi imodzi sizodabwitsa konse, mumachita zinthu zopanda vuto (kuwonjezera mzere kapena kuyika kagawo kakang'ono ka maselo, mwachitsanzo) ndipo mwadzidzidzi mumapeza zenera ndi cholakwika "Maselo ambiri osiyanasiyana. mafomu":
Nthawi zina vutoli limapezeka mu mawonekedwe osasangalatsa. Usiku watha, monga mwachizolowezi, mudasunga ndi kutseka lipoti lanu ku Excel, ndipo m'mawa uno simungathe kulitsegula - uthenga wofananawo ukuwonetsedwa ndi lingaliro lochotsa masanjidwe onse pafayilo. Kusangalala sikukwanira, kuvomereza? Tiyeni tiwone zomwe zimayambitsa ndi njira zothetsera vutoli.
Chifukwa chiyani izi zikuchitika
Vutoli limachitika pomwe buku lantchito likupitilira kuchuluka kwamitundu yomwe Excel ingasunge:
- kwa Excel 2003 ndi kupitilira apo - awa ndi mawonekedwe 4000
- za Excel 2007 ndi zatsopano, awa ndi mawonekedwe 64000
Kuphatikiza apo, mawonekedwe pankhaniyi akutanthauza kuphatikiza kulikonse kwamitundu yosiyanasiyana:
- zojambula
- kudzaza
- kupanga ma cell
- mtundu wa nambala
- kusanjidwa koyenera
Chifukwa chake, mwachitsanzo, ngati mwalemba kachidutswa kakang'ono ka pepala motere:
… ndiye Excel idzakumbukira 9 mitundu yosiyanasiyana ya ma cell mubukhu lantchito, osati 2, monga zikuwonekera poyang'ana koyamba, chifukwa mzere wokhuthala wozungulira mozungulira udzapanga, makamaka, zosankha 8 zosiyanasiyana. Onjezani ku mavinidwe opanga ma fonti ndi zodzaza, ndipo kulakalaka kukongola mu lipoti lalikulu kumabweretsa mazana ndi masauzande ophatikizika ofanana omwe Excel ayenera kukumbukira. Kukula kwa fayilo kuchokera pamenepo, palokha, nakonso sikuchepa.
Vuto lofananalo limapezekanso mukakopera mobwerezabwereza zidutswa za mafayilo ena mubuku lanu (mwachitsanzo, posonkhanitsa mapepala ndi macro kapena pamanja). Ngati phala lapadera la zinthu zokha silinagwiritsidwe ntchito, ndiye kuti mafomu omwe amakopedwa amalowetsedwanso m'bukuli, zomwe zimatsogolera kupitirira malire.
Momwe mungachitire ndi izi
Pali mayendedwe angapo apa:
- Ngati muli ndi fayilo yamtundu wakale (xls), ndiye sunganinso ina (xlsx kapena xlsm). Izi zidzakweza mipiringidzo nthawi yomweyo kuchokera ku 4000 mpaka 64000 mitundu yosiyanasiyana.
- Chotsani masanjidwe a cell osafunikira ndi zina "zokongola" ndi lamulo Kunyumba - Chotsani - Chotsani mawonekedwe (Kunyumba - Chotsani - Chotsani Kapangidwe). Onani ngati pali mizere kapena mizati pamapepala omwe ali ndi mawonekedwe onse (ie, mpaka kumapeto kwa pepala). Musaiwale za mizere yobisika yotheka.
- Yang'anani m'buku la mapepala obisika komanso obisika kwambiri - nthawi zina "zaluso" zimabisika pa iwo.
- Chotsani masanjidwe osafunikira pa tabu Kunyumba - Mapangidwe Okhazikika - Sinthani Malamulo - Onetsani Malamulo Opangira Mapepala Onse (Kunyumba - Kapangidwe Kovomerezeka - Onetsani malamulo atsambali).
- Onani ngati mwapeza masitayelo ochulukirapo osafunikira mutakopera zomwe mwalemba m'mabuku ena. Ngati pa tabu Kunyumba (Kunyumba) M'ndandanda masitaelo (Masitayelo) kuchuluka kwa "zinyalala":
... ndiye inu mukhoza kuchotsa izo ndi zazikulu yaing'ono. Dinani Alt + F11 kapena batani Zooneka Basic tsamba Woyambitsa (Wolemba Mapulogalamu), ikani gawo latsopano kudzera pa menyu Ikani - Module ndi kukopera ma macro code pamenepo:
Sub Reset_Styles() 'chotsani masitayelo onse osafunika Pa chilichonse cha objStyle Mu ActiveWorkbook.Masitayelo Pa Cholakwika Bweretsaninso Kenako Ngati Sikuti objStyle.BuiltIn Kenako objStyle.Delete On Error GoTo 0 Next objStyle 'koperani seti yokhazikika ya masitaelo kuchokera mu buku lantchito latsopano = ActiverkWorkMy Khazikitsani wbChatsopano = Mabuku Ogwiritsa Ntchito.Onjezani wbMy.Styles.Merge wbChatsopano wbChatsopano.Tsekani zosintha:=Nthawi Yabodza
Mutha kuyiyambitsa ndi njira yachidule ya kiyibodi. Alt + F8 kapena pa batani Macros (Makiro) tsamba Woyambitsa (Wolemba Mapulogalamu). Macro imachotsa masitayelo onse osagwiritsidwa ntchito, ndikusiya zokhazikika zokha:
- Momwe Mungawunikire Ma cell Okhazikika Ndi Mapangidwe Okhazikika mu Excel
- Kodi macros ndi chiyani, momwe mungakopere ma macro code mu Visual Basic, momwe mungayendetsere
- Buku la Excel lakhala lolemera kwambiri komanso lochedwa - mungakonze bwanji?