How to Clear All in a Worksheet

– How to Clear All Formats in a Worksheet
– How to Clear All Comments in a Worksheet
– How to Clear All Hyperlinks in a Worksheet

Please follow the steps below to clear all in a worksheet:

Step 1: Select the whole worksheet by clicking the top left corner;

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

Step 3: Click "Clear" in "Editing" section and click " Clear All";

Step 4: This is to remove all contents including formatting, commends and links in the worksheet.