Setting up custom views for quick access to different worksheet displays

- This worksheet shows a lot of budget detail.…And frequently when I work with it,…or make presentations with it,…I don't want to show all this data.…But I don't necessarily want to be showing people…how to hide and un-hide columns and rows.…I want quick access to different views of this worksheet.…That can be referred to as a custom view,…and there's a feature on the View tab called Custom Views.…Let's say that often I want that look…of just showing the quarters here.…I'm going to drag across columns B, C and D,…letting go with the left mouse button now…and holding down the Control key.…

And now using the left mouse button again…to select columns F, G and H,…and then J, K and L, N, O, P,…right-click and Hide.…And let's say that often…when I'm showing this amount of detail…I don't need to show the Expense detail,…so I'll drag across rows 17 through 32,…right-click and Hide.…And I'll zoom in also here.…There we are.…So, I like this view.…I want to be able to get to this quickly…and easily at any time.…

View tab, Custom Views, add a view.…