From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Setting up custom views for quick access to different worksheet displays

Setting up custom views for quick access to different worksheet displays - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Setting up custom views for quick access to different worksheet displays

- [Instructor] This worksheet shows a lot of budget detail. 2 And frequently, when I work with it 3 or make presentations with it, 4 I don't want to show all this data, 5 but I don't necessarily want to be showing people 6 how to hide and unhide columns and rows. 7 I want quick access to different views of this worksheet. 8 That can be referred to as a Custom View, 9 and there's a feature on the View tab called Custom Views. 10 Let's say that often, 11 I want that look of just showing the quarters here. 12 I'm going to drag across columns B, C, and D, 13 letting go of the left mouse button now 14 and holding down the Control key. 15 And now, using the left mouse button again 16 to select columns F, G, and H, 17 and then J, K, and L, 18 N, O, P. 19 Right-click and Hide. 20 And let's say that often, 21 when I'm showing this amount of detail, 22 I don't need to show the expense detail. 23 So, I'll drag across rows 17…

Contents