Hello All

I have an xls file containing around 400 sheets, which I will be splitting into individual files.

However, before I do this, I would like to delete everything except columns A-E in every sheet to clean them up a bit.

I have found various ways of deleting the same thing from multiple sheets in a workbook, but is there a way of simply keeping only columns A-E in every sheet, and clearing everything else?

Your help will be greatly appreciated!

(I am using Excel for Mac)