Understanding and managing Workbook

Before I explain in more detail about what it workbook, you must first know what to do. Below are some tutorials which I will explain in detail to you. Ok we just started.

1. Creating Empty Workbook 
Workbook is a document or workbook in Excel 2007 program consisting of one or more worksheets. When running Excel 2007 for the first time, by default it will be made with a blank workbook Book1 naam. You can also create a new blank workbook in Excel 2007 when the program is running.

• Click the Office button> New, then New Workbook dialog box appears. 
• In the Templates list box, select Blank and recent. Select Blank workbook, and then press the Create button. 
• You can also create a blank workbook faster using the key combination Ctrl + N on keyboard.Maka will look like in the picture below.

2. Save a Workbook 
If you are finished managing data, workbook should be saved so that your work is not lost. You can save a workbook on a variety of storage media such as Hard Disk or USB Flash Disk. By default, workbooks saved Excel workbook file format (*. Xlsx). While supporting many new features, the file format can not be opened in Excel 2003 and earlier versions of Excel. Therefore, some users still prefer to use Excel 97-2003 workbook file format (*. Xlsx). To note if you save the workbook with the XLS file format is not all of the features of Excel 2007 can be used.

• to save the workbook click the Office Button> Save, or press Ctrl + S. Save As dialog box appears.

 

• Select the folder where the workbook. The selected folder will be displayed in the Save in box:
• Type a file name in the File name text box: Select the file format in the Save As type box: If so, press the Save button. 
• If there are changes to the workbook because of the editing process, these changes should also be recorded. Click the Office button> Save or press Ctrl + S. Storage process next workbook will not display the Save As dialog box for workbooks have been called earlier.

3. Saving Workbook by any other name 
To save the workbook with a different name, do the following steps. 

• Select the Office Button> Save As. Save As dialog box appears. 
• Select the folder where the workbook. Type a new file name in the File name text box: 
• Select the type of workbook on the Save as type box: Then hit Save.

4. Change the Default Folder Storage. 
You save a new workbook by default be stored in the My Documents folder. You can make arrangements to change the default folder for storing the new workbook.

• Click the Office Button and then press the button Excel Options. 
• Excel Options dialog box appears, select Save. Type the address of the default storage folder in the text box Default file location:, for example, C: \ Users \ COMPAQ \ Documents.

• Press the OK button to save the settings. After that, the next time you run Excel first time and it will save the new workbook, the workbook is saved in the Reports folder.

5. Closing Workbook 
The completed workbook used should be closed to avoid any possibility of undesirable events, such as the data in the workbook are accidentally deleted. To close the workbook, select one of the following ways:

• Click the Office Button, then press the Close button. 
• Press Ctrl + W key combination on the keyboard.
• Click on the Close icon contained in the workbook Title bar.

If the workbook has not been saved yet been no change since the editing process, a message box appears, as shown in the figure as below.

 
A message box provides information that has been no change workbook because the editing process. Press Yes to save the changes. If the results do not change you want to save press the No button.

6. Setting the recent Display Documents 
When finished using the workbook, the file name will be displayed in recent documents. You can re-open a new workbook used in the Recent Documents list can be set as desired.

• Click the Office Button and then press the button Excel Options. Will Excel Options dialog box appears.

 

• Select the Advanced Options. Type the number of the file name that will be displayed in the text box Show this number of Recent Documents: If the new file name you want to use does not appear in the Recent Documents, fill with niali zero (0). Press the OK.

Actually there are many more that I want to explain, but not today. Which of course I will explain in subsequent postings.Hopefully useful ....!!!