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 ...

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 ...

How to run a VBA procedure from a data validation control in Microsoft Excel Your email has been sent There are lots of ways to execute a VBA procedure in Microsoft Excel. You can add macro buttons at ...

Microsoft Office 2013, formally unveiled on Monday, embraces the cloud more fully than any previous version of the age-old productivity suite. We’ve already examined the desktop versions of the ...

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 today announced that it is bringing support for linking data from multiple online workbooks for Excel on the web. However, the files must be stored in OneDrive or SharePoint. Microsoft today ...

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 ...