Hi CK, 查閱過找不到類似嘅Keyboard ShortCut. 但可以用product function =product(只需要highlight需要計算嘅範圍)
@user-je4se5dz5mАй бұрын
大家好,我是当时在汝矣岛见到的17岁学生:) 很高兴能聊到关于meaning full life的话题! 虽然不知道视频是什么意思,但是我会看的(这也是用翻译器写的文章,哈哈哈)
@KKLeungАй бұрын
@@user-je4se5dz5m I👀we had a great talk yesterday. Keep going never stop. No matter what problem or failure you encountered, just figure out the next step you should do. 💪
Hi KK Sir, 想問下[3] Import Data from PDF部份, 如果我用影印機< scan pdf >文件, 但最後 import 唔到去 Excel, 想請問一下有什麼方法可以解決 ?
@KKLeungАй бұрын
@@patrick_2024 Hi Patrick, 你是用什麼版本Excel?
@patrick_2024Ай бұрын
@@KKLeung 我是用Excel 365
@KKLeungАй бұрын
Hi Patrick, 請按下你步驟 1. 先用window Snipping tool 將 PDF Table 剪輯入 Clipboard 2. Excel 選擇 Data 3. From Picture 4. Picture from Clipboard 5. 進入scanning process
@babamamiko89318 күн бұрын
Could we use subtotal instead of alt+=
@KKLeung7 күн бұрын
@@babamamiko8931 thanks for inquiry. If you are talking about 14:28, you can directly use shortcut [Alt + = ] to add subtotal. It is a faster way to do it. Thanks a lot. KK
@paulyeung5628Ай бұрын
K.K 老師,有功能鍵顯示Formule ,請問可唔可以鎮死Formule防止錯誤刪除或修改🙏🙏🙏
@KKLeungАй бұрын
Hi Paul, 多謝收看 請參考下列影片 14:45 時段, 應該可以解答你嘅提問, 如有需要再留言交流 kzbin.info/www/bejne/hKjPmoqQnqhmf5Isi=CJByalThqPqRHB6u
@paulyeung5628Ай бұрын
@@KKLeung 謝謝🙏🙏🙏
@kennyfok6872Ай бұрын
KK sir, 可否介紹一個 trick 怎樣可以從一個cell 的comment " cut and paste " 去第二個 cell ? 希望可以少做一個步驟去清除原本的 comment box, 在網上找不到這方法. 謝謝賜教🙏
@KKLeungАй бұрын
Hi Kenny 可試吓 1 copy the cell that has comment 2 select the target cell 3 paste special 4 select comment If it does not work, text me again. Thanks