I stopped doing these 5 things in Excel—and my spreadsheets became more reliable

Cleaner data, better formatting, and fewer hidden assumptions have made my Excel workbooks much easier to manage.

I stopped doing these 5 things in Excel—and my spreadsheets became more reliable

I've spent a frankly unreasonable amount of time in Excel, so I've had plenty of opportunities to find out which habits make my life easier—and which ones come back to haunt me later. Over the years, I've gradually ditched a handful of things that seemed harmless at the time but made my spreadsheets harder to sort, filter, update, or understand. Here are five things I stopped doing in Excel, and why my spreadsheets have become much more reliable as a result.