Hey, welcome back to the Mr. Excel in Podcast. I’m Bill Jelen and you know since this is the first year I’m in the resolution that I’m just going to use Excel 2007. I read lots of books about Excel 2007, but it was not always my first choice. I’ve been done many part of guest as you know using Excel 2003.
How is that if we talk about Jim’s question about how to consolidate that date and you know you after kind of reflecting that and what’s driving me insane about the new Excel. The one thing is when I need to sort data, so I want to sort by A to Z you know I keep heading up to where A to Z used to be in Excel 2003. And as prospering that, we don’t have an A to Z buttons here. We have to open sort and filter choose small to large resulted two click process now or click on data and then click on A to Z it’s kind to work. It used to be.
I want to be easier if we just had one click access to this, and when you start to find this commands in Excel 2007 you really wish you had access to it all the time or that’s when we use the quick access tool bar now. The quick access tool bar by default starts out above the ribbon. It starts up right here we save, undo and redo and its kind tie when it only has three icons and really it only has room for about 20 icons before you get the title of spreadsheet. So I will right click that and say short below the ribbon back in closer to the spreadsheet and also it gets me room for about 44 icons going across on a 10, 24 monitor if you have one of those nice 14 inch you could probably fit 10,000 icons going across. So when I see an icon that I want to have access to all the time for example the A to Z or Z to A very simple just right click it and say add the quick access tool bar. Now I did it also for the other one I have to quick access tool bar, so we have both those there.
Now if I need to sort data. If I need to sort this by orders just choose one cell anywhere I feel that I can go, click to Z or A or A to Z and I will access to it all the time, so as you’re making the transition from Excel 2003 to 2007. You find these commands that you really wish that you had on the home tab, but they are not there just find them even if they’re behind. And it’s something that you can right click and say that you want to add that to the quick access tool bar that you have a nice easy strip there.
Actually, I am not recommending this but if you get all of your favorite commands you can then right click and say minimize the ribbon I just can’t rid of the ribbon and use the quick access tool bar all the time. Again, it’s not something I’m recommending, but if you want to go that way feel free. All right, well this week we talked about four different ways to solve Jim’s problem of data on different work sheets. If you have a different way, please feel free to drop me a note at Bill at MrExcel.com, and we’ll talk about your method and a future podcast
Thanks for stopping by we’ll see you next time for another net cast from Mr. Excel.
Transcription by:
Scribe4you Transcription Services