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.

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.

Microsoft on Thursday leaned more heavily into its support for “data types” within Excel, going beyond the staid concept of numbers and formulas to embrace a huge variety of elements that could reside ...