Learn how to create a drop-down list using Data Validation in Excel. Data Validation limits the type of data that can be entered into a cell.

If you've ever wanted to leverage the power of Data Validation in Excel combined with the flexibility of Web Excel, now you can! In this post we walk through an example of how easy it is to collect ...

Advanced list solutions are easy thanks to Excel's Table object. If you need a dynamic list, try one of these techniques.

Add data validation to Excel ranges The Excel JavaScript Library provides APIs to enable your add-in to add automatic data validation to tables, columns, rows, and other ranges in a workbook. To ...

Automated Data Entry in Excel. One way businesses can save time and money is using Excel spreadsheets as data tables in which to store customer information, inventory details or other important data.

Microsoft announced this week that's it's now possible for Office 365 users to import table data from Adobe Portable Document Format (PDF) files into the Microsoft Excel spreadsheet program.

Creating a Microsoft SharePoint list from Microsoft Excel data is safer than sharing the entire Excel workbook.