课程: Learning Excel Online (Microsoft 365)

今天就学习课程吧！

今天就开通帐号，24,600 门业界名师课程任您挑！

Eliminate headaches with Freeze Panes

Eliminate headaches with Freeze Panes

课程: Learning Excel Online (Microsoft 365)

开始一个月试用 购买团队方案

Eliminate headaches with Freeze Panes

“

- [Instructor] Working with the exercise file for this movie, you'll notice on the company data tab that the last few rows are starting to get towards the bottom of the viewable area. And in fact, depending on your screen resolution and the size of your screen, the last few rows may even appear off the bottom of the viewable area. Have a look at what happens if we scroll down to the end of the data range. You'll notice that we can't see our column headings anymore, but that's okay. A neat way to overcome this is using a feature called freeze panes. Make sure that you're back at the top of the viewable area once more, and select all of row three. Next, go to the view menu. Click on the dropdown box next to freeze panes, and then select freeze panes once more. Have a look at what happens now if we scroll down. The data at the end of our range is viewable, and so to are the column headings. This makes navigating through our…

内容