Susan Harkins shows you a quick method for removing validation rules for multiple ranges in Excel, at the same time.

Now, click on the Data Type button and then select Text. In the Change Column Type prompt, click the Replace current button and let Excel convert the selected column data format to text.

Removing hidden metadata information from a Microsoft Excel spreadsheet is not difficult if you follow the steps laid out here.

Microsoft Excel: How to Remove a Drop-Down List. Excel's drop-down menus are useful for creating order forms and navigation for larger files like records of sales.

You can convert text in Excel to linked data types. This is referred to as “linked” data types because the data is connected to an online data source.

In addition to the new data types, Microsoft has updated Excel Online with some highly requested features from Excel desktop. Excel Online will now allow you to insert Pivot Tables and delete rows ...