Another way to solve the problem from podcast 881 is to create a pair of custom views. Episode 882 will discuss how you can quickly hide/unhide columns by us...
Transcript of the video:
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen. Just a quick reminder: I'm asking everyone to fill out a quick survey coming up on the 10th year anniversary of MrExcel. I want to try and figure out what kinds of things we should do in the next 10 years. If you go to MrExcel.com/survey.html, should take you about two to three minutes just to give us some advice of where we should go, get your ideas of what we should do with the site. It'll be live for another week or so and we'd like you to go out there, just give us some feedback.
Yesterday, we had a question. Tom from Cincinnati asked how we could make a chart that showed either quarters or months. And in my solution, using group and outline buttons, basically it showed either the quarters which-- was perfect-- or months and quarters. And I'm not sure I'd like to see months and quarters; I think I just want to see months. And so I'm going to propose a different solution here.
The first thing I'm going to do is hide the quarterly column. So Format, Column, Hide, and then I'll press F4 to do that again for the other quarterly columns. And so now I have just months, and I'm going to set up a custom view here called months. So if we go to View, Custom Views, and I'm going to add a new view called "Months", click OK. And now I'm going to unhide everything for my column-- Unhide-- and just go through and hide the monthly data. So again, press F4 to redo. Okay, and now I have only the quarter showing, and I'll go to View; Custom Views; and add a new view called "Quarters"; click OK. And so now, you see the chart at the bottom shows quarters; to switch, we just have to go to View, Custom Views, and choose Months, and then Show, and we get a report showing only months.
So this is a different way to set up different columns that were hidden. And then by using the Custom Views feature, very quickly switch back and forth between those-- not as quick as using the Group & Outline button, certainly, but not horrible. Want to go into view-- it's actually Alt+VV, choose the other one, and Show, and you can switch back and forth. So another solution to yesterday's netcast.
Again, remember to go out to survey.html and MrExcel.com and give us your thoughts about where we should go in the next ten years.
And thanks for stopping by, we'll see you tomorrow for another netcast from MrExcel.
Keywords for this video: Microsoft, Excel, business, accounting, spreadsheets, tutorial, technology, MrExcel, Views
This video is current as of January 5, 2009