Home Tab in MS Excel 2007

Prem Kumar

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 used to underline the text of the active cell.

Border 

It is used to place borders on selected cells.

Shading 

This option is used for color shading on the active cell.

Font Color 

It is used to change the color of the font.

Alignment Group

Top Align

This option is used to place the position of the text in the cell at the top.

Middle Align 

This option is used to keep the position of the text in the cell at the middle.

Bottom Align 

This option is used to place the position of the text in the cell at the bottom.

Orientation

This option is used to change the direction of text in a cell.

Align Text Left (Ctrl+L)

 This option is used to position the text in the cell in the left side.

Center (Ctrl+E)

This option is used to keep the position of the text in the cell in the center.

Align Text Right (Ctrl+R)

This option is used to place the position of the text in the cell in the right side.

Decrease Indent (Ctrl+Alt+Shift+Tab) 

 This is done to extend the paragraph of the active cell to the left.

Increase Indent (Ctrl+Alt+Tab) 

They are used to extend the paragraph of the active cell to the right side.

Wrap Text 

After activating this option, when the column width is filled with the text, the text to be written will be automatically moved from the new line in the same row.

Merge & Center

This option is used to convert more than one selected cell into a cell.

Number Group

With the option found in this group, the data type of the active cell can be changed. Such as - text, number, date, time, currency etc.

Style Group

Conditional Formatting 

With the help of this option we use a format with conditions on selected cells.

Format as Table 

With the help of this option, to convert the selected range to table format.

Cell Styles 

With the help of this option we can apply a preset cell design format to the selected cell.

Cells Group 


Insert 

With the help of this option we can add a new cell, row or column on the active position in the sheet and add a new worksheet to the current workbook.

Delete 

With the help of this option, we can delete the active cell, row or column on the active position in the sheet and delete the current worksheet from the current workbook.

Format

There are many options in this option, which are used to modify the width of row, column and hide or show the row, column or worksheet. Also the sheet is renamed and change color of sheet tab.

Editing Group

Sort & Filter

In this option, the sort option is used to sort the data of the table in increasing or decreasing order and the filter option is used to view the filtering of any record in the table.

Find & Select

Find (Ctrl+F)

This option is used to find any text in a file.

Replace (Ctrl+H)

This option is used to replace a word in a file with another word.

Goto (Ctrl+G)

With this option, we can directly access any cell in the sheet from its address.

Goto Special

With this option, we arrive at a particular thing like content, formula, comments etc.

Select All (Ctrl+A)

This option is used to select all the contents present in the file simultaneously.





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