 
|
Cascading lists and kangaroos? Today, Ed Ferrero shares his technique for creating dependent data validation drop downs, based on pivot tables. Ed's from Australia, and it looks like we'll learn a bit about his country too, as we go through his sample file. Dependent Data Validation We've created dependent data validation drop downs [...] Don't get too close to this blog today – I've got a miserable cold, and wouldn't want you to catch it! Roger Govier has created an Excel file to track your medical treatments, for people who have varying dosages or injection sites. It won't help me feel better, but it might help you, or [...] Yes, if your last name is Dalgleish, some people think it sounds like "Dog Leash", and hilarity ensues. And no, I never get tired of that joke, thanks for asking. ;-) Anyway, unlike the proverbial old dog, those of us who have been using Excel for a long can CAN learn new tricks. Keep reading [...] Male or female? English or French? Yes, No or Maybe? Those are just a few of the choices that you can make with Option Buttons in Excel. With Option Buttons, you can provide a list of possible answers to a questions, and users can only select one answer from the list. You can [...] This article was going to be about sorting in Excel, because Jim Cone just sent me the latest version of his Special Sort add-in. So, I hauled one of the big, dusty Excel books off my shelf, to see if there were any scintillating sorting secrets to uncover. Under Sorting, I saw "rank calculations" [...] When you use an Excel AutoFilter to filter a list, usually the count of visible records appears in the Status Bar, at the bottom left of the Excel window. (Note: If the Status Bar shows Filter Mode, instead of the record count, you can use one of the workarounds shown here – Status Bar [...] Sometime in the 1840s, probably because of the famine, my dad's ancestors left Ireland, and boarded a ship to Canada. The details are sketchy, but I'm sure they had first class accommodations, and sat at the Captain's table every night. So, in honour of those ancestors, and to celebrate St. Patrick's Day, I've made [...] How can you make it easy for people to enter and edit data in Excel, but keep them away from the data storage worksheet? Last year, I posted a Worksheet Data Entry Form in Excel, where users could enter and view Excel data. It was based on a worksheet data entry form that Dave Peterson [...] An Excel workbook certainly isn't Fort Knox, and the information you store there isn't too secure. If someone opens your Excel workbook, and is determined to see everything in there, they'll probably be able to. However, if your goal is simply to make a workbook easier for people to use, you can hide some of [...] You know how to sort an Excel list alphabetically, and with Excel 2007 you can even sort an Excel list by colour. Did you know that you can also create a custom list in Excel and use that to sort your data, instead of sorting in alphabetical or numerical order? Instead of sorting the products [...]  |
|
|
Copyright © 2012 Contextures Blog - All Rights Reserved |
||
