Some Basic Feature in Home Tab in Ms-Excel 2013
Home Tab in Ms-Excel 2013 and its Features
Some groups and its features are already discussed in Home tab ribbon in MS-Word, Like – Bold, Italics, Increase/decrease Font size, etc. Different features are now discuss in detail that are used in MS-Excel.
Borders – Grid of Excel sheet cannot print on the paper. If you want to print the records with border, use this border feature. In this feature there are various types of border and border style with Line color and Line style, you can apply in the selected cells.
Alignment – In
Excel each cell has own alignment in Top to Bottom and Left to Right alignment
Top align, Middle Align, Bottom Align,
Align Left, Center, Align Right.
Indentation – Indentation
allow to increase/decrease spacing from the left border of text in selected
Wrap Text – This feature allow to type in multiple line in a single cell. (Shortcut key- Alt + Enter)
Merge & Center – This feature allow to join the selected cell and aligned to centre.
–This feature allow to
set a color bar and data bar in selected cell according to value automatically.
You can also set the manually formatting in selected cells according to given
- Select the cell where you want to apply
- Click on Conditional Formatting à New Rule
- New Formatting Rule Dialog box will be appear
- Select Format Only cells that
- In Edit the Rule description area select a condition type and give a condition.
- Set a format as you like, click on OK button.
Format as Table – Automatic
set the pre-formatted style in the selected range of table.
Cell Styles – Given pre-style of cell can be applied in the