Microsoft Excel 2007 is one of the best programs in MS Office. In which the company can do all the work related to record, salary sheet and office with ease.
About Window in Microsoft Excel 2007
Microsoft Excel 2007 window provides various features as toolbars for working with worksheets. So that by using these toolbars, you can easily conclude the work done in the worksheet.
About the Work Book in Microsoft Excel 2007
The file that opens in Microsoft Excel 2007 is called a worksheet. A workbook can range from 1 sheet to 255 sheets. In this sheet, we collect our information.
For this reason, this program, Microsoft Excel 2007, has extraordinary importance on the basis of its features.
Because of this, the part today is related to any department in the office of the whole world. This program is definitely used somewhere.
How to Open MS Excel
To open MS Excel, first, click on the Start button and then click on the All Programs option. A list of programs will appear in front of you.
In which click on Microsoft Office, click on MS Excel 2007, and the MS Excel program will open in front of you.
Expand the screen portion of MS Excel 2007
We are now elaborating on every part of the appearance and its work.
Title Bar
It contains the name of the program and file on the left side. And on the right side there are Minimize, Maximize, Close buttons.
Minimize
Through this, the program is truncat as an icon in the task bar. Then open the program by click on that icon again. In this way, we can shorten many programs and put them in the task bar.
Maximize
Through this program can be spread across the screen.
Close:
Through this program can be a close program, Microsoft Excel 2007.
Office Button in Microsoft Excel 2007
With this option you can open a new document and you can save your file as well as you can easily if you want to print your file.
New (Ctrl+N): Use this option to open a new file in Microsoft Excel 2007.
Open (Ctrl+O): With this option, you can open the saved file in Microsoft Excel 2007. That is the file you have already created with a name. Clicking on this option to open that file again will show the dialog box shown below.
From the drop-down list of Look in, select the drive or directory in which the file is present.
The names of the files will appear in the window below, select one of those files and click on the open button.
Or double-click on that name. Or by typing the name of the file in the file name box click on the Open button to open. From the drop-down list of File of Type select the type of file to open.
And if you want to see the name of each type of file in the window. So select All file from the same drop-down list.
Save (Ctrl + S)
Use this option to save the opened file.
Note: If the file is not, then click on Save, the Dialog box will open. From the drop-down list of Look in, select the drive or directory in which to save the file.
Then type the new name in the file name box. And from the drop-down list of save as type, select the style of the file to be created. After this click on “save,” and the file will be saved.
Save As: – (Ctrl + Alt + S) – You can create a copy of the opened file with a different name. The newly created file will open. And the old file will be closed.
Print (Ctrl + P): – prints the file opened by it.
Prepare: – With this option, you can set the properties keyword in your blog. And also you can lock your file with a Password. Which will make your file secure.
Send to: – Through this option, you can send your file to the internet through the option.
Properties
In this write all the information related to your file. On clicking on it, the following property bar will appear. In which details related to the file will be present. Apart from this, if you want to write brief information related to the file, you can write it by clicking on Summary Button. Apart from this, you can get the information related to the file by clicking on the tab button present in Microsoft Excel 2007.
Publish: With this option, you can publish your blog or website to a written post.
Close: (Ctrl+F4) – Use this to close an open file.
Note: If any kind of change has been made in the open file. When closing it, Computer will show an option of Yes or No to Severe. Changing done yes will save. And doing no will stop the old form without saving.
Formula Bar in Microsoft Excel 2007
This box provides the facility to change the text present in the selected cell. Similarly, using a formula, adding, subtracting, multiplying, division, etc. results in the formula bar.
Method: First, select the cell in which formatting is to be done. Then click in the box of the formula bar and enter after formatting.
Taskbar in Microsoft Excel 2007
This bar has a Start button on the left side. By which we can open the program. And you can keep the open program as an icon by minimizing it in the taskbar.
And you can open it again by click on that icon. In this strip there is a clock on the right side. The time and date can be change by double click on it.
Note – For linking more than one text box and moving the box in different directions. The following toolboxes use the tool.
If this tool is not show when you create a text box, you can start the tool by click on the text box under the toolbar option in the Insert Tab.
Menu Bar in Microsoft Excel 2007
This bar consists of various menus in Microsoft Excel 2007. There are many options under all tab. Which can be click and run with the mouse. Study all the menus carefully in the next post in Microsoft Excel 2007.