Note: This article is also available in the free PDF Make Office 2016 work your way by changing these default settings. There’s no downloadable demonstration file, and you can’t make these changes in the browser edition. I’m using Excel 2016 (desktop), but these options are customizable in earlier versions. How to return first and last times from timestamps in Microsoft ExcelĬhecklist: Microsoft 365 app and services deployments on Macs Get Microsoft Office Pro and lifetime access to 5 top apps for $59.99

In this article, I’ll share 10 default settings you might want to change. Instead, modify these settings so that each new workbook opens configured to your liking. Changing those settings every time you start a new workbook can be a blow to productivity if you do it often. Image: iStock/DragonImagesĮxcel, like Word, has an out-of-the-box environment that might not provide the most efficient setup for the way you work. 10 defaults you can change to make Excel 2016 work your wayīy changing a few settings, you can configure all new workbooks to automatically conform to the way you work.

Tools menu in excel 2016