Use the Built-in Data Form in Excel to View and Filter All Fields for a Record

If you want to view all of the fields associated for a single Excel data record, you can use the built-in Data Form. Now, you can see, edit and filter up to 32 fields for a single record in a compact data form. You don’t have to create this data form – Excel builds it automatically. However, if you use Excel 2007 you will need to add the FORM Control to your Quick Access Toolbar. This control is one of the “Commands Not On the Ribbon.” As you will see in the video, I do not recommend entering new records using the Data Form. I prefer to employ data validation using drop-down pick lists and this is not available on a data form. I invite you to visit my online shopping website – shop.thecompanyrocks.com – to view all of my videos and to check out the resources that I offer. Sincerely, Danny Rocks The Company Rocks
Video Rating: 5 / 5