MS Excel 2007 Full Information Guide

Complete information of MS Excel 2007  

MS Excel 2007 This is one of the programs in MS Office. In which the company can do all the work related to record, salary sheet and office with ease.  

About Excel Window

MS Excel 2007 Full Information Guide

MS 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  

The file that opens in Excel is call a worksheet. A workbook can range from 1 sheet to 255 sheets. In this sheet, we collect our information. For this reason, this program has an extraordinary importance on the basis of its features. Because of which the part today is related to any department in the office of the whole world. This program is definitely use somewhere.  

How to Open MS Excel  

To open MS Excel, first click on the Start button and click on the All Program option. A list of programs will appear in front of you. In which clicking on Microsoft Office, clicking on MS Excel 2007, 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 clicking 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 close.  

Office Button (MS 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.  

Open: – (Ctrl + O) — With this option, you can open the saved file. 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.  

MS Excel 2007 Full Information Guide

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 clicking 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 file to be create. After this click on save, 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 close.  

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 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 it.  

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 make in the open file. When closing it, Computer will show an option of Yes No to Severe. Changing done yes will save. And doing no will stop the old form without saving.  

Formula Tab Microsoft Excel 2007

Formula bar

This box provides the facility to change the text present in the selected cell. Similarly, using formula, adding, subtracting, multiplying, division etc. results in 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

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 clicking on that icon. In this strip there is a clock on the right side. The time and date can be change by double clicking 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 clicking on the text box under the toolbar option in the View menu.  

Menu Bar

This bar consists of various menus. There are many options under all menus. Which can be click and run with the mouse. Study all the menus carefully in the next post.

Related posts

Leave a Comment