:Hiding rows and columns is cumbersome. Try freezing panes.-Table skills免费ppt模版下载-道格办公
投稿
  1. JustNewsHome
  2. Table skills
  3. Hiding rows and columns is cumbersome. Try freezing panes.

Hiding rows and columns is cumbersome. Try freezing panes.

Author: daogeziyuan • • Table skills • Views 790
  • Image and text skills


In daily office work, for the convenience of data processing, sometimes it is necessary to hide some cells.

However, since there is a lot of data and it is cumbersome, you can use frozen panes at this time.


教程分界线.png

￭Suppose we want to hide the cells in the A7:F29 area.

Place the mouse at A7, click View - Freeze Panes - Freeze to the sixth row.

In this way, the cells in the first row to the sixth row will be frozen. By sliding the mouse, the cells in the A7:F29 area will be hidden.


录制_2019_09_09_15_38_53_120.gif



Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/yin-cang-hang-lie-bi-jiao-fan-suo-shi-shi-dong-jie-chuang-ge.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
Lomu 周大大 Columnist
48 196
single-end

Related Suggestion