作者查詢 / Or3
作者 Or3 在 PTT [ Office ] 看板的留言(推文), 共43則
限定看板:Office
看板排序:
全部Tainan5610Lifeismoney3099e-shopping3034Stock2076Gossiping2069Starbucks1167Brand1140MobileComm1042Japan_Travel1029intltrade553Bank_Service486creditcard470KoreaDrama467Android297Insurance262MobilePay249CVS216einvoice186Thailand185BeautySalon170Salary168street_style162Aviation157LivingGoods145stationery136PokemonGO132TY_Research127DSLR120shoes106Railway97Headphone96DC95ForeignEX85iOS85Road_Running75OTT74Ptt25sign70WomenTalk69ChangHua60cat51movie49EAseries48fastfood48car47MakeUp47Office43Depstore42marriage41Hong_Kong35Fund34hypermall34Mix_Match34Facebook32IntlShopping32E-appliance29Kaohsiung28outdoorgear24Loan22Japandrama21Tech_Job21Baseball19Doctor-Info19Option18Hate16StupidClown16TaiwanDrama16BuyTogether15Google15Japan_Living13Korea_Travel13Perfume12cookclub11tax11Instant_Mess10PTT25_Game10BabyMother9bag9biker9fashion9HatePolitics9homemaker9ask8facelift8Violation8Food7MAC7teeth_salon7Anti-Cancer6hairdo6Lomo6marvel6rent-exp6watch6bicycle5Fighters5Finance5TUT5DailyArticle4Digitalhome4FoodDelivery4HelpBuy4Instant_Food4iPod4KERORO4NSwitch4SYSOP4WorldCup4Birthday3CareerLady3Chiayi3Coffee3Foreign_Inv3Free_box3MP3-player3RO3Wanted3AppsForBBS2Archery2Broad_Band2Chat82gether2China_Travel2CYCU-IM2e-coupon2EZsoft2female-shoes2feminine_sex2funeral2Interior2JapanMovie2kachaball2L_LifePlan2MuscleBeach2nb-shopping2Neihu2pay_home2PokeMon2PttEarnMoney2YOLO2Actuary1Ame_Casual1Anti-ramp1ayaka1Balloon1Board-Police1Bread1Covid-19exp1CSMU-MED931Delivery1dog1Drama-Ticket1Drink1EarthQuake261EarthQuake431EarthScience1eat-disorder1Employee1fatworld1FireEmblem1FixMyHouse1H_Tamaki1Hsinchu1joke1Korea1L_TalkandCha1Leo1LTK1Metal_kids1Military1NCCU1Ninomiya1Olympics_ISG1PSP-PSV1PttNewhand1ScenicPhoto1Singapore1Sony-style1studyteacher1Suckgame1TaichungBun1Teacher1Tour-Agency1TW-language1Windows1YomiuriGIANT1<< 收起看板(184)
1F推:沒記錯的話OE應該只能匯入outlook資料夾 所以應該要先把pst檔03/21 09:22
2F→:弄進outlook裡03/21 09:22
1F推:複製 選擇性貼上 公式03/20 00:03
10F推:我沒誤解壓 同時複製A3和C2 選取要複製的儲存格 選擇性貼上公03/20 08:33
11F推:說錯 不能同時複製 但剛剛試過公式可以複製03/20 08:37
10F推:推先印150份 只要換一次03/20 11:13
11F→:A檔印150份 翻面全部印b檔03/20 11:14
1F推:這當然用access做比較方便壓~03/19 14:14
1F推:scroll lock03/19 09:48
1F推:後面欄位要同時排序的話儲存格大小要相同03/19 08:55
2F→:比較好的方式是123都打2/28 56打3/5 這樣便能排序03/19 08:56
1F推:可用橡皮擦擦掉吧~03/18 09:28
2F→:如果你不要長度大小相同的格子 應該要選手繪表格03/18 09:29
3F推:因為你設定yyyy/mm 所以只要是1月份任一天都顯示2008/0103/18 09:44
1F推:IF(A1="",B1,IF(B1="",A1,IF(A1=B1," "))) 這樣咧?03/17 22:55
1F推:謝謝! 似乎是個好方法~明天來試試~03/17 22:32