2023/07/06

Excel 下方的分頁頁籤不見了

 EXCEL檔案不同的分頁,通常都在左下方可以做點選切換。

但某些檔案明明就有多個分頁,但下方卻都沒東西,無法切換。

這是設定的問題,只要在進階的設定裡,找到 顯示工作表索引標籤,將此功能打勾就會正常顯示其他分頁了。





Different worksheets in an Excel file are usually switchable by clicking on the tabs located at the bottom left.
However, in some cases, even though a file has multiple worksheets, there is no content displayed at the bottom, and switching between them is not possible.
This is a configuration issue. By going into the advanced settings and enabling the "Show sheet tabs" option, the other worksheets will be displayed correctly.

沒有留言:

張貼留言