跳到主要內容

在Excel中輕鬆讀取/查看大量行和列

作者:小陽 最後修改時間:2023-08-16

Excel的Kutools

提升 Excel 300+
強大的功能

如果您處理的工作表包含數百行和數百列的大量數據,那麼在檢查數據並將數據從一個數據跳到另一個數據時,您可能很容易感到困惑,這會浪費時間。為了解決這個問題,Kutools for Excel 的網格焦點實用程式會反白顯示跨行和列,以使活動儲存格或範圍突出顯示,如下圖所示。 演示

鏡頭閱讀版式2


啟用網格焦點實用程序

點擊 庫工具 > 網格焦點 要啟用此實用程序,在啟用網格焦點時,該選項卡會突出顯示。
鏡頭閱讀版式2


網格焦點設置

如果要更改形狀,樣式,顏色或透明度等設置,則可以轉到 網格焦點設置對話框更改。

點擊 庫工具 標籤,然後單擊旁邊的箭頭 網格焦點 展開下拉菜單,然後單擊 網格焦點設置.
鏡頭閱讀版式2

網格焦點設置 對話框中,您可以根據需要更改形狀,樣式,顏色和透明度,也可以同時預覽 預覽 部分,然後再應用更改。
鏡頭閱讀版式2

關於 突出顯示活動單元格區域突出顯示單元格編輯區域 選項。

突出顯示活動單元格區域 選項,活動單元格或範圍將突出顯示。

鏡頭閱讀版式2

打鉤 突出顯示活動單元格區域 選項,但勾選 突出顯示單元格編輯區域 選項,活動單元格或範圍將不突出顯示,但溢出區域突出顯示。

鏡頭閱讀版式2

取消勾選兩個 突出顯示活動單元格區域突出顯示單元格編輯區域 選項,活動單元格或範圍以及溢出區域均不會突出顯示。

鏡頭閱讀版式2

啟用網格焦點:在設置後勾選此選項,然後單擊 OK,網格焦點將自動啟用。

默認設置:點擊該按鈕,網格焦點設置恢復為默認設置 庫工具.


注意:

1.您可以通過單擊 網格焦點 命令,選項卡將變為淺灰色。

2.如果您打開多個Excel文件,則此 網格焦點 功能適用於所有這些。

3。 此 網格焦點 下次啟動工作簿時不會自動啟用。

網格焦點演示


Excel的Kutools:超過 300 個方便的工具觸手可及! 立即開始 30 天免費試用,沒有任何功能限制。 現在就下載!

    生產力工具推薦
    以下工具可以極大地節省您的時間和金錢,哪一種適合您?
    Office Tab: 在辦公室中使用方便的選項卡,作為Chrome,Firefox和New Internet Explorer的方式。
    Excel的Kutools: 超過300種Excel高級功能 2021、2019、2016、2013、2010、2007 和 Office 365。

    Excel的Kutools

    上述功能只是Kutools for Excel的300個強大功能之一。

    專為 Excel(Office) 2021、2019、2016、2013、2010、2007 和 Office 365 設計。免費下載和使用 30 天。

    Kutools for Excel的屏幕截圖

    btn了解更多      btn下載     btn購買

Comments (17)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Why doesn't it open automatically at startup? it would be nice to remember the last setting
This comment was minimized by the moderator on the site
Hello, Mennan,
Sorry for the inconvenience, for the stability of the function, our feature is disabled when opening next time at present, but the last setting and operation can be remembered.
Thanks for your comment.
This comment was minimized by the moderator on the site
I have a problem with the reading layout. Every time when I start it, it behaves strangely. It "chose" a smaller size of the sheet than it is actually on my screen and it works in that sheet. Eg: if I see on my screen columns range from A up to AC and rows range from 1 up to 39, the reading layout chooses that my columns range from A up to half of X and rows range from 1 up to half of 32 and works in that let's call it window.
I tried to uninstall kutools and install it again, but the same problem remains.
Any wise advice would be appreciated from my side.
I am running MS office professional plus 2021.

Thanks in advance
This comment was minimized by the moderator on the site
I might detected the problem. I am running 3 displays, one from a laptop 15,6" and two others 24" over wavlink dock. All three displays are running at a resolution of 1920 x 1080. My main display is from the laptop.
I am using excel on another two 24" displays just because they have a bigger screen. When I put excel on the laptop window reading layout behaves as it should, and that is the exact size of the sheet that I previously described as a smaller window.
This comment was minimized by the moderator on the site
Hello, Dejan,
Thanks for your comment.
I have fed back this problem to the developers, if there is a an upgrade or fixed, we will let you know in the first time.
This comment was minimized by the moderator on the site
If you make this auto load when opening excel I will buy this product. :D
This comment was minimized by the moderator on the site
Hi, Andrei

Thanks for your comment, your suggestion has been fed back to the developers, if there's an upgrade, I'll let you know in the first time. 😄
This comment was minimized by the moderator on the site
Very Good Service Nice blog
This comment was minimized by the moderator on the site
Hello, Thanks for sharing this informative blog with us.
There are no comments posted here yet
Load More
Leave your comments
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations