How to Close All Excel Files at Once. When you're working on multiple spreadsheets at a time in Microsoft Excel, closing them all one by one is wasted time you could have spent on another task.