Insert Tab in MS Excel 2007

Prem Kumar

                                                                       Insert Tab

In the Insert tab of Excel 2007, the options are placed in which some inserts are done in the worksheet.

Tables Group 


Pivot Table 

With this option, which normal table is used to convert into a pivot table. In this, we can put the fields of the normal table in special order.


Pivot Chart

With this option, we can create a pivot chart for the data of a column of the current table and the value from one or more columns for it from the worksheet.

Table

This option is used to convert any normal range in the sheet into a special table format. And you can modify the table using the options of the design tab that comes with it.


Illustrations Group 


Picture 

Using this option, you can add a picture to a worksheet by selecting a picture from a picture present in the computer system.


ClipArt 

This is also a type of picture that comes in the Office Collection that comes with MS Office. These can also be selected and added to the file.


Shapes 

This option provides the different types of shapes that can be added to the file and we can modify it easily.


Smart Art

With the help of this option, information is displayed by special types of shapes. Diagrams like pyramids, bicycles, herbal etc. can be made in it.


Charts Group 

With the help of this option, we can create a chart of some data and its value from the table like a graph chart, like a column chart, pie chart, etc.



Links Group


Hyperlink (Ctrl+K)

With the help of this option, we can link any other file in a cell of a worksheet. And by clicking the link on the same cell with the mouse, you can open the file.


Text Group 


Text Box  

With this option, a box can be created in the file in which text can be written.


Header & Footer 


Header

It is in the top margin of the page, in this we can type any text which will be added on every page of the file.


Footer

It is in the lower margin of the page, in this we can insert any text, page number, number of page etc., which will be added on every page of the file.

Note - This can be seen in the page layout view or print preview.


WordArt 

This is a kind of graphical text, which also has many styles. Which helps in creating the cover page of the project file etc.


Object 

With this option, we create our own file in any other program like Word, Power point, Notepad, Photoshop etc. Can be brought directly into the sheet of Excel or work can be done in it and it can be brought on the sheet.


Symbol

With the help of this option, different types of symbols can be added to the cells of the worksheet.

Comments

Post a Comment

Popular posts from this blog

Formulas Tab in MS Excel 2007

Prem Kumar
Image
  Formulas Tab Function Library Group Insert Functions  With the help of this option, we can edit the function (formula) of the current cell and insert the new function in the new cell. Apart from this, you can take offline help    related to the function.                Auto Sum With the help of this option, you can automatically add a range in the sheet in which the number data is written.                Recently Used            In this option, functions are found which have been used recently.                Financial            Financial options are available in this option. Like - PMT, PV, FV etc.                Logical            Logical functions are available in this option...
Read more

Office Button in MS Excel 2007

Prem Kumar
Image
  The same options are available in the MS Excel 2007 office button, which are found in the MS Word and MS PowerPoint 2007 office buttons. New - Ctrl+O :-  This option is used to add a new workbook file. Open - Ctrl+O :-  This option is used to open a workbook file that we saved earlier. Save - Ctrl+S :-  By this option we can save the current data in the current worksheet or workbook file. Save As - F12 :-  This option is used to save a new separate workbook file. Print :-  It has the following three options - Ctrl+P :-  It is used to print the worksheet, using this option you can select the printer, set the page range and you can also set how many copies to print. Quick Print :-  This option is used to print directly on the print settings set last. Print Preview - Ctrl+F2 :-  Using this option, we can see what the matter we are printing will look like when it is printed. Encrypt Document (Prepare) :-  With this option we put a password...
Read more

Home Tab in MS Excel 2007

Prem Kumar
Image
The main options are kept in the Home Tab of MS Excel 2007 which are more needed. Clipboard Group Cut (Ctrl+X) This option is used to cut selected content and save it in the clipboard. Copy (Copy+C) This option is used to copy selected content and save it to the clipboard. Paste (Ctrl+V) This option is used to access cut or copied content in the new range in the same sheet.  Format Painter  Through this option, we can copy the format on any cell and apply it on the new cell. Font Group Font  This option is used to change the font of the active cell. Font Size  This option is used to change the font size of the active cell. Increase Font Size  This option is used to increase the size of the font. Decrease Font Size    This option is used to reduce the font size. Bold (Ctrl+B) It is used to make the text of the active cell appear thick or dark.  Italic (Ctrl+I) It is used to make the text of the active cell appear italic. Underline (Ctrl+U) It is us...
Read more