How Can you Use Excel Custom Views?
That Custom Views button
The Custom Views button has been kicking around Excel for aeons of time. However, it's not used as often as it should.
Why Custom Views?
Too often users of Excel have scaled the walls of searching for that precise place on a spreadsheet then to travel to another place on a spreadsheet only to return back to their starting point. The worst of it is that it takes ages. You know you've been there, dragging those infernal scrollbars or if you have a fancy mouse you might have worked out a way to speed things up.
In this tutorial you will learn:
- Create a Custom View
- Add Custom Views to the Quick Access Toolbar
- Freeze Rows
- Hide Sheets with Custom Views
The exercise file that goes with the above tutorial.