Welcome to MSDN Blogs Sign in | Join | Help

Microsoft Excel 2010

The official blog of the Microsoft Excel product team

Browse by Tags

All Tags » Data Validation   (RSS)
Creating Dynamic Validation Ranges
Today’s author, Dany Hoter, a Product Planner for the Excel team, shares a neat trick he learned recently for creating dynamic data validation ranges. The sample file used for this blog post can be found in the attachments at the bottom of this post. Read More...
Video Tip: Conditional Formatting and Data Validation
Today's author: Sam Radakovitz, a Program Manager on the Excel team that enjoys creating VBA applications in Excel. A bit ago, Joseph had a blog post about community clips on OfficeLabs.com , so for this post, I wanted to take advantage of the video demonstration Read More...
Example file for PivotTable / Data Validation Trick
Recently I posted an article discussing how PivotTables can be used on Excel Services to mimick the Data Validation feature . The author, Dany Hoter, sent me a copy of the file he used in the example screen shots and I never got around to posting it for Read More...
A PivotTable Trick That Brings Data Validation to Excel Services
Today's author: Dany Hoter, a product planner who works on the Excel Services team. Excel has a feature called Data Validation that controls the possible values a user might enter into a cell or a range of cells. As you can see there are many options Read More...
Page view tracker