Prevent duplicates before they happen by combining a simple function with data validation. We may earn from vendors via affiliate links or sponsorships. This might affect product placement on our site ...

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

Excel’s data validation feature is more versatile than you might think. Learn how to use literal values, input values, list values, and even formulas to restrict input date values using data ...

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

This chapter shows you how to upload and download workbooks to and from the Windows SkyDrive. This chapter will help you get started working on and sharing your Excel files online. For a more in-depth ...

Microsoft has added some new cut and paste improvements for people that access the Excel spreadsheet app on the web, including some new ways to drag and drop data in rows or columns. Microsoft is ...

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