excel hyperlink
跳至儲存格位置
使用HYPERLINK函數，輸入公式「=HYPERLINK(“#工作表名稱!儲存格位置”,”顯示文字”)」，將範例代入「=HYPERLINK(“#工作表3!A1048576″,”跳到最後一行”)，「1048576」是工作表中最底
前往網址
輸入公式「=HYPERLINK(“網址”,”顯示文字”)」，以範例代入「=HYPERLINK(“https://google.com”,”前往GOOGLE”)」
開啟檔案
Step 1 先在檔案點擊滑鼠「右鍵」，選擇「複製路徑」
Step 2 輸入公式「=HYPERLINK(“檔案路徑”,”顯示文字”)」，將檔案路徑貼上Step 1 複製的路徑，將範例代入「=HYPERLINK(“C:\Users\aa097\Desktop\萬年曆.xlsx”,”開啟萬年曆檔案”)」
【教學】Excel 如何使用 HYPERLINK？想開啟網頁、檔案跳至任何儲存格都可以！
0
Hi there! I realize this is sort of off-topic but I needed to ask.
Does running a well-established blog like yours take a massive amount work?
I’m brand new to operating a blog but I do write in my journal daily.
I’d like to start a blog so I can easily share my
personal experience and views online. Please
let me know if you have any ideas or tips for brand new aspiring bloggers.
Thankyou!
Hello, it’s not necessary.
With just a little bit of your free time, you can create a great blog.
Looking forward to seeing your articles in the future.
Thank you.