From the course: Excel 2010 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Creating multiple custom worksheet views

Creating multiple custom worksheet views - Microsoft Excel Tutorial

From the course: Excel 2010 Essential Training

Start my 1-month free trial

Creating multiple custom worksheet views

“

When you frequently have to get around to different areas of a large worksheet, all the shortcuts in the world still might not be easy enough or fast enough. So Excel has a really great feature called views, and you can define different areas of the sheet, even different zoom amounts as named views and then quickly hop from one view to another and thereby hop from one part of the worksheet to another. So let's take a look at how we do that. Let's click on the View tab, and over here click Custom Views, and this brings up the Custom Views dialog box. My advice is before scrolling and zooming and whatnot, you should create a custom view that is the normal view of the worksheet. That is right now we are scrolled all the way to the top. We scroll to the left. You can see down here we are at 100%. So click Add, and we will give the view a name of Normal. Here you could call it Default whatever you like. Click OK. Now go back to Custom Views, you see the there it is. I will just close out…

Contents