JavaScript isn't replacing Office macros anytime soon, but the Office Web apps (and the SharePoint-based enterprise equivalents) are improving regularly. For users that means simple but useful ...

Whether you want to restrict data inputs, ensure consistency, or avoid errors, data validation in Microsoft Excel is the tool for you. It can also serve as a vital safety net if you plan to share your ...

Data validation in Excel lets you restrict what can be entered into a cell, whether whole numbers, decimals, dates, or a certain number of characters. However, one of the most powerful capabilities of ...

Drop-down lists in an Excel sheet can greatly facilitate data entry. Here's a look at how to use Microsoft Excel's data validation feature to create handy lists within your worksheets. An Excel ...

Microsoft announced an update to its Office Web apps, focusing on collaboration between coworkers, as well as bringing new features over from its Office software package. The idea is to “make it ...

This morning, Microsoft opened the tech preview of its long-anticipated Office Web Apps. Here’s a first look at what the online version of Excel has in store. From the online SkyDrive folders, you can ...

Microsoft has announced that it has added a feature to the Excel web app that will let it export its spreadsheets in the CSV file format like it can with the Windows and Mac versions. Microsoft ...

How to use UNIQUE() to populate a dropdown in Microsoft Excel Your email has been sent Populating a dropdown with a dynamic list is easy thanks to Microsoft Excel’s UNIQUE() dynamic array function.