In this
tutorial we learn about the Home function of Microsoft Excel.
Clipboard Group :- In this group we can see some
command like Cut, Copy and Paste.When we using this command use remove text one
area sheet to another Microsoft Excel Spreadsheet. When we use the cut
option it removes the selected text after the using command we can insert the
clipboard text into the new location.
Using this command we can also copy this formula text one
are sheet to another Microsoft Excel Spreadsheet.
Font Group:-When we see font group, we can control
the font properties of our text. In this
group we can see the drop down list to the change font type and font changes. We
also see more commands just like Bold, Italic, Text underline. If we need more
setting to improve wer font setting press ctrl + D and change setting as we
wish.
We can see explanation about font group in below image.
Alignment
group:- Using
the group, we can control the position and lawet the text in our worksheet.
Top Alignment-It aligns text to top left.
Middle Alignment- It centered the text
between the top and bottom of the cell.
Bottom Alignment-it align text bottom of the
left.
Align Text Left:- Using this function, we can
do align text to left. Shortcut key
Align Centre:- Using this function, we can
do align text to centre.
Align Text Right:- Using this function, we
can do align text to right.
Decrease Indent:- When we enter any text into the cell and
after we want to indent the text on left side, each time we click the button each time, the selected text
will nudge to the left.
Use
shortcut key to decrease Indent ctrl+alt+shift+tab
Increase Indent:- When we enter any text
into the cell and after we want to indent the text on right side, each time we
click the button each time, the selected text will nudge to the right.
Use
shortcut key to Increase Indent ctrl+alt+tab
Orientation:-
In this option when we rotate the cell content use orientation option and the
select rotation as given in option. Angle counterclockwise, Angle clockwise, Vertical
text, Rotate text up and Rotate text down.
Wrap
Text:- Wrap text is the feature that
wrap the text within a cell. We can also used to described word wrap or any
text that goes to the next line without pressing the enter or return key. Below image shows that how
to use Wrap text?
Merge
and center :- It combines two or
more cells in a spreadsheet or a table into one cell, and then centres the
contents of the new cell.
How
to use merge and centre?
1. First select the range of
the cell, which we want to merge.
2. Click the Home tab, and go
to alignment group
3. And press merge and centre
option and we see the selected range of the cell make a new cell.
Below
sheet shows how to use merge and center?
Number
Format:-
Now we are going to Number group in Home tab and when we see the group we see
drop down list. First of all we discuss about dropdown list. When we click on
drop down list in number format group then we see various option like Number,
Currency, Accounting etc.
Below
image shows that the Number Format drop down list.
Number:- we see drop down list we see top of the list
is Number, the number of decimal places, whether or not the thousands separator
is used, and the format to be used for negative numbers.
Currency :- If we
enter a financial value complete with the dollar sign and two decimal places,
Excel assigns a Currency number format to the cell along with the entry.
Accounting:- The
Accounting format is used for monetary values. But, this format aligns the
currency symbols and decimal points of number in a column.
Long date:- Long
date option convert a number into date. Such as 10-11-15 shows as 10-November-2015.
Time:- Time
option convert a number into Time Format.
Percentage:- If we enter a value representing a percentage as a whole
number followed by the percent sign without any decimal places, Excel assigns
to the cell the Percentage number format that follows this pattern along with
the entry.
Short date:-
Short date option convert a number into date. Such as 10-November-2015 shows as
10-11-15.
Fraction:-
Fraction option convert a number into fraction. Such as when we enter
12/15 shows as 4/5.
Increase Decimal:- In this option we already entered number in
cell or worksheet, we can increase the
number of places that are displayed after the decimal point by using the
Increase Decimal buttons.
Decrease Decimal:- In this option we
already entered number in cell or worksheet, we can decrease the number of
places that are displayed after the decimal point by using the decrease Decimal
buttons.
Use the keyboard shortcut Ctrl+1
to open the Format Cells dialog box.
Styles Group:- In this group we can see
some command like Conditional formatting, Format as table and cells style.
we will learn about Style Group next tutorial.