课程: Excel: Creating Business Budgets

今天就学习课程吧！

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

Customize your layout with Sheet View

Customize your layout with Sheet View - Microsoft Excel教程

课程: Excel: Creating Business Budgets

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

Customize your layout with Sheet View

“

- A neat Excel online feature that you may wish to explore is something called sheet view. Sheet view allows you to create your own customized views and filters without impacting collaborators. So if other users have access to the same workbook, they won't see the changes that you apply. It also allows other users to create their own views without impacting your setup. So with the Excel exercise file open for this chapter, go ahead and navigate to the staff plan worksheet. And from the view menu here, let's go ahead and select new from the sheet view section. The first thing that you'll notice is that the row and column shading has changed to black. And this just simply means that sheet view has been activated. Changes that you now make to the view here won't be visible to other users. So for example, let's go ahead and select cells B four through to O four, then select data, and click on filter. We're about to apply a…

内容