Hada ginshikan a Excel kuma samar da dukkan haɗuwa

Samun cibiyoyin bayanai guda biyu, misali jerin abokan ciniki da samfurori, kuma suna son hada su don samun sabon jerin tare da duk haɗin haɗin abokan ciniki da samfurori? Maganar ita ce mai sauƙi, mai yiwuwa tare da MS Excel a cikin 'yan mintoci kaɗan, kuma, har ma da dubban shigarwa, baya buƙatar ƙoƙari mai yawa - yawa kasa da kwafin rubutun lissafi na biyu don kowane darajar lissafi na farko - wannan bayani na karshe zai dauki sa'o'i tare da daruruwan shigarwa. Dubi kasa yadda za a hada ginshiƙai Excel kuma samar da dukkanin haɗuwa mai kyau Excel....
Kara karantawa

Yadda za a warware wani kwamfutar tafi-da-gidanka na Asus wanda aka kashe ba tare da batawa ba?

Da zarar an sami kuskure ta hanyar kuskuren Asus ZenBook touchpad, tare da rashin yiwuwar yin amfani da ita ta hanyar amfani da gajeren hanya na keyboard, kadai mafita shine zuwa zuwa Windows saituna> na'urori> touchpad> saita touchpad zuwa ON....
Kara karantawa

Binciken ++ rudani, samfuran layi bazuwar

Yin amfani da Ƙambar + ɗin, * yana da sauqi don raka jerin layi, yana zuwa daga jerin abubuwan da aka tsara zuwa wani bazuwar, kamar yadda aka gani a sama. Don yin haka, ka tabbata ka shigar da Python Script plugin - in bahaka ba, duba Notepad ++ shigar da Python Script plugin tare da Toshe Mai sarrafawa. Za mu shigar da RandomizeLines.py don Notepad ++ daga github....
Kara karantawa

Yadda zaka kwatanta 2 fayilolin CSV tare da MS Access

Yana iya faruwa don ƙare tare da Tables daban-daban guda biyu, wanda kake son sanin ainihin bambance-bambance, musamman ma lokacin da kake sarrafa bayanai mai yawa. Ina ba ku shawara mai sauƙi don samo bambance-bambance tsakanin tebur guda biyu - shine kawai mai wahala shine don samun su a cikin tsari madaidaiciya!...
Kara karantawa

Notepad ++ cire adiresoshin email daga fayil ɗin rubutu

Samun fayil, misali haɓaka daga akwatin gidan waya naka, kuma kuna son cire kawai adiresoshin email? Amfani da Takaddun shaida ++ da sauƙin magana na yau da kullum, shi ke da sauki. Duba kasa cikakken misali, ko, don taƙaitawa, buɗe fayil ɗinka, yi amfani da regexp ƙasa don samun adiresoshin imel, ƙara ragowar layi kafin da bayan kowane ɗayan, sa'an nan kuma alama alamar da ke dauke da adireshin imel da kuma share alamar da ba a yaye ba....
Kara karantawa

Yadda za a kashe sanarwar Chrome akan Windows10?

Sanarwa na Chrome zai iya zama m a kan Windows10. Duk da haka, akwai hanya mai sauƙi don kashe su, ta hanyar zuwa saituna> saitunan abun ciki> sanarwa> toshe. Dubi kasa mai cikakken misali don kashe sanarwar Chrome a kan Windows 10 - Har ila yau, duniya ta kashe sanarwar FaceBook akan Chrome, da kuma wani shafin yanar gizon ko sanarwar da aka kunna ta kuskure, ko kuma ba a buƙata ba....
Kara karantawa

Ta yaya za a sake mayar da mai sarrafa mai asusun Notepad ++?

A cikin sababbin sutannin Notepad ++, mai sarrafa mai sarrafawa bai fito da tsoho ba. Don ƙara da shi, dole ne a shigar da plugin nppPluginManager wanda zai maye gurbin mai sarrafa mai sarrafawa, sannan ya ba da izinin bincika, shigarwa, sabuntawa da kuma share asusun Notepad ++....
Kara karantawa

Yadda zaka iya rikodin Windows kyauta tare da PowerPoint?

Shin, kun san cewa PowerPoint na iya yin rikodin rikodi don kyauta Wannan yana daidai, kuna karantawa sosai - idan kuna da Microsoft PowerPoint da aka sanya akan kwamfutarku, yanzu za ku iya rikodin rikodin kwamfutarku kyauta, tare da kyakkyawar inganci....
Kara karantawa

Yadda za a canza ƙungiyoyin fayilolin Windows 10?

A yayin bude wani nau'in fayil a Windows Explorer, da kuma bude shi a wani shirin fiye da wanda kake so, mafita shine canza canjin fayilolin Windows 10 na waɗannan fayiloli, bisa ga girman fayil. Yi don haka, je zuwa saitunan> apps> aikace-aikacen tsoho> zaɓi aikace-aikacen tsoho ta hanyar fayil> zaɓi tsawo fayil> canza aikace-aikace....
Kara karantawa

Shafin Farko na Microsoft OutLook don wuri na

A cikin Ma'aikatar Outlook, za ka iya ƙara yawan wurare masu yawa kamar yadda kake so a matsayin masoyanka, kuma zaɓi wanda aka nuna. Don ƙara wuri, danna kan wurin yanzu, kuma danna Add Location: Shigar da sunan wurin, ko birni mafi kusa, kuma danna shigar don samun shawarwarin birni....
Kara karantawa

FreeOffice samun launuka baya a PDF fitar da

Tun da OpenOffice [1] ya koma FreeOffice [2], sakamakon sabili da Sun Microsystems wanda Oracle ya sayi [3], wasu bambance-bambance sun iya ji, sai dai sauya sunan. Ɗaya daga cikin su, a kan kyaftin kyauta (ainihin 3.3.3), yana da tasiri a kan ni: na fitar da PDF ɗin baƙi ne da fari....
Kara karantawa

Binciken MSOutlook ya canja yanayin yanayi

Yanayin a cikin kalandar Outlook an nuna shi a cikin ɓangaren da ba daidai ba, wato Celsius C ° maimakon Fahrenheit F °, ko kuma ba daidai ba, Fahrenheit F ° maimakon Celsius C °? Zai yiwu a canza yanayin yanayin da aka nuna a cikin MSOutlook daga Celsius zuwa Fahrenheit, ko daga Fahrenheit zuwa Celsius ta hanyar zuwa menu Menu> Zaɓuɓɓuka> Kalanda> zaɓi yanayin yanayi don nunawa....
Kara karantawa

Outlook sami fayiloli marar nauyi a matsayi na babban fayil

Ta amfani da binciken da aka ci gaba da bincike, ana iya samu imel ta hanyar abun ciki ko mai aikawa, kuma ga abin da babban fayil ɗin suke samuwa, ta hanyar amfani da matakan kayan aiki na Outlook. Yana da sauƙi don motsawa ta hanyar kuskure babban fayil daga matsayi na babban fayil a cikin Outlook ba tare da lura ba - kuma da wuya a samu shi....
Kara karantawa

Ba za a iya ɗaukar nauyin 32 bit Abubuwan da aka saka ba ++

Bayan da aka shigar da Notepad ++ tare da kantin kayan Windows 10, an shigar ta da 64 bits ta tsoho. Wannan ba matsala bane, sai na yi kokarin kwatanta fayilolin rubutu biyu tare da Notepad ++ kuma Ka aika jerin kuma cire duplicates, wanda duka suna buƙatar samfurin 32 na Notepad ++ don aiki....
Kara karantawa

Fayil na Notepad ++ a cikin sabon taga

Kamar yadda ka iya lura, Notepad ++ ba ya ba da zaɓi don buɗe sabon taga, kuma yana buɗe duk fayiloli a daya. Don buɗe sabon taga, inda za a bar ka bude fayiloli / ƙirƙirar sababbin shafuka / ja da sauke fayiloli bude, kawai sanya malaminka a kan sunan sunan fayil ɗin da kake buƙatar budewa a sabon taga, danna kuma ka riƙe maballin linzamin kwamfuta a guga man, ka cire linzamin kwamfuta daga cikin Notepad ++ taga, saki maɓallin linzamin kwamfuta - kuma a nan!...
Kara karantawa

Manna CSV cikin Excel

Kwafi pasting CSV (Sakamakon Zama-Kwance) yana da kyau a Microsoft Excel! A takaice: amfani da Data> Rubutun zuwa Rubutun zaɓi. Farawa tare da fayil ɗin CSV, kamar waɗannan masu zuwa, buɗe shi a Excel ta yin amfani da madaidaicin fayil na Excel, ta amfani da gajeren hanya ta hanyoyi CTRL + O, ko ta buɗe shi a cikin Windows Explorer tare da dama dama da zaɓi Bude tare da Excel 2010 / Excel 2013 / Excel 2016, dangane da fasalin da kuka shigar....
Kara karantawa

An manta Windows 10 kalmar sirri ba faifai

Yadda za'a sake saita kalmar sirri akan Windows 10 ba tare da faifan ba An rufe katangar yatsa, PIN ba ya aiki kuma, kalmar wucewa ta manta, baza ta iya dawo da asusun Microsoft ba, kuma babu hanyar WiFi? Dubi kasa hanya don warware shi ba tare da buƙatar sake saiti ba - kawai toshe wayar tare da kebul, raba raɗin intanit kuma sake sace kalmar sirrin Windows 10!...
Kara karantawa

Bluetooth haɗi amma ba a haɗa Windows 10 ba

Kayan kunne na Bluetooth sun haɗa biyu amma ba a haɗa Windows 10 ba Zai iya faruwa cewa na'urar Bluetooth, kamar maɓallin kai, wadda aka haɗa ta farko da kuma haɗa shi a kan shigarwar Windows, ba zato ba tsammani ba zai iya sake haɗawa ba, yana ƙare tare da Bluetooth mai haɗawa amma ba sauti. Akwai dalilai masu yawa da za a iya samun wannan, da kuma hanyoyin da za su iya ba ka damar sake haɗa na'urarka....
Kara karantawa

Binciken Windows yana nuna cikakken hanya

A yayin da kake yin bincike a window mai binciken Windows, zai zama mai ban sha'awa don ganin wuraren fayiloli a sakamakon. Ba a nuna wannan ba ta tsoho - duk da haka, akwai hanya mai sauƙi ta yin haka, ta hanyar nuna nema a matsayin jerin, da kuma ƙara cikakken hanyar matakan cikin ginshiƙai masu nunawa....
Kara karantawa

Babbar Jagora na Excel vlookup - Yadda ake yin vlookup

Yayin da kake yin amfani da ganuwa akan jerin sunayen daga kafofin daban-daban, za ka iya kawo ƙarshen rashin daidaitattun dabi'u. Misali misali: SAP cire idan aka kwatanta da fayil ɗinku na gida, Jerin Excel idan aka kwatanta da wani SAP extract, Jerin Excel idan aka kwatanta da jerin rubutun, ......
Kara karantawa

Fayil din binciken Windows a fayiloli da manyan fayiloli tare da Notepad ++

Ɗaya daga cikin damar da ake amfani da shi na Notepad ++, shine bincika fayilolin rubutu masu yawa don rubutu na rubutu kuma sami fayiloli da manyan fayilolin - ciki har da subfolder da windows boye fayiloli da manyan fayilolin - har ma don nemowa da maye gurbin wannan kundin binciken a duk fayiloli....
Kara karantawa

Maimaitaccen hoton hoton da aka yi da GIMP mai sarrafa hoto

A wasu lokatai, yana da amfani don sabuntawa a daya harbi wani tsari na hotuna. Wannan aikin yana ɗaukar mintuna kaɗan zuwa saitin ta amfani da plugin samfurin Hoton GIMP. Yana nufin aiki kamar yadda fayiloli da yawa kamar yadda kake so a yanzu, misali mahimmancin yanki zai sake sake dubban fayiloli a cikin wani aiki....
Kara karantawa

Yadda za a sauke saitunan a cikin VLC

Tun da wasu sigogi na VLC, yanzu an gina wani zaɓi wanda zai bincika ƙananan fayiloli na layi na yanzu a kan layi, sauke wanda aka zaba, kuma kunna shi tare da fim, tare da kawai dannawa. Ana samun wannan ta hanyar ƙaddamar VLC VLsub, wadda ta riga ta samfurin waje, amma yanzu an haɗa shi a cikin na'urar jarida VLC....
Kara karantawa

Yadda za a share tebur a cikin Gmail

Share tallan Gmail a saƙon email zai iya zama mai rikitarwa, kamar yadda aka zaɓa cikin dukan launi da kuma latsa Share key, ko baya, zai share bayanai a cikin tebur, amma barin skeleton. A takaice, don cire gaba ɗaya daga tebur daga sakon: ƙara rubutu kafin da bayan teburin, sanya linzamin linzamin kwamfuta kafin rubutun farko, riƙe maɓallin Shift, kuma danna a ƙarshen rubutu bayan tebur. Latsa Maɓallin sharewa zai yanzu share rubutu + cikakken tebur....
Kara karantawa

Maganar Kalanda ta shigo ICS

Ko da yaushe ya yi ƙoƙarin ƙara ICS zuwa Calendar na Google, misali misali na Outlook.Fayan fayil a cikin Calendar na Google, kuma ba zai iya samun yadda ta yaya ba? Yana da kyau sauƙi. Samar da cewa fayil ICS, misali fitowa daga Outlook, an riga an ƙirƙira shi kuma yana iya samuwa a tsarin komfutar kwamfuta....
Kara karantawa

Lotus Notes an sami kuskure yayin bude wani taga

Kada a sake yin kwamfutarka! Duk abin da zaka yi shi ne don ƙare tsarin tsari na ntaskldr.exe. Wannan yana iya faruwa a lokacin da yake rufe Lotus Notes, misali ta hanyar kammala aikin, ko kuma neman Windows don yin shi lokacin da shirin bai amsa ba, za ka iya fuskantar wannan batu a farkon Lotus Notes farawa....
Kara karantawa

Sharepoint ba zai iya bude littafin ba

Muna hakuri cewa ba za mu iya bude takardar littafinka na Sharepoint 2013 ba Lokacin da ba zai iya bude wani littafi mai aiki ba daga Sharepoint, wani bayani shine sauke fayilolin gida na farko, sa'annan ya bude shi daga bisani, maimakon yin bude shi a kan Excel ɗin layi daga layi na Intanet....
Kara karantawa

Siffar tutorial ƙara hyperlink zuwa PDF

Yin amfani da software na kyautar Scribus, yana yiwuwa don ƙara hyperlink a saman kowane hoto, da kuma fitarwa shi zuwa tsarin PDF. Lokacin yin aiki a kan takardun, zai zama wani abu na kayan aiki, hoto mai wallafewa, ko kuma hoto kawai, yana yiwuwa a ƙara a kan kowane ɓangare na hoton, bayanin haɗi, ko hyperlink, wanda za'a nuna a wani m PDF a matsayin area clickable, da haifar da bude hyperlink....
Kara karantawa

Binciken ++ kwafi tare da tsarawa

Tsarin rubutu a Notepad ++ za a iya kwafe shi zuwa takarda kai ko fitar dashi ta amfani da menu Manyan> NppExport> Fitarwa zuwa RTF ko Fitarwa zuwa HTML. Da zarar an fitar dashi, za'a tsara fassarar da aka tsara tare da rubutun da aka tsara a wasu aikace-aikace, irin su LibreOffice, Microsoft Word, ko WordPress post....
Kara karantawa

MS Access Oracle ODBC direba

Idan ka yi kokarin dawo da bayanan daga layin Oracle na MS Access, za ka iya samun kuskure "kuskuren ɓataccen lokaci 3184: Ba za a iya aiwatar da tambaya ba; ba za a sami layin da aka haɗa ba. [IBM] [System in Access ODBC Driver] [ DB2 don i5 / OS] SQL0204 - Tebur a cikin sunan Sunan DB * Ba a sami FILE ba (# -204) "(Fig 1)....
Kara karantawa

Yadda za'a rikodin allon akan Windows 10 don kyauta

Akwai hanyoyi da yawa don rikodin allon don kyauta a kan Windows 10, ko dai ta yin amfani da ginin a Mai rikodin allon wasanni tare da Windows + G, kuma bin umarnin allo. Sauran zabin shine shigar da kyakkyawar mai kunnawa VLC, kuma amfani da shi a matsayin mai rikodin bidiyo na kyauta don Windows 10 ko wani Windows version wanda aka shigar da ita....
Kara karantawa