Excel Home Tab Details

The Excel Home Tab is used to perform common commands such as bold, underline, copy, and
paste. It is also used to apply formats to cells in a worksheet. The table below describes the
commands in each of the groups in the Home Tab.

Paste

To insert data that has been placed on the clipboard into a
worksheet cell, click this button

Cut

This button is used to remove data from a worksheet cell and place
it on the clipboard. Once the data has been placed on the clipboard,
it can be inserted into another cell in the same worksheet or into a
different worksheet

Copy

To copy data from a cell in a worksheet so that it can be placed into
another area of the worksheet, click this button. The data that is
copied is placed on the clipboard.

 

Format Painter

Click this button to apply formatting from one cell in a worksheet
to another cell or range of cells in the same worksheet. Clicking the
button once will apply the formatting to only one other cell or
range. Double-clicking makes it possible to apply the formatting to
more than one cell or range of cells.

 

Clipboard Task Pane Launcher

This button is used to open the Clipboard Task Pane. It is located
in the bottom right corner of the Clipboard Group. The task pane
shows the items that have been added to the Clipboard. Items can
then be pasted into the worksheet.

 

Font Type

This button is used to change the style of the font within a cell or a
range of cells in a worksheet. A list of different font styles will
appear. Move the mouse pointer over the style to see a Live
Preview.

 

Font Size

To change the size of the font in a cell or range of cells in a
worksheet, click this button. Move the mouse pointer over each of
the sizes to see a Live Preview. A list of different font sizes will
appear. Click the desired size to select it.

 

Increase Font Size

This button is used to increase the font size within a cell or range of
cells. Each time the button is clicked, the size of the font increases
by one or two points.

 

Decrease Font Size

Click this button to decrease the size of the font by one or two point
increments. Each time the button is clicked, the size of the font will
decrease one or two point

Bold

To apply bold formatting to a cell or range of cells, click this button

 

Italics

To change the style of the font to italics, click this button.

Underline

Click this button to underline the text in a cell or range of cells.

 

Border

This button is used to apply a border around a cell or a range of
cells.

 

Fill Color

To fill in the background color for a cell or range of cells, click this
button.

 

Font Color

Click this button to change the font for the text in a cell or a range
of cells.

 

Font Settings Dialog
Box Launcher

To open the Format Cells dialog box with the Font Tab selected,
click this button. The button is located in the bottom right corner of
the Font Group.

 

Top Align

To vertically align the text in a cell at the top of the cell or range of
cells, click this button.

 

Middle Align

This button is used to vertically align the text in the middle of a cell.

Bottom Align

Click this button to vertically align the text at the bottom of the cell.

Orientation

To change the way text is displayed in a cell, click this button. The
text will rotate in a different direction each time the button is
clicked.

 

Wrap Text

When working with text in a cell, clicking this button will allow
long text entries to wrap within the cell. When a word won’t fit
within the width of the cell, it will move to the next line. The height
of the cell will expand to accommodate the text.

 

Align Left

To place text or numbers at the left margin of a cell, click this
button. This is the default for all text items that are placed in a cell.

Center

Click this button to center text or numbers within a cell.

Align Right

This button is used to align text or number entries at the right
margin of a cell. This is the default for all numbers that are placed
in a cell.

Decrease Indent

An indent creates a temporary left margin within a cell. To decrease
this temporary margin, click this button.

Increase Indent

An indent is used to set a temporary left margin within a cell. It
usually is set in increments of .5 inches. To increase the temporary
left margin, click this button.

 

Merge and Center

To center text across a range of cells, click this button. The purpose
of this feature is to allow for the placement of a heading across a
range of columns in a worksheet.

 

 

 

Alignment Settings Dialog Box Launcher

This button is used to open the Format Cells dialog box with the
Alignment Tab selected. In this dialog box, it is possible to make
changes to the horizontal and vertical cell alignment, as well as
other alignment options. The button is located in the bottom right
corner of the Alignment Group.

Number Group
Number Format

Click the list arrow for this option to display a list of number
formats. Click the format that is to be applied to the number.

 

Accounting Number
Format

This format will display with a dollar sign and two decimal places.
To select a different number format, such as the Euro symbol, click
this button.

Percent Style

To display the value in the cell or range of cells as a percentage,
click this button.

Comma Style

When this button is clicked, the values in the cell will display with
a comma separator and two decimal places.

Increase Decimal

To increase the number of decimal places that are displayed for a
value, click this button.

Decrease Decimal Click this button to decrease the number of decimal places that are
displayed for a value.

 

Number Format
Dialog Box Launcher

This button is used to open the Format Cells dialog box with the
Numbers Tab selected. It can be found in the lower right corner of
the Number Group. This dialog box is used to make changes to the
format of the numbers in the selected cells in the worksheet.

 

 

 

 

Share This Post

One comment

  • Hi there! Do you know if they make any plugins to safeguard against hackers? I’m kinda paranoid about losing everything I’ve worked hard on. Any suggestions?

Leave a Reply

Your email address will not be published.