All language subtitles for 1. Formatting Data in Excel 2016 - 1

In this video you will learn how to format data in Excel formatting controls the look and feel of your

data in Excel worksheets.

It does not impact the way Excel processes your data.

The Home tab contains most of these formatting tools let us format the data in this worksheet to format

a cell or a cell range.

You will need to first select the cells let us select cells 8 3 2 F3 and then in the fourth group click

the bold tool notice that contains of the cell range A3 2 F3 become bold Be Bold Italic and underlined

buttons are toggle switches you'll need to click the button once to turn the attribute on and click

it again to turn it off the default underline style is a single underline click the underline button

down at all to choose double underline you can align the contents of a cell by applying the appropriate

alignment formatting to it.

With the cell range A3 2 F3 selected in the alignment group click the center to Excel Center alliance

the contents of this in to remove the formatting click the formatting tool again to left align the contents

of the cells click the left to excel comes with a large number of foreign families that are installed

on your computer along with excel the font family controls how the text or numbers look in Excel worksheet

can lie is the default font for all Microsoft Office products including Excel click the font family

dropdown you can now see a list of fonts installed on your computer as you hover your mouse over a font

face says life preview feature displays these selected cells in that phone let us select Adrian Excel

displays the contents of the cells 8 3 2 F3 in Adrian to change the font size of the contents click

the font size dropdown let us select 14 Excel displays the contents of the cells 8 3 2 F3 in size 14

you can now choose another size besides those listed by simply typing the desired font size in the font

size box and then press enter if you want to quickly go up or down a font size click the increased font

size or decrease font size button in the font group you can apply border to a cell or a group of cells

to make it easier to read your data to apply a border select the cell all group of cells and click the

arrow next to the border to you can apply a border on all four sides or selectively along the sides

you want select the desired cell border then you apply border to a group of cells it is applied to each

cell in the group sometimes you need to send the a headed text across several columns to make the sheet

look professional you would want to make sure that the label appears centered at the top of the sales

data using the align center tool will make that text appear centered in a particular cell but if you

want to center align the label with respect to the sales data you need to use much and center to select

cells even to F1 in the alignment group click the much and center tool Excel models the selected cells

into one cell and center align the contains.