Showing posts with label workbook. Show all posts
Showing posts with label workbook. Show all posts

Monday, March 05, 2007

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.

Wednesday, February 14, 2007

Hide or unhide a workbook

How to hide a workbook?
How to unhide a workbook?

To hide a workbook,

  • Goto Window->Hide
To unhide a workbook,
  • Goto Window->Unhide
If you have more that one worksheet hidden, then the list of all workbooks hidden would be displayed, from which you may select the workbook you want to unhide.

Note:
Always unhide a worksheet when you quit Microsoft Excel. This is because if you start Microsoft Excel, the next time again, and open the file (workbook) you have hidden, you may not see it. Of course, you can unhide it from the window menu but it is preferred to unhide a workbook before closing it.