4] Run a VBA code to remove formatting. You can also use VBA code to remove formatting from Excel. Once you have created the required VBA script, you just need to run it to quickly clear all the ...