How to Clear all in a Data Range

– How to Clear the Format only in a Data Range
– How to Clear Contents only in a Data Range
– How to Clear Comments in a Data Range
– How to Clear Hyperlinks in a Data Range
– How to Remove Hyperlinks in a Data Range

Please follow the steps below to clear all in a data range:

Step 1: Select the data range (or the whole worksheet) where you want to clear;

Step 2: Click the "Home" tab in the ribbon;

Step 3: Click "Clear" in the "Editing" section, and select "Clear All" from the drop-down list;

Step 4: All contents, formatting, comments and links are removed.