User name Type a name in the User name box to change your displayed user name. If you know that you'd like your workbooks to start with more sheets than that, adjust this setting. Include this many sheets: By default new workbooks in Excel start with just 1 sheet. The fourth setting bears just a bit more explanation: The third setting in this group lets you specify the default view, in case you prefer something other than Normal. The first two settings in this group control the default font, and font size, that will be used when you create a new workbook. ScreenTip style Select a style to control whether the program displays ScreenTips and feature descriptions with button names. This is what lets you hover over a formatting option on the ribbon and see how the change would appear without actually having to click to apply that change. For more information see Analyze your data instantly.Įnable Live Preview Select this option to preview the effects of formatting changes in the document before you actually apply them.

(Excel-only) Show Quick Analysis options on selection When you select a cell or group of cells Excel can show you tools to let you get quick insights about your data.

The Mini toolbar provides quick access to formatting tools. Show Mini Toolbar on selection Select this option to show the Mini toolbar when you select text. For more information see Office support for high definition displays.

When using multiple displays: Generally speaking you should leave this set to Optimize for best appearance but if you're having odd display behavior on your multi-monitor setup, you can try Optimize for compatibility to see if that resolves the problems. The options on this tab vary a bit depending on the Office program and version you're using. To see general options for working with your Office applications on Windows, click File > Options > General. Excel for Microsoft 365 PowerPoint for Microsoft 365 Publisher for Microsoft 365 Excel 2021 PowerPoint 2021 Publisher 2021 Excel 2019 PowerPoint 2019 Publisher 2019 Excel 2016 PowerPoint 2016 Publisher 2016 Excel 2013 PowerPoint 2013 Publisher 2013 Excel 2010 Outlook 2010 PowerPoint 2010 Publisher 2010 Excel Starter 2010 More.

Where is the options tab in excel