Default workbook

Default workbook in Microsoft Excel

By default, Microsoft Excel (all versions) creates a workbook when you start Microsoft Excel. The name of the workbook is usually Book1. If you open multiple instances of Microsoft Excel, then each of the instance would open a new workbook. The number of worksheets in the workbook depend on the option set for the number of worksheets in the default options.

Microsoft Excel doesn't open a default workbook under the following circumstances,

1. When you open a file from START->DOCUMENTS.
2. When you open a file from Windows Explorer.
3. When you download and open a file from a web browser.
4. When Microsoft Excel is set to open a default workbook when it starts.
5. When any file is stored in the XLSTART folder.

There may also other circumstances where Microsoft Excel may not open a workbook. If you experienced such circumstances, you may post in the comments section.
There seems to be no way from making Microsoft Excel not open a workbook when it starts. If you have an idea, you may post it.

Full screen

How to maximize the screen capacity in Microsoft Excel?
How to view full screen in Microsoft Excel?
How to turn off full screen in Microsoft Excel?

Full screen is an option in Microsoft Excel, whereby you could hide all the tool bars and maximize the viewing capacity. This would especially be useful if you are to type in a large amount of data or the nature of your work don't need tool bars for a wrong time

To turn on FULL SCREEN, Go to VIEW menu and click FULL SCREEN.
To turn on FULL SCREEN, just repeat the step since the Full screen button is a toggle button.

By default, FULL SCREEN is turned off in Microsoft Excel.

When you use the Full screen option for the first time, you would see a new tool bar with the name CLOSE FULL SCREEN. Close this tool bar (To close it, click the X on the right) . Don't click the CLOSE FULL SCREEN button since it would turn off the full screen.

The full screen options removes the tool bars, status bar and the formula bar. Full screen doesn't mean that you could not have your tool bars. You can always have your favorite tool bar by selecting it from the view menu

Tool tips

What are tool tips?
How to disable tool tips in Microsoft Excel?
How to enable tool tips in Microsoft Excel?

Definition
Tool tips are small graphical interfaces that shows up text (rarely images) when the mouse pointers hover them. Tool tips show a box with text when you hover the mouse on them. Tool tips provide important information and they are quite useful in giving us quick information about a tool bar or a command without activating them. It must be noted that tool tips just show information and do not activate a command nor they trigger any action. Tool tips often instruct on the command name or give a brief description about the action a command would trigger if it is clicked.Just move around your mouse on the tool bars to have a look at the tool tips

Tool tips in Microsoft Excel (and almost all other applications) show a short description of what the tool bars would do when clicked. Descriptions such as New,Open, Save indicate that clicking the button would create a new file, open a file, save a file. In fact, they provide quick reference to the actions that would be performed by the tool bar buttons.

To enable tool tips in Microsoft Excel (and almost all other applications)

• RIGHT CLICK on the Worksheet Menu Bar (The menu bar at the top containing File, Edit, View menus)
• Select CUSTOMIZE and select the OPTIONS tab
• Now check the SHOW SCREEN TIPS ON TOOL BARS option.
  
• Close the dialog box using the CLOSE button

By default, tool tips are enabled in Microsoft Excel unless you disable it. Most users don't disable it as it is quite useful and provides quick handy information.

To disable tool tips just follow the above steps and uncheck the SHOW SCREEN TIPS ON TOOL BARS option.

Step by step instruction

• RIGHT CLICK on the Worksheet Menu Bar (The menu bar at the top containing File, Edit, View menus)
• Select CUSTOMIZE and select the OPTIONS tab
• Now check the SHOW SCREEN TIPS ON TOOL BARS option.
  
• Close the dialog box using the CLOSE button.
  

Gridlines

What are grid lines?
My grid lines are gone. Where can I find them?
How to change the color of the grid lines?


Grid lines are horizontal and vertical lines found in Microsoft Excel. They are just like graph lines.

By default, grid lines are on in Microsoft Excel. To turn them off,

• Goto TOOLS->OPTIONS->VIEW
• Uncheck the GRID LINES box.
• Click OK
  

To turn them on,

• Goto TOOLS->OPTIONS->VIEW
• Check the GRID LINES box.
• Click OK
  

To change the grid lines color,

• Goto TOOLS->OPTIONS->VIEW
• Next to GRIDLINES COLOR box, select your color.
• Click OK.

Default Font size

What is the default font size in Microsoft Excel?
How to change the default font size in Microsoft Excel?

The default font size in Microsoft Excel is 10 points (all Excel versions)
The minimum font size is 1 point and the maximum font size is 409 points.

Know more about font size here

To change the default font size,

• Go to TOOLS->OPTIONS
• Select the GENERAL tab
• Change the FONT SIZE in the SIZE box. (This would be located to the right of the Standard Font box.

To know how to change the default font,click here

Also see,
True type font
Install a font

Default Font

What is the default font in Microsoft Excel?
How to change the default font in Microsoft Excel?

The default font in Microsoft Excel is Arial (all Excel versions)
The fonts displayed in Microsoft Excel is limited by the fonts available in the system.
We recommend reading this post for more


To change the default font size,

• Go to TOOLS->OPTIONS
• Select the GENERAL tab
• Select you FONT from the STANDARD FONT drop down box. (The standard font box would display the list of all fonts available in the Windows folder)

To know how to change the default font size,click here

Also see,
True type font

Default number of worksheets

What is the default number of worksheets in Microsoft Excel?
How many worksheets can I have in Microsoft Excel?

The default number of worksheets in a workbook is three (3).
You can have a maximum of two hundred and fifty five worksheets(255) in a workbook (though the same is limited by the available amounot of memory in your computer. Anyway, you cannot have more than 255 worksheets)

Thus, when you create a new file in Microsoft Excel, it would have three worksheets. To change the default number of worksheets when you create a new workbook,

• Goto TOOLS->OPTIONS
  
• Select the GENERAL tab
• Under the SHEETS IN NEW WORKBOOK option, change the number of worksheets you want to have in a new workbook.
• Click OK

The next time you create a new workbook you would have your choice of worksheets.

Note:
If you have changed the default option in Microsoft Excel, for your changes to take effect, you must restart Microsoft Excel.
This does not apply to workbooks already created.

Default definition

What is a default option?

In computer science , the word Default refers to a setting or value automatically assigned to a computer program or device, outside of user intervention. In other words, this is the original setting as done by the software manufacturers.

To quote an example, when you run an application for the first time after installing it, you would see the menus, fonts, layout, print settings and options in a standard format. These are called the default options. We can customize either whole or part of these options. This depends on the application we are working upon. Some applications give you the option to wholly customize the option while others doesn't.