作者查詢 / newacc

總覽項目: 發文 | 留言 | 暱稱
作者 newacc 在 PTT [ Office ] 看板的留言(推文), 共1727則
限定看板:Office
看板排序:
全部ask2108Office1727juniorhigh671NTUMEB98437Rubiks426TCFSH70TH322326NtuDormM1321puzzle257Little-Games235NTU230CGI-Game220Gossiping189WorldCup149GuildWars131TFSHS129Taitung116CVS89SENIORHIGH81NtuDormM375StupidClown72joke67Windows66Hiking63mobile-game58creditcard52Visual_Basic39Stock37DIABLO35tutor35Navy34Lifeismoney28NTUMEB9927ascii_wanted25NTUcourse23Android22CFP22MobilePay22movie22Divina21NTU-Exam21Q_ary20MayDay18PushDoll16Bank_Service14ForeignEX14hardware14SYSOP13Test13Baseball12marvel10BBSmovie9Steam9HOT_Game8MobileComm8NTUboardgame8Storage_Zone8TaichungBun8TFSHS67th3248HatePolitics7TY_Research7C_and_CPP6fastfood6GVOnline6LoveLive6outdoorgear6Volunteer6B98303XXX5Doctor-Info5HomeTeach5PttCard5QuestCenter5Teacher5Broad_Band4DYU4forsale4Google4memento4nb-shopping4NIU-ECE94b4Notebook4NTCUST4Olympics_ISG4PC_Shopping4PttHistory4Tai-travel4Viator4Viator93Chia4Viator96Gang4Viator97Chia4Viator97Yii4AntiVirus3ask-why3BoardGame3civil983CT24th3373CY-academic3e-coupon3Fund3HSNU_11663Mabinogi3NetRumor3NTHU_STAT943NTU-MAGIC3NTU09DFLL3NTU_trans3NTUCE-1023NtuDormM53NTUMETA3TFSHS65th3093TigerBlue3TurtleSoup3Anthro092Anthro122AOE2AskBoard2biker2cat2Childhood2CHSH_98_3202CMU_BST012Donate-Blood2Doraemon2DragonNest2ENG_Service2FixMyHouse2FLAT_CLUB2HardwareSale2KS97-3082L_LifeInfo2LCD2Math2MCU_Talk2MIS2NCUT2ntuACCT042NTUCH-1022NTUDormM72NTUEE1132NTUEE_Speech2NTUIB022NTUMEB952NTUSA2NUU_Talk2PathofExile2PttEarnMoney2PttLifeLaw2Shu-Lin2ShuangHe2Supermission2TAROT2TCFSH67TH102TCFSH69th3022tcfsh69th3042WuLing50-3172YiGo3112YLSH_863032YZU_EE99B2Agronomy-981AngelPray1Aves1B00A013XX1B97A013XX1b98610xxx1b98902xxx1B98A013XX1bicycle1BlackDesert1Campus-plan1CCU_Comm5241chatskill1cksh79th161Clothes1CMU_CM421CMU_M501CMU_M511CMWang1CrazyArcade1CSMU-D881CSMU-D981CSMU-HSA941CSMU-HSA971CSMU-MED951CSMU-MSSW941CSMUACAlumni1CSU1CYCU_ICE90AB1CYCU_MIS_93B1CYSH97Y3181Daan1Daliao1Datong1DigiCurrency1DigitalMusic1DoubleMajor1DragonBall1DTJH_3221Ecophilia1Emergency1EMS1Eng-Class1Fahrenheit1feminine_sex1FJU-EE-2005B1FJU-EE-VLSI1FJU-STAT91B1Food1FSHS-92-3101GameDesign1GetBackers1GetMarry1HCHS603121HCSHch13_3111HCU1HonorGuard1HsinYi1HSNU_10321HSNU_11461HSNU_11681HSNU_9481humanity1IAM_Aero0071ILSH-973091Instant_Food1Jam1kartrider1katncandix21KHCHS_TALK1KS96-3181KS97-3021KS98-3021KUAS1KUAS_ME94A1LadyGaga1Linyuan1Liu1LivingGoods1lizen34-6011LSSH1Matsu1ME-BASEBALL1MenTalk1model1music1N_E_Coastal1NCCU07_GID1NCCU07_SW1NCCU08_JAPAN1NCCU08_LawA1NCCU08_Math1NCCU09_LawA1NCCU09_LawB1NCCU09_LawC1NCCU_PFBASE1NCCUflamenco1NCHU-AE991NCHU-Wind1NCHU_CsHsnu1NCUMTClub1NCYU_Fst_991NDHU-Ch1001NDHU-Ch1011NDHU-Ch991Neihu1Network1North_Coast1NTIT_IMD921NTOU_TALK1NTU-K11NTU-Karate1NTU-OMIH991NTU-Puzzle1NTU_BOTDorm1NTUAC-Badmin1ntuACCT031NTUBIME-1031NTUBIME-1041NTUBIME102HW1NTUBIME103HW1NTUBSE-B-1001NTUBSE-B-981NTUDormFJr1NTUDormG31NTUE-TTB1NTUEE_LAB5061NTUF-981NTUHORTI981NTUIB031NTUMEB001NTUmed001NTUmed911NTUMiaoli1NTUphy001NTUphy991NTUPPM-971NTUPPM-981NTUST_Talk1NUK_AC1001NUK_EE100A1NUU-SHE-971OCU1ONE_PIECE1PCGC1photo1phys981points1PresidentLi1PSWO3rd1PTGS62nd3131PttBug1PttNewhand1PU_Family1R983220PT1RealPlaying1RootsnShoots1SCUG1share1SMSlife1Soft_Job1SongShan1SSSH_17th3141STDM-97-301A1Stephen1Sub_GMobile1Sub_GOnline1TaichungCont1Tainan1TaiShan1Taiwan3191tajen1TCFSH69th3061TCFSH70th3181TCFSH70th3201TCFSH70th3231TCFSHvolley1TFG07Shot1TFSHS68th3061TFSHS68th3211TFSHS69th3091TFSHS69th3211TFSHS69th3221TFSHS69th3231THU_Talk1THUIM-4th1TKU_ACC_95A1TKU_S92BIO1ToS1TSU_talk1TYSH49-3021USC1VAPE1VET_981Viator98Bing1Violation1Volleyball1Wanhua1Wanted1Wen-Shan1Wrestle1WuGu-BaLi1Zhongshan1<< 收起看板(360)
Re: [問題] office2024是買斷的 那校園版的呢
[ Office ]5 留言, 推噓總分: 0
作者: naohcl - 發表於 2025/09/08 21:15(4月前)
5Fnewacc: 008是國際受話方付費服務,01是中華電信管理的09/16 16:47
[算表] 請問一下要怎樣才不顯示出小數點
[ Office ]3 留言, 推噓總分: 0
作者: ifye - 發表於 2025/08/21 14:27(5月前)
1Fnewacc: reddit鄉民推薦用條件式格式設定08/21 14:38
2Fnewacc: https://bit.ly/3HLCUMv08/21 14:38
[算表] 某值條件為真,整列變化
[ Office ]9 留言, 推噓總分: 0
作者: surick - 發表於 2025/08/15 13:50(5月前)
1Fnewacc: 你應該是用條件式格式設定做的吧?08/15 18:04
2Fnewacc: 第一題,選擇「管理規則」之後,將「套用到」改為你所有需08/15 18:04
3Fnewacc: 要套用的格子08/15 18:04
4Fnewacc: 第二題,整列的話用公式會比較好做08/15 18:06
5Fnewacc: =$D3="是",然後範圍放整個資料區域08/15 18:07
6Fnewacc: https://i.meee.com.tw/QM4iYGr.png08/15 18:10
7Fnewacc: 阿沒看清楚題目是設定日期,不過只是範例不同而已,套用方08/15 18:11
8Fnewacc: 式是一樣的08/15 18:11
9Fnewacc: 使用公式時留意固定符號,並且是以最左上角的格子作基準08/15 18:13
[問題] Excel關閉後直接儲存?
[ Office ]8 留言, 推噓總分: +1
作者: Shoukaku - 發表於 2025/08/11 23:12(5月前)
1Fnewacc: 左上角不要開自動儲存08/12 00:07
3Fnewacc: 咦,介面不一樣 https://i.meee.com.tw/5Boo7Fb.png08/12 10:04
4Fnewacc: 你看看有沒有框起來的那個選項,取消就不會自動存08/12 10:06
5Fnewacc: https://i.meee.com.tw/WHx1n3R.png08/12 10:06
6Fnewacc: 跟是不是存在 onedrive 沒有絕對關係,存在 onedrive 預設08/12 10:07
7Fnewacc: 是自動存,不過也可以關閉自動儲存08/12 10:07
8Fnewacc: 對,我是365,我以為2024很新應該差不多 0rz08/12 11:02
[算表] 計算利息天數最大值
[ Office ]6 留言, 推噓總分: 0
作者: slamguyno1 - 發表於 2025/08/07 23:50(5月前)
1Fnewacc: 10000=(X-'1月1日'+1)/365,解 X ?08/08 09:53
2Fnewacc: 10000=1000000*0.03*(X-"1/1"+1)/36508/08 09:55
4Fnewacc: 我理解沒錯誤的話,這個就單純是列式問題了08/08 11:53
5Fnewacc: X=ROUNDDOWN(還款金額*365/本金/利率-1)+開始日08/08 11:54
[問題] 找不到訂閱也無法下載microsoft365
[ Office ]2 留言, 推噓總分: +2
作者: elbows - 發表於 2025/05/28 18:05(7月前)
1Fnewacc: Basic 沒有 mac 和 PC 授權05/28 21:59
[問題] 2021..excel vba~~初學者問題
[ Office ]6 留言, 推噓總分: 0
作者: pippeen - 發表於 2025/05/11 13:11(8月前)
1Fnewacc: VBA一行只做一件事,你這個寫法的意思是,將tswh=Range()05/11 15:49
2Fnewacc: 的值assign給Range("A3")05/11 15:50
3Fnewacc: 而在這個語法中,後面那個=並不是賦值,而是「是否相等」05/11 15:50
4Fnewacc: 要改寫的話,應該要改成這樣:05/11 15:51
5Fnewacc: Range("A3").Value = Range("B2").Width05/11 15:52
Re: [文件] word中分3欄等高,但表格不等高
[ Office ]6 留言, 推噓總分: +2
作者: kc1446 - 發表於 2025/05/05 18:23(8月前)
1Fnewacc: 它必須是三個獨立的表格,但仍然會有框線粗細的點差,可05/05 23:56
2Fnewacc: 以看我上篇的圖05/05 23:56
[文件] word中分3欄等高,但表格不等高
[ Office ]6 留言, 推噓總分: +2
作者: m9300913 - 發表於 2025/05/01 14:03(8月前)
1Fnewacc: 先做出三個只有兩欄一列的大格子,再個別分割成需要的列05/01 21:51
2Fnewacc: 數,這樣應該就可以外表等高但列數不同了吧05/01 21:51
3Fnewacc: 做出來大概長這樣 https://i.imgur.com/uJzf9ed.png05/01 22:10
[算表] Excel判斷大於遞減的數列
[ Office ]1 留言, 推噓總分: +1
作者: monologue62 - 發表於 2025/04/27 21:05(8月前)
1Fnewacc: 用VALUE(實際股價)去判斷,就可以讓空字串被視為004/27 21:24