Try   HackMD

好用密技EXCEL_快速填入_測試與分享

LHB阿好伯, 2020/01/18

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

tags: Excel

今天在Dcard中學到了一個以前都不知道的技巧

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

在測試後分享我對這功能的一些心得

格式上會遇到一些例如日期與數字上的問題

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

測試後最快解決方式是先打加上一個單引號 '

單引號作用是將儲存格強制為文字格式

避免數字或日期格式問題

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

合併上也可以利用欄號作為依據

部份情況來說更加明瞭簡短

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

反過來拆分也可以利用一樣的方式

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

或是複合方式

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

然而若是要加密可能會有點問題

測試後不可否認功能分常強大

還是有一些缺點

像是原始資料資料有變動時

可能需要刪除原先設定好的地方在執行一次快速填入

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

判斷依據無法跨頁使用甚至是空一行就沒辦法了

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

以上就是測試後的心得

希望能幫助大家更好的掌握快速填入的功能

全文分享至

https://www.facebook.com/LHB0222/

有疑問想討論的都歡迎於下方留言

喜歡的幫我分享給所有的朋友 \o/

有所錯誤歡迎指教

Image Not Showing Possible Reasons
  • The image file may be corrupted
  • The server hosting the image is unavailable
  • The image path is incorrect
  • The image format is not supported
Learn More →

Last changed by 
 
阿好伯
分享自身所學到的一些東西 規劃主題應為6大類 1.Excel 2.統計軟體_R_SPSS 3.其他軟體使用心得 4.專業知識紀錄 5.好書分享 6.生活記事 希望有人喜歡，也幫助到更多人
0
792

Read more

R語言常用好用套件紀錄

hackmd-github-sync-badge

Apr 15, 2025
一圖勝千表_數據可視化_基本圖表篇

[color=#40f1ef][name=LHB阿好伯, Jan 26, 2019 10:05 PM]:earth_africa:

Apr 7, 2025
Raspberry Pi網路攝像機_實物投影機

[color=#40f1ef][name=LHB阿好伯, 2021/07/16]:earth_africa:

Mar 11, 2025
Ntfy介紹_自行架設及使用說明

[color=#40f1ef][name=LHB阿好伯, 2024/10/22]:earth_africa:

Jan 23, 2025
Read more from 阿好伯
Published on HackMD