Options

In 2007 this tab was called "popular" and this group was called "top options for working with Excel".


 

Show mini toolbar on selection - Displays the mini toolbar when you have text selected to provide you with quick access to useful formatting tools.
Show Quick Analysis options on selection - (Added in 2013). Displays the Quick Analysis Smart Tag when you make a cell selection. This provides you with quick access to the following shortcuts: Formatting, Charts, Totals, Tables and Sparklines.
Enable live preview - Displays a preview of how a feature or certain formatting with affect your workbook when you hover it with the mouse.
Always use cleartype - (Removed in 2013). Excel 2007 was optimised to use ClearType fonts. ClearType fonts make text easier to read. This setting is shared among all your Microsoft Office applications.
Color scheme - The default colour scheme is blue although depending on your personal preference there are also grey and black colour schemes available.
Screentip style - Select a style from the list to control the display of the names of buttons and additional helpful information. Select Show feature descriptions in ScreenTips for names and helpful information, select Don't show feature descriptions in ScreenTips for button names only, or select Don't show ScreenTips for neither.
Show developer tab in the Ribbon - (Moved in 2010). This has moved to the Customise Ribbon tab. To toggle the display of the Developer tab tick or untick the box next to Developer in the list on the right hand side. Displays the Developer tab by default when you open Excel. This is a general setting across all your Microsoft Office applications.
Create lists for use in sorts and fill sequences - (Moved in 2010). This has moved to the Advanced tab. It can be found under the heading "General".


When creating new workbooks


 

Use this as the default font - This is the font used when you create a new workbook. The default is Body Font that refers to Microsoft Calibri ("Use this font" in 2010).
Font size - This is the default font size when you create a new workbook.
Default view for new sheets - This is the default view when you create a new workbook. There is a choice of Normal, Page Break Preview or Page Layout.
Include this many sheets - This is the default number of worksheets when you create a new workbook. This defaults to 3 but can be any number between 1 and 255.


Personalise your copy of Microsoft Office


 

User name - Entering your full name will allow your name to be automatically saved in any workbooks that you create. This is shared among all your Microsoft Office applications.
Choose language you want to use with Microsoft Office - (Moved in 2010).
Always use these values regardless of sign in to Office - (Added in 2013).
Office background - (Added in 2013). Lets you change the pattern that appears above the ribbon. This drop-down contains the following: No Background, Calligraphy, Circles and Stripes, Circuit, Clouds, Doodle Circles, Doodle Diamonds, Geometry, Lunchbox, School Supplies, Spring, Stars, Straws, Tree Rings and Underwater. The default is Clouds. This is shared among all your Microsoft Office applications.
Office theme - (Added in 2013). Lets you change the tint option that is applied to the background and borders of the ribbon and row and column headings. The drop-down contans the following: White, Light Gray and Dark Gray. This is shared among all your Microsoft Office applications.


Startup Options


 

Choose the extensions you want Excel to open by default - (Added in 2013). Pressing Default Programs opens the "Set Associates for Program" dialog box. This lets you choose which file extensions you want associated with this program. Once associated double clicking this type of file will open it in this program.
Tell me if Microsoft Excel isn't the default program for viewing and editing spreadsheets - (Added in 2013). If there is a different program (or viewer) installed for editing spreadsheets then display a message.
Show the start screen when this application starts - (Added in 2013). Displays the start screen every time Excel opens.


© 2017 Better Solutions Limited. All Rights Reserved. © 2017 Better Solutions Limited

Top

Next